Re: DB Versioning options
- From: "Brad White" <bwhite at inebraska.com>
- Date: Tue, 13 Feb 2007 10:58:54 -0600
"Eddie Shipman" <mr_delphi_developer@xxxxxxxxxxxxxxx> wrote in message
news:xn0f2eoon5ci4rb001@xxxxxxxxxxxxxxxxxxxxx
I'd like some ideas about how to effectively do DB versioning.
We currently have no process for handling DB versioning other than
keeping a copy of the DMF or BAK file(s).
We would like to be able to script out the entire DB, including initial
data and be able to rebuild the DB directly from those scripts. Is this
possible?
Is there a tool that can do this and still uphold constraints and key
relationships?
I have written a tool to script out the DB, including data, using
SQLDMO and am working on modifying it to also do SMO. But this tool
will not create the data scripts in the correct order to allow
rebuilding of the tables and still observe the constraints and key
relationships.
Is this what you are looking for?
http://www.berryware.com/all_products.html
We use this extensively and are very satisfied with it.
It handles SQL 2000 databases that have been moved to 2005 just fine.
It does not yet handle all the new features in SQL 2005.
--
HTH,
Brad.
.
- Follow-Ups:
- Re: DB Versioning options
- From: Eddie Shipman
- Re: DB Versioning options
- References:
- DB Versioning options
- From: Eddie Shipman
- DB Versioning options
- Prev by Date: Windows Vista Content Protection
- Next by Date: Re: DB Versioning options
- Previous by thread: DB Versioning options
- Next by thread: Re: DB Versioning options
- Index(es):
Relevant Pages
|
