| Author |
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.
| |
| cpotts 2005-07-21, 8:23 pm |
| 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.
| |
| Kevin3NF 2005-07-21, 8:23 pm |
| 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@microso
ft.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@microso
ft.com...
>
>
>
| |
| databasecompare 2005-07-21, 8:23 pm |
| 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.
[color=darkred]
> "Paul" <Paul@discussions.microsoft.com> wrote in message
> news:C18BEDD3-C670-4984-86B5- DA0D092F3365@microso
ft.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
| |
|
| ok thanks will give it a try!
--
Paul G
Software engineer.
"databasecompare" wrote:
[color=darkred]
> 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.
>
| |
| Kevin3NF 2005-07-22, 9:23 am |
| 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@microso
ft.com...[color=darkred]
> thanks for the information. Guess this feature is not built into
> Enterprise
> manager or Query Analyser.
> --
> Paul G
> Software engineer.
>
>
> "Kevin3NF" wrote:
>
|
|
|
|