Synchronise structure of multiple database

Question

Hi,

I have 2 database:

production and to test.

Production should have the same fields and tables like testdatabase.

is there any software, or script to show difference between this two databases?

Answer 1

I like DBComparer and it's free :). A google search for database compare tools should yield other useful links.

I also used SQL Delta one time. It is a fantastic tool with many advanced features but it is not free. You can however download a trial from their website.

Answer 2

I'd recommend Redgate SQL Compare. It's not free but works really nicely and is really easy to use.