comparison of databases

Hi just wondering if there is a tool that can be used to compare 2 databases
on different servers to see if they are the same or have the same data?
Thanks.
--
Paul G
Software engineer.www.red-gate.com SQL Compare and SQL DataCompare.
www.apexsql.com SQLDiff will do it all in one.
"Paul" wrote:
> Hi just wondering if there is a tool that can be used to compare 2 databases
> on different servers to see if they are the same or have the same data?
> Thanks.
> --
> Paul G
> Software engineer.|||I have used Red-Gate's Data Compare utility 5 times today for this very
purpose...
www.red-gate.com
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:C18BEDD3-C670-4984-86B5-DA0D092F3365@.microsoft.com...
> Hi just wondering if there is a tool that can be used to compare 2
> databases
> on different servers to see if they are the same or have the same data?
> Thanks.
> --
> Paul G
> Software engineer.|||thanks for the information. Guess this feature is not built into Enterprise
manager or Query Analyser.
--
Paul G
Software engineer.
"Kevin3NF" wrote:
> I have used Red-Gate's Data Compare utility 5 times today for this very
> purpose...
> www.red-gate.com
>
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:C18BEDD3-C670-4984-86B5-DA0D092F3365@.microsoft.com...
> > Hi just wondering if there is a tool that can be used to compare 2
> > databases
> > on different servers to see if they are the same or have the same data?
> > Thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||We've developed Database Comparing Tool on .NET platform
www.databasecompare.com It is still beta version but you can download and
try for free. It allows comparing structure (schema) and data between 2
databases: http://www.databasecompare.com/download.html
Will be nice to have any feedback!
Thanks.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:C18BEDD3-C670-4984-86B5-DA0D092F3365@.microsoft.com...
> Hi just wondering if there is a tool that can be used to compare 2
> databases
> on different servers to see if they are the same or have the same data?
> Thanks.
> --
> Paul G
> > Software engineer.
> >
> >
> >|||ok thanks will give it a try!
--
Paul G
Software engineer.
"databasecompare" wrote:
> We've developed Database Comparing Tool on .NET platform
> www.databasecompare.com It is still beta version but you can download and
> try for free. It allows comparing structure (schema) and data between 2
> databases: http://www.databasecompare.com/download.html
> Will be nice to have any feedback!
> Thanks.
> > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > news:C18BEDD3-C670-4984-86B5-DA0D092F3365@.microsoft.com...
> > Hi just wondering if there is a tool that can be used to compare 2
> > databases
> > on different servers to see if they are the same or have the same data?
> > Thanks.
> > --
> > Paul G
> > > Software engineer.
> > >
> > >
> > >|||Not in the current version...no idea if it is a feature of 2005....works
well for a $200 product :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:8A6FF067-90EC-4371-BFF8-7072DE5437FD@.microsoft.com...
> thanks for the information. Guess this feature is not built into
> Enterprise
> manager or Query Analyser.
> --
> Paul G
> Software engineer.
>
> "Kevin3NF" wrote:
>> I have used Red-Gate's Data Compare utility 5 times today for this very
>> purpose...
>> www.red-gate.com
>>
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:C18BEDD3-C670-4984-86B5-DA0D092F3365@.microsoft.com...
>> > Hi just wondering if there is a tool that can be used to compare 2
>> > databases
>> > on different servers to see if they are the same or have the same data?
>> > Thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>