January 17, 2007 at 4:17 am
Hello Friends,
How can I compare the schema of two different database? Is there any free tools or software?
January 17, 2007 at 6:13 am
I have used SQL Compare from Redgate. It's a neat tool and also generate SQL scripts for the differences in the Schema. There is a 14-day trial version available.
For more info, see
http://www.redgate.com/products/SQL_Compare/index.htm
January 18, 2007 at 12:05 am
Thank for your reply. But I'm looking a open source or free software for comparing the db schema.
January 18, 2007 at 12:51 am
Here you go free tool..
http://www.sql-server-performance.com/news_releases/xsql_software_20060705.asp
MohammedU
Microsoft SQL Server MVP
January 18, 2007 at 10:07 am
I know you are looking for a free tool - but SQL Compare is still worth serious consideration - the cost is nominal and the product is fast and reliable. The company I work for had "standardized" on another tool - but I found it took over 30 minutes to compare the schema on our 2 largest databases and wasn't 100% accurate. SQL Compare runs in about 90 seconds, is highly configurable and has proven 100% accurate in locating differences.
Regards,
Harley
January 24, 2007 at 12:59 pm
for a free tool, one thing you could do is generate scripts for both schemas using this:
http://www.elsasoft.org/tools.htm
and then compare the result with windiff or similar.
---------------------------------------
elsasoft.org
January 24, 2007 at 10:00 pm
Thank you very much for your suggestion.
I will try it.
January 24, 2007 at 10:46 pm
I forgot to mention that for scriptdb.exe, the source is freely available so you can modify it as you see fit if it doesn't meet your needs as is.
It's implemented in C#, and the code is very straightforward.
---------------------------------------
elsasoft.org
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply