SQL compare DB

[SQLScholar]

Hey all,

I have been using a tool called "SQL server Compare" which compares two DB`s and tells the differences.

Does anyone know of a similar tool that will give the same, but also with update scripts that if run will make DB1 the same as DB2 (add/remove columns etc)

Cheers

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
- Dr. Seuss
----------------------------------------

 

[ptheriault]

Speed Change Manager by Idera. I've been using it for awhile now. It can script changes to either server A or B. So it will add or remove objects based on your needs.

- Paul
- Database performance looks fine, it must be the Network!

 

[Catadmin]

Erwin by Computer associates can compare two databases and make changes to both or one with it's Complete Compare functionality.

Erwin is mainly a data modeling tool, but this functionality is within it if you already have a copy.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"