question

Manvendra avatar image
Manvendra asked

Db Comparison

Hi, Is there is any tool or any way to compare only DDL statements of two different Databases. Both Databases are in different servers in SQL Server, but with common login name. Source DB is in SQL Server 2005 and Target DB is SQL server 2008. Just i want to know the DDL differences. Any assistance is really appreciated. Thanks Maddy
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
Try out Red-Gate's [SQL Compare][1] it does schema comparisons and shows them up in a nice window to compare source and target systems. They have a 14 day trial, and it is not expensive to buy if you use it alot. They also have loads of other great tools - check the website out. [1]: https://www.red-gate.com/products/SQL_Compare/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
There are lots, some are free, some are free to trial others are only available under purchased license. In no particular order there are products from [ www.atlantis-interactive.co.uk][1], [RedGateSoftware][2] [Edit] removed references to Quest and Idera as they dont do comparison tools [1]: http://www.atlantis-interactive.co.uk [2]: http://www.red-gate.com
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 for the others. Idera and Quest have never been that appealing to me, I didn't know they had a schema comparison tool. I really have to take a closer look at the atlantis-interactive stuff though. I took a short look at SQLEverywhere a while back and then stopped. Shame on me!
0 Likes 0 ·
Take a look at the compare tools from Matt Withfields company http://www.atlantis-interactive.co.uk/
0 Likes 0 ·
@WilliamD - I took it for read that Quest do one... maybe they dont. I'll check and remove them if there isnt one. BRB
0 Likes 0 ·
Well, it appears that I need to strike out two of my links. Quest and Idera dont play this game.
0 Likes 0 ·
@Fatherjack - thanks for checking that out. I really wasn't sure, they both field tools quite often so it wouldn't have surprised me if they had the tools. I prefer red-gate above those two (don't know why) - but Matt has done some amazing work and is sneaking up on the outside!
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Piling on at this point, but what the heck. I'm a huge fan of Red Gate's SQL Compare. I've been using it since it came out, eleven years ago. But I've also looked at Atlantis-Interactives compare utility. It's great. There is a compare utility built into Micrsosoft's Visual Studio 2010. It's not so hot, but it's functional & there if you already have VS2010. Idera has one, but I haven't looked at it. Embarcadero has one that will work with multiple platforms, oracle, db2. It's functional, but I think it's a bit of a pig, large & slow.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered
Well, just to show I am not biased - nobody has mentioned [Apex SQL Diff][1]... I can definitely say that is a fine product. There are, in fact, hundreds of compare tools, and each one will do things slightly differently - each one has weaknesses and strengths, and it's a matter of really finding out which one will work best for you. AFAIK, There's only one schema tool that works on Denali right now though! :) [1]: http://www.apexsql.com/sql_tools_diff.aspx
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+1 - for making a tool that supports a version no-one is using yet.... ;)
1 Like 1 ·
Woohoo! Spod points :)
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.