May 3, 2011 at 8:43 am
Hi,
We have a database what we have been working on for a long time. One of the new member of the team when into the database and changed a lot of database stuff. He added additional tables, added columns to existing tables, changed data types (e.i. bit to int or varchar to nvarchar) to an existing tables and God knows what else has changed. The sad thing is that he doesn't remember exactly what he changed.
My question is, if I have a backup database before change, and I restore the DB with a different name, is there any tool/script that would tell me what has changed, or any other ideas?
Thanks in advance,
May 3, 2011 at 8:47 am
May 3, 2011 at 10:42 am
I agree, Red Gate SQL Compare. What's more, you don't have to run a restore. SQL Compare can read a backup and compare the backup to your database.
"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
May 3, 2011 at 8:16 pm
You might not even need to do that - depending on how long ago the changes were made and how much data is kept in the default trace.
You can run the Schema Changes History report on that database and it will show you all changes that have been made that are still available in the default trace.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply