Comparing 2 tables in the same database
Brian Donahue
Posts: 6,590 Bronze 1
Hi Doug,
Thanks for writing. Unfortunately, SQL Data Compare's purpose it to
synchronize two databases. The tables that you want to synchronize have to
be in different databases and have the same name, owner, and structure. If
the tables are formatted correctly, you could always copy the table into
another database, at least temporarily, compare the tables, and drop and
copy it back to the original location.
Regards,
Brian Donahue
Red Gate Technical Support
"Doug Swarts" <REMOVETHISdswarts@askpioneer.comREMOVETHIS> wrote in message
news:b5jZb$fgDHA.1228@server53...
> How do I compare 2 tables that have different names but the same stucture
> and reside in the same database?
>
>
Thanks for writing. Unfortunately, SQL Data Compare's purpose it to
synchronize two databases. The tables that you want to synchronize have to
be in different databases and have the same name, owner, and structure. If
the tables are formatted correctly, you could always copy the table into
another database, at least temporarily, compare the tables, and drop and
copy it back to the original location.
Regards,
Brian Donahue
Red Gate Technical Support
"Doug Swarts" <REMOVETHISdswarts@askpioneer.comREMOVETHIS> wrote in message
news:b5jZb$fgDHA.1228@server53...
> How do I compare 2 tables that have different names but the same stucture
> and reside in the same database?
>
>
This discussion has been closed.
