I have been using SQL Compare by Redgate at my company and was very satisfied with it. Are there any free comparison tools that are similar? Or what would be my best shot for synchronizing two SQL db's without a paid application
+3
A:
You can try using TableDiff , that came with SQL Server 2005.
SQL Server 2005 TableDiff Utility
Bye.
RRUZ
2009-08-29 23:17:06
Only problem with Tablediff is that there's no GUI with it.
Jaimal Chohan
2009-08-29 23:35:50
+1
A:
I had the same problem and wanted a free GUI base Schema comparer tool, what I found was Star Inix (http://www.starinix.com/sqlcompare02.htm). Obviously not as good as Redgates offering, but it does the job.
Also, with Redgate Sql Compare, once the trial period is over, if you enter the key as "i need more time" (without the quotes) you can extend the trial by a further 14 days.
Jaimal Chohan
2009-08-29 23:34:56
+1
A:
I’ve gone through this and couldn’t find anything comparable, free or otherwise. $395 is a very small price to pay for the value the tool brings and it will almost certainly pay for itself very quickly in productivity gains and risk minimisation.
Troy Hunt
2009-08-29 23:41:17
The limitations on this are that a) unlimited use with Sql Express editions only b) limited to 25 tables or 40 SP's or 40 Functions or 40 Views for any other version of Sql Server.
Jaimal Chohan
2009-08-29 23:47:06
+1
A:
I normally go for the hackish but surprisingly effective technique of downloading the sys_information tables to text files and diffing them with your favorite diff program (this way will even let you compare 3 schemas!).
David Raznick
2009-08-30 02:02:21
A:
You can use Database Comparer
Database Comparer is free for non-commercial use.
Hugues Van Landeghem
2009-08-30 13:26:30
A:
We can recommend you a reliable SQL comparison tool that offer 3 time’s faster comparison and synchronization of table data in your SQL Server databases. It's dbForge Data Compare for SQL Server.
Main advantages:
- Speedier comparison and synchronization of large databases
- Support of native SQL Server backups
- Custom mapping of tables, columns, and schemas
- Multiple options to tune your comparison and synchronization
- Generating comparison and synchronization reports
Plus free 30-day trial and risk-free purchase with 30-day money back guarantee.
Devart
2010-04-12 10:33:41
A:
Have a look at Mighty Comparer. It's currently free. A professional version is under development.
Cristian B
2010-07-17 07:20:18