Database diff

[suityou01]

Used a tool once called Embarcadero Studio, that diffed schemas. ClientCo have deep pockets, but I found out that their permy staff have been asking for this product for donkeys and got precisely nowhere.

Then I began to wonder, if anyone knows of some script or code snippet lurking somewhere that is a starter for 50 for doing a schema diff.

This is for SQL Server.

Inputs = two different DBs. Outputs = some change scripts for all the changed DB objects eg tables, sps, udfs etc.

 

[DimPrawn]

http://www.red-gate.com/products/index.htm

Very good stuff and not expensive.

 

[London75]

WinSQL used to be able to do that I think.

go on www.sql-server-performance.com I think they always used to tout some tool or other.

 

[ControlG]

I used the lite (free ) version of this for my own use some time ago.

IIRC the UI was a bit peculiar but it worked fine and it was free.

I also use SQLCompare from Redgate and can't speak highly enough of that.