September 1, 2009 at 1:52 pm
How can i compare objects in 2 similar databases including indexes. I would like to check if both databases has same tables and indexes.
September 1, 2009 at 2:37 pm
RedGate has a tool called SQLCompare that can do this for you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 1, 2009 at 2:39 pm
Alternatively, script the tables and indexes from both databases and then use something like beyondcompare to see if / where there are differences
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 2, 2009 at 7:17 am
Is there a way i can check if i have all the indexes in a database through a query. I have 34 indexes in all the databases which is consistent and will never change anytime and would like to verify if all the indexes are present in a database.
September 3, 2009 at 7:52 am
I'm pretty certain there are several scripts that could do that for you in the Scripts section over on the left. Do a couple of searches there and I think you'll find what you need. I'd use the word 'compare' for the search.
"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