Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Tool to compare table definitions

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-03-03 : 17:17:17
Does anyone know a good tool to compare table definitions?

I know sqlcompare can do that. And there are similar tools by Idera and redgate. However I need a free tool or probably sql code which is reliable.

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-03 : 17:44:36
SQL Compare is made by Red Gate.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-03-06 : 01:57:26
AdeptSql
Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-03-06 : 06:39:39
i like to use xSQL as its free and also support non english characters.
Go to Top of Page

Itamar
Starting Member

19 Posts

Posted - 2009-03-16 : 15:19:34
Hi there.
You have Nob Hill's compare tool, its good for data and Schema compare ( in SQL or MySQL )

http://nobhillsoft.com/NHDBCompare

http://www.nobhillsoft.com
Database tools, SQL,MySQL...
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2009-03-16 : 15:31:39
It is NOT free!

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

Itamar
Starting Member

19 Posts

Posted - 2009-03-18 : 13:49:46
Ravilobo -
You are right, it used to be free for few months, now its for 50$

Nob Hill Software - Tools for Database People
SQL Version Control, Database Compare, Query Tools and more. www.nobhillsoft.com
Go to Top of Page

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-18 : 14:01:23
SQL compare has a 15 day trial period I think.
Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-03-19 : 08:52:40
http://www.xsqlsoftware.com/?src=xSQLDataCompare
Go to Top of Page

pjstreiff
Starting Member

12 Posts

Posted - 2009-03-26 : 14:05:40
Here are some free db compare tools I found:
http://www.starinix.com/sqlcompare02.htm
http://www.yessoft.com/dotnetnuke/
http://www.sqleffects.com/sqlAccordDetails.html (Community Edition)

Quest used to have a nice free one called SQL Comparison Suite but it is no longer free.

Thanks,


-pjstreiff
Go to Top of Page
   

- Advertisement -