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:
01531992
Views:
39
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform