The only tool I have seen is SQL Compare, www.sqlcompare.com I think, we
played with it here and were not very impressed. It does with very basic
databases with very little code or complexity, but when we tried it on our
beta to live server and compared large databases with lots of stored
procedures, it was not very intelligent on figuring out what is a change or
just a quirk in the scripting between the two servers.
DBA Services Manager
> Hi all,
> I'm after a third party product that will compare 2 DB's and generate
> scripts on the differences. Ideally it should compare both schema and
> We are developing an SQL7 product and we what to be able to generate
> that can be run on older versions to upgrade their DB's to the current
> level, before installing the new application.
> What do you recommend?
> Remove NOSPAM when replying