Using scripts with multiple databases
akimchi
Posts: 2
We did not purchase SqlCompare yet. I checked the basic SQL-Compare and like its functionality.
The problem I see in using it is that I can compare only 2 databases at a time.
Our situation is that our system involves a set of ~30 dbs (MS-SQL 2000, soon will migrate to 2005), all of them are working cooperatively. So we have these 30 dbs on our test-server as well as on the production server.
What I need the product to do is to compare the whole set of 30 dbs between the QA and production servers (or any two servers) and report discrepancies in the schema - tables, views, stored-procs etc, between each matching pair of these.
That mean: compare db1 on QA and production, compare db2 on QA and production, etc.
Does this feature exist in the standard configuration?
Does it exist in the sql-compare-PRO?
Thanks, Avi
The problem I see in using it is that I can compare only 2 databases at a time.
Our situation is that our system involves a set of ~30 dbs (MS-SQL 2000, soon will migrate to 2005), all of them are working cooperatively. So we have these 30 dbs on our test-server as well as on the production server.
What I need the product to do is to compare the whole set of 30 dbs between the QA and production servers (or any two servers) and report discrepancies in the schema - tables, views, stored-procs etc, between each matching pair of these.
That mean: compare db1 on QA and production, compare db2 on QA and production, etc.
Does this feature exist in the standard configuration?
Does it exist in the sql-compare-PRO?
Thanks, Avi
Comments
You should be able to achieve what you need to do by using the command line interface to SQL Data Compare. This feature is only available with the Pro release.
Here is some information on the command line functionality:
http://help.red-gate.com/help/SQLDataCo ... dLine.html
I hope it is useful.
Let me know if you need any more information.