January 13, 2014 at 2:05 am
Scenario:
Single dB on an instance, used by an ERP application.
Another totally separate business has the same setup, using the same ERP system.
Although the tables will (should) be identical I need to compare views and triggers as different DBAs have worked on both sites and the ERP system has developer licensing.
What is the quickest way to create a report on such information? Is it even possible to run something that I can review and check for similarities and differences?
January 13, 2014 at 5:04 am
I've been using a 3rd party tool to do that for the last 15 years. Actually, I liked their tooling so much, I went to work for that company about 3 years ago. It's called Red Gate SQL Compare[/url]. It does exactly what you're looking for and 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
January 14, 2014 at 1:18 am
Thanks grant.
Anyone else?
Is 3rd party the only way to get this information?
January 14, 2014 at 3:52 am
If you do a search in the scripts section here on SSC I'm pretty sure there are one or two T-SQL scripts that can do some compares. But they're seriously limited in my experience.
"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
January 14, 2014 at 6:28 pm
Second Grant. We use RedGate SQL Compare and Data Compare for over 4 years and it allows us do a lot of things you cannot do with a script.
January 15, 2014 at 6:35 am
I believe SQL Server Data Tools (SSDT) has in built schema and data compare as well.
It's not as extensive as Red Gate's Tool but it may well be all you want.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply