Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tool to compare SQL Structure and update
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01541657
Message ID:
01541670
Vues:
23
>>>>Yes, you install it on your development server. You need to keep one version of the database which is the current version and one which is development. Once you ready to sync them, you run that tool and it generates the changes script which you then give to the customer to run. And then that version of the database becomes the current version.
>>>
>>>I was hoping that I would not have to keep a copy of each customer database in my system, for comparison. Thank you.
>>
>>The structural copy, not the copy of their database. Assuming all customers are running with the same structure.
>
>Not in my case. The approach that you suggested is better than what I do now, however.

For now you can also probably go with the free tools (Red Gate may be expensive). I believe in that thread I referenced another thread which in turns provides a link to a free solution.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform