August 14, 2011 at 1:48 pm
The indexes on the Test database on Test server are out of sync with PROD database on Prod_server, client is requesting that the TEST index be updated to match the PROD indexes.
Can any one tell me how to do as i am not much aware of development.
please any one guide how to do......
Thankyou......
August 14, 2011 at 2:16 pm
Easiest way is probably with something like Redgate's SQLCompare. If buying that's not an option, drop the indexes on dev, script the create index statements from prod and run them on dev.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2011 at 3:55 pm
Any reason you can't just restore the latest prod backup to get everything back in sync?
August 14, 2011 at 7:42 pm
Even if you cannot afford SQL Compare now - or convince management of it's usefulness, download the trial edition and use it to synchronize the systems.
Use the tool to generate a report of the differences and save the script that will be used for the synchronization, then synchronize the databases.
Once you have all that, take it back to management and show them how easy it was to do this. You will have a very good use case for the purchase of the tool.
I use this tool all the time, it has already paid for itself - multiple times now.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2011 at 5:40 am
Also, if your servers are getting that out of sync, you might want to reexamine your development and deployment processes. Tools like SQL Compare will help a lot, but having a good, well-documented, process that you follow will help even more.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply