Activity overview
Latest activity by ppd
Ok. Thanks for the quick response and for answering my questions. / comments
Ok. Thanks for the quick response and for answering my questions.
Hi Brian,
I had tried doing that originally, but here is the issue that I had: All of the tables in the first database belong to dbo. In the second database, there are a few tables that belong to dbo, but the other tables are broken into multiple schemas (HR, ACCT, PAYROLL, INV, etc). Since the mapping tool already mapped dbo to dbo, there did not appear to be a way to map dbo to multiples schemas from the second database. I tried unmapping dbo, and then tried to map it to more and one shema (holding down the <CTRL> key, but that didn't work). Any suggestions? Thanks. / comments
Hi Brian,
I had tried doing that originally, but here is the issue that I had: All of the tables in the first database belong to dbo. In the second database, there are a few tables that belong to d...
How to compare tables in different schemas
Using SQL Compare 6, is it possible to compare tables from one database that are in dbo, to tables in another database that are broken out into various schemas. For example, our original database h...