>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!
____________________________________