Alternative to Red Gate SQL Compare

[Fuma]

What open source software can I use to compare SQL Server databases would you recommend?

 

[MrGray]

http://dbcomparer.com/

Edit: Not open source but free. Works well.

 

[Pho3nix]

Visual Studio? Not open source it free though..

 

[freddster]

Why an alternative? You're not happy with Redgate SQL compare?

 

[ColinR]

Visual Studio Database Projects are all you need.

 

[Fuma]

Thanks guys. I will try VS option. My colleagues though said they were not happy with it.
I will try the DBComparer one as well.

 

[Shi]

Is this a once off exercise or something that you will be running on a regular basis. At a previous company we used Red Gate SQL Compare previously to aid with the automatic deployment of DB changes. We were very happy with it.

 

[Fuma]

Is this a once off exercise or something that you will be running on a regular basis. At a previous company we used Red Gate SQL Compare previously to aid with the automatic deployment of DB changes. We were very happy with it.

It is not a once off thing and unfortunately we haven't bought Red Gate SQL Compare hence open source alternative.

 

[Pho3nix]

It is not a once off thing and unfortunately we haven't bought Red Gate SQL Compare hence open source alternative.

Visual Studio should work fine for the most part then.

 

[[)roi(]]

You can also use open source ETLs (extract, transform, load) and there sre quite a few, I'll name only the ones I've used and liked i.e. both are capable products.

1. Pentaho Kettle
2. Talend.

Both are simple to install and work on code generation, meaning the ETL processes are turned into code, which you compile and then these compiled modules can run anywhere.

 

[callisto]

<offtopic/>I've used Red Gate over a number of years. At the latest place I am working there wasn't a license, so I tried APEX Sql for a while. Good, but not free, and not better than RedGate. The only thing Apex as got right is their free SQL Complete tool which I use in SSMS extensively (RedGate charges $399 for theirs)