Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Generate Index script
Message
 
À
31/12/2011 12:45:09
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01531981
Message ID:
01532056
Vues:
38
>My development system uses SQL 2008.
>A client uses SQL 2000.
>
>I routinely add indexes to tables during development and then I write a script to add that index to the client's 2K system.
>
>I think I've missed a few over the years.
>
>Is there a way that I can generate a script on the 2008 system that will allow me to update the indexex on the 2K system?
>
>I've seen a few things on the web that might do it, but nothing that seems certain.
>
>Any idea?

VS2010 Premium and above have SQL compare and synchronize database schemas and actual data. works GREAT!

RedGate has comparable tools (you pay extra for them) that work very well.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform