Are there any free alternatives to Red Gate's tools like SQL Compare

Question

Any tools as useful as these?

Answer 1

I know ApexSQL have a free trial - it's worth a try if you're in imediate need of making a compare ;)

http://www.apexsql.com/

Answer 2

Open DBDiff

Answer 3

You can also use Visual Studio Team System for Datatabase Prefessionals. Certainly not free, but worth your time if you happen to have an MSDN Universal license.

Answer 4

look at this list of Free Tools for SQL Server. you'll definitely find something worth your while there

Answer 5

I've been looking for the same thing for a while, but couldn't find any tool that's as easy to use as RedGate SQL Toolbelt. I end up buying it, it was a money well spent!

Answer 6

http://www.xsqlsoftware.com/ xSQL Software has a FREE LITE edition of xSQL Object

xSQL Object Compare and Synchronize Database Schema

FREE LITE EDITION

One of the fastest, most robust SQL Server database schema comparison and synchronization tools in the market.

*
  Sql Server cross version comparison and synchronization
*
  Safe, standardized, version-specific scripts
*
  xSQL Object Command Line utility

Answer 7

There are a lot of open-source tools (NUnit comes to mind and TortoiseSVN) that make life easier, are of very high quality and are free. Sometimes, though, you just have to recognize that this is your livelihood and that you'll have to bite the bullet and invest in yourself. The trick, then, is to make sure you only spend money on tools that really do provide value.

In the case of SQL Compare, specifically, all I can tell you is that I used to spend hours and hours of time verifying and executing DDL upgrade code before each new release of our web product. After getting SQL Compare, that entire category of work has been almost completely taken off of my plate. Outside of my reporting tool, it is the most useful tool in my kit.

Answer 8

CompareData is free for comparing table/view data

Answer 9

Well, our own SQL comparison tool (dbForge Schema Compare for SQL Server) is not a free one, but i think you might be interested in opportunity of getting a free license, just refer to free license conditions page.