>Does anyone know of a tool for SQL Server 7 that can be used to move database structure changes from one copy of the database to another?
>
>By this I mean: say you have two databases (production and development) they start out identical and you make changes to the development database (new tables, fields, indexes, triggers, etc). I want a tool that will read the schemas of both databases and create a script to update the production database so it is exactly like the development one (data excluded).
>
>Yes I know you can keep track of all the changes, but in real life we always seem to lose a couple.
>
>Thanks in advance.
>
>Jacob Bruner
>jacob@classycomponents.com


In addition to the tools methioned there is also Sybase Data Architech and also xCase Professional.

Of course, what you would do, is once you have the tool modify the model, and it will generate the change scripts... if all is well you can then run the script against the production data.

BOb