Errors and Change requests
Thanks for writing Red Gate. I have done some testing on the foreign key
problem, and found that it works correctly, at least with one table, anyway.
The primary key constraint gets done before the foreign key as it should.
I'd like to see a script of your tables to see if there might be something I
The second comment would involve LOTS of storage and network usage on
the client side. Are you sure it wouldn't be better to DTS/backup/replicate
the data to a local database, and run SQL Data Compare against it?
Conditional compare counds like a good idea. We'll have to look into it.
Technical Support Engineer
Red Gate Software Ltd.
+44 870 1600 037
"Geir Ludvigsen" <[email protected]> wrote in message
> First of all, the SQL Compare og Data Compare tools are incredible useful.
> use them synchronizing several development databases from "master" and
> "template" databases. I also use it to upgrade several databases in
> different environments, from development, to test, to production.
> 1. If a table has a foreign key of type SAME TABLE, that means it
> a primary key value in the same table as the foreign key, the generated
> script doesn't script the inserts in correct order. I manually have to
> the insert for the "parent" row above the "child" rows. References between
> columns in different tables works correctly.
> CHANGE REQUESTS
> 1. With SQL Compare you can compare two database snapshots disconnected.
> can save a "stabile" version of a database to compare other databases to.
> But I cannot do the same with SQL Data Compare. For data synchronization I
> have to compare "on-line" to my unstabile development database. It would
> have been really nice if I could save the belonging data together with the
> snapshot of the stabile database.
> 2. We develop on a "master" database and this database has some basic data
> in it. We also have several customer databases which are copies of the
> "master", but can have additional customer specific data in them. To
> distinguish between data that are basic, customer specific, and production
> data, primary keys are INTs and are allocated in three different data
> series. Basic data from 0 to 4999, customer data from 5000 to 9999, and
> production data from 10000 and above. We have developed our own scripts
> clean up the Data Compare scripts. In this way we can remove data above
> synchronizing from "master" to customer database, and remove data above
> 10000 synchronizing from a customer database on the development server to
> the test server. In addition we have scripted to always remove update
> delete commands on specific tables. That means that we insert new rows for
> table, but never update or delete them because they containt environment
> specific data and must be manually updated/deleted.
> Well, now to my request:
> * Ability to specify a WHERE clause for each table. We must be able to
> the WHERE clauses in a template or somewhere so we can use it for later
> * Ability to exclude insert, update or delete commands for each table.
> we must also be able to save in the same template.
> It must be relatively easy to edit these templates.
> Geir Ludvigsen