How to detect diferences between 2 databases

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
www.red-gate.com
Andrew J. Kelly SQL MVP
"JLobo" <JLobo@.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
|||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
"JLobo" <JLobo@.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