|
Home > Archive > MS SQL Server Tools > March 2006 > How to detect diferences between 2 databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Andrew J. Kelly 2006-03-21, 11:30 am |
| www.red-gate.com
--
Andrew J. Kelly SQL MVP
"JLobo" <JLobo@discussions.microsoft.com> wrote in message
news:A5AFEF9E-64C0-4CB8-89B4- A56D1E8F4928@microso
ft.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
| |
| Keith Kratochvil 2006-03-21, 11:30 am |
| 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@microso
ft.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
|
|
|
|
|