Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement