February 28, 2003 at 9:39 am
Does anybody have an easy way to copy the indexes from a development server to a production server? We've spent a lot of time tuning and optimizing indexes on the development server and are ready to move them to production. I need a way to easily accomplish this without losing any data in the tables.
February 28, 2003 at 9:54 am
Generate scripts for those indexes from development server and run them in your production server.
February 28, 2003 at 9:59 am
That was what I tried, but in order to get the primary key clusted index, I had to drop the table and I lost all my data. I was trying to avoid that.
February 28, 2003 at 10:09 am
Run sp_helpconstraint to find out primary key constraint name and alter table to drop the constraint. You don't have to drop and recreate the table.
March 3, 2003 at 4:32 am
Why not do an object copy with DTS?
Copy the object into a new table (with the indexes) then move all the data from your old table into the new one with the fresh indexes from development...
Edited by - hanslindgren on 03/03/2003 05:59:45 AM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy