Comparing the schemas of two databases

Hi,
In SQL Server 2005, is there anything built-in which will compare two
databases and show how their schemas differ? Something similar to the Red
Gate software?
Any assistance gratefully received.
MarkNot yet but soon there will be a tool like that with the Visual Studio Team
Edition for Databases:
http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/
Andrew J. Kelly SQL MVP
"Mark Rae" <mark@.markNOSPAMrae.com> wrote in message
news:%23Cly$A5vGHA.4576@.TK2MSFTNGP03.phx.gbl...
> Hi,
> In SQL Server 2005, is there anything built-in which will compare two
> databases and show how their schemas differ? Something similar to the Red
> Gate software?
> Any assistance gratefully received.
> Mark
>

Comparing the schemas of two databases

Hi,
In SQL Server 2005, is there anything built-in which will compare two
databases and show how their schemas differ? Something similar to the Red
Gate software?
Any assistance gratefully received.
MarkNot yet but soon there will be a tool like that with the Visual Studio Team
Edition for Databases:
http://msdn.microsoft.com/vstudio/t...products/dbpro/
Andrew J. Kelly SQL MVP
"Mark Rae" <mark@.markNOSPAMrae.com> wrote in message
news:%23Cly$A5vGHA.4576@.TK2MSFTNGP03.phx.gbl...
> Hi,
> In SQL Server 2005, is there anything built-in which will compare two
> databases and show how their schemas differ? Something similar to the Red
> Gate software?
> Any assistance gratefully received.
> Mark
>

Comparing data structure

Hi,
The task: we have to two databases. Both evolved from one root in ancient
times. Right now they differ quite a lot. We want to take them both back to
one. To prepare it we have to make some kind of report (no matter what kind
–
standalone program, excel sheet, Visio diagram) to aid “uniformization”.
One
DB is Oracle, other SQL Server. Both have hundreds of tables with tenths of
fields. Any ideas?
PS. Is it the right Group for this question? ;)
Regards,
MaKcheck out this link..
http://www.dbbalance.com/download.htm
I haven't tested this tool by myself. Is this what u wanted?
hope this helps
--
"MaK" wrote:

> Hi,
> The task: we have to two databases. Both evolved from one root in ancient
> times. Right now they differ quite a lot. We want to take them both back t
o
> one. To prepare it we have to make some kind of report (no matter what kin
d –
> standalone program, excel sheet, Visio diagram) to aid “uniformization
. One
> DB is Oracle, other SQL Server. Both have hundreds of tables with tenths o
f
> fields. Any ideas?
> PS. Is it the right Group for this question? ;)
> Regards,
> MaK