About Us   SSWUG Articles   Articles   FAQ   Administration   Backup/Restore   Connectivity   Development   General   Installation   OLAP   Replication   Transfer/move   Trouble   SQL 6.5   Scripts   Tips   Test Exams   Advertise   Download   History   Search   Traffic   Related Links         Add to Favorites

How can I compare two databases? Answer: You can use red-gate SQL compare to do this. It can compare tables, constraints, rules, stored procedures and creates a script for applying the changes from one database to another. You can download the 14 days trial version at here: http://www.red-gate.com You can use the following scripts from the swynk.com: http://www.swynk.com/downloads/objcompare.zip This program is similar to Sqlcomp from Backoffice Resource Kit. With this program your can compare Stored Procedures and Views from different servers (example: Production and Developer) and versions (6.5 and 7.0). http://www.swynk.com/downloads/sp_db_comp.sql This script will compare all tables in two databases including column names, datatypes and NULL options. It also lists tables that exist only in one of databases. http://www.swynk.com/downloads/sp_ABCompareDb.sql Compare a source and target database. List all procedures, tables, views, and triggers on the source that either don't exist on the target, or are later on the source than the target machine. This is useful when a series of changed objects need to be installed from a development server to a production server. See also this link: How can I compare the data in two tables with identical structure?

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators. (c) 1997, 2005 Bits on the Wire, Inc