Re: DB Versioning options

Brad White wrote:

"Eddie Shipman" <mr_delphi_developer@xxxxxxxxxxxxxxx> wrote in
message news:xn0f2er6u2aq22002@xxxxxxxxxxxxxxxxxxxxx
Brad White wrote:

"Eddie Shipman" <mr_delphi_developer@xxxxxxxxxxxxxxx> wrote in
message news:xn0f2eoon5ci4rb001@xxxxxxxxxxxxxxxxxxxxx
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.

Too bad their free one won't let me test on our SQL server.

I'm not sure if this will work, yet.


The current version doesn't handle data, but I do
already have that request in.
But you already have that part done. So just
run one tool to build the update script, and another
to build the data sync.

I can create the data script but it is built from each table only in
alphabetical order and the DB can't be rebuilt using it because of
constraints/keys.


--

.

Relevant Pages

  • Re: OO vs. RDB challenge
    ... in practice its outweighed by the unfortunate fact that SQL ... > The Relational Model is the best possible layer, ... constraints of the RDBMS" is an attractive idea in theory, ... RDBMS in some other language and show its as easy as using an RDBMS". ...
    (comp.object)
  • Re: loop and recordset
    ... those members whose membership lapsed. ... Use the SQL language to return only the set of required ... This table obviously needs some constraints. ... ALTER TABLE enrollment_2 ADD ...
    (microsoft.public.access.modulesdaovba)
  • Re: loop and recordset
    ... there IS a missing period? ... Could your SQL approach be modified to deal with such a recordset? ... This table obviously needs some constraints. ... ALTER TABLE enrollment_2 ADD ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help: Stored Procedure performance issue.
    ... Please post DDL, so that people do not have to guess what the keys, ... We do not use flags in SQL. ... are no more than n days apart) and other constraints are met (the cargo ...
    (comp.databases.ms-sqlserver)
  • Re: passing an array to stored procedure
    ... source, like VB, and turn it into a proper set. ... Another possiblility that might be good is to use XML. ... Pro SQL Server 2000 Database Design ... Remember to add constraints to the Numbers and Alphas tables, ...
    (microsoft.public.sqlserver.programming)