I am in the process of developing additional features to a client's existing database (which has been running in a production environment for several years).
When the time comes to install the additional modifications I will also be upgrading their database from SQL 7.0 to SQL Server 2K. The plan is to maintain an *.sql file that will then create all additional stored-procedures and tables, and also alter existing tables in the upgraded database to match the development database (which originated itself from the SQL Server 7.0 database from the client's site).
Producing and maintaining the *.sql file to make all these modifications is a fairly pain-free process - but time-consuming.
The question is therefore - Is there a "Compare Databases" utility that can generate the necessary *.sql script to make one database match the other, or in the very least compare two databases and verify their structure is identical??? (
Regards,
Paul Kelly.
When the time comes to install the additional modifications I will also be upgrading their database from SQL 7.0 to SQL Server 2K. The plan is to maintain an *.sql file that will then create all additional stored-procedures and tables, and also alter existing tables in the upgraded database to match the development database (which originated itself from the SQL Server 7.0 database from the client's site).
Producing and maintaining the *.sql file to make all these modifications is a fairly pain-free process - but time-consuming.
The question is therefore - Is there a "Compare Databases" utility that can generate the necessary *.sql script to make one database match the other, or in the very least compare two databases and verify their structure is identical??? (
Regards,
Paul Kelly.