Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generate Index script
Message
 
To
31/12/2011 12:45:09
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01531981
Message ID:
01532056
Views:
37
>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!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform