Compare two databases 1

[Korach]

Hi everyone,

Do you know how to compare two databases? Do you know if there is a tool for that?

I made many changes to my development database and I made these changes in the production database too. I now want to check if all tables, procedures, triggers etc. are the same in both databases.

Thanks

 

[JamesLean]

There is a third-party tool called SQL Compare which may be what you're looking for. I've never used it myself but here's some info:

http://www.red-gate.com/SQL_Compare.htm

--James

 

[Korach]

Thanks! That's exactly what I need.