How to detect diferences between 2 databases

21 Mar 2006 10:08 AM

JLobo

I have a database B on server S and a database B1 o server S1
Is there any tool to give me the diferences between the two databases, new
tables, new fields....

--
JLobo

21 Mar 2006 1:41 PM

Andrew J. Kelly

www.red-gate.com

--
Andrew J. Kelly SQL MVP

Show quote

"JLobo" <JL***@discussions.microsoft.com> wrote in message
news:A5AFEF9E-64C0-4CB8-89B4-A56D1E8F4928@microsoft.com...
>I have a database B on server S and a database B1 o server S1
> Is there any tool to give me the diferences between the two databases, new
> tables, new fields....
> --
> JLobo

21 Mar 2006 1:45 PM

Keith Kratochvil

There are many companies that make tools that do database comparison.
Red Gate is one such company. Their tool - SQL Compare - works very well.
http://www.red-gate.com/

Imceda used to offer Speed Change Manager. http://www.imceda.com Quest
http://www.quest.com/ purchased Imceda a while ago. Quest seems to have
several tools that perform database comparison including CompareRocket for
Visual Studio and Toad for SQL Server.

--
Keith Kratochvil

Show quote

"JLobo" <JL***@discussions.microsoft.com> wrote in message
news:A5AFEF9E-64C0-4CB8-89B4-A56D1E8F4928@microsoft.com...
>I have a database B on server S and a database B1 o server S1
> Is there any tool to give me the diferences between the two databases, new
> tables, new fields....
> --
> JLobo