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:
01531992
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?

You can try using RedGate SQLCompare to generate all structure differences.
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform