CODEWITHSUNDEEP
sql-server-2005
user278618
user278618

Reputation: 20222

Synchronise structure of multiple database

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?

Upvotes: 0

Views: 43

Answers (2)

Jorge Ferreira
Jorge Ferreira

Reputation: 97839

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.

Upvotes: 1

Matthew Dresser
Matthew Dresser

Reputation: 11442

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

Upvotes: 1

Related Questions