Compare of tables in different schemas fails - v12.1.0.3760
DejaSQL
Posts: 2
I have two tables in the same database that share the same name and structure, differing in the schema. I am able to successfully unmap the two tables and remap the one from the first schema to the other in the second schema, applying a filter along the way. The data comparison appears to run with no issue but when the comparison is complete the results indicate that a comparison was performed on the table on the left to itself -- not to the "second schema" table. The table that had been on the right now appears as unmapped at the bottom of the table list.
I can 'trick' it by creating a view on the second table, using the schema of the first table. Going thru the mapping/matching/filtering exercise then works. Is this the expected behavior? All the examples posted online show tables in the same schema but I haven't seen anything that explicitly says you can't compare across schemas.
In summary
-comparing dbo.Table1 to sys.Table1: set up allowed, results revert to comparing dbo.Table1 to dbo.Table1
-comparing dbo.Table1 to dbo.Table1_view (built on sys.Table1): set up allowed, results as expected
-running v12.1.0.3760[/list]
I can 'trick' it by creating a view on the second table, using the schema of the first table. Going thru the mapping/matching/filtering exercise then works. Is this the expected behavior? All the examples posted online show tables in the same schema but I haven't seen anything that explicitly says you can't compare across schemas.
In summary
-comparing dbo.Table1 to sys.Table1: set up allowed, results revert to comparing dbo.Table1 to dbo.Table1
-comparing dbo.Table1 to dbo.Table1_view (built on sys.Table1): set up allowed, results as expected
-running v12.1.0.3760[/list]
Tagged:
Comments
Best,
Technical Sales Engineer
Redgate Software
I'm trying to compare that same table across two different schemas: TableA.Schema1 on server X versus TableA.Schema2 on server Y.
I'm able to map the two schemas together in Owner Mapping, and then the tables automatically find each other in Table Mapping (I also tried unmapping them and mapping them back together manually, with the same result).
When I run the comparison, it stops with this error: "Validation Failure. Object '[Schema1].[TableA]' does not exist. Conditional Fast Rowcount method requested without specifying an expected count. Fast method will be used."
So this issue is reduced to: Checksum comparisons do not respect Owner Mapping.
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?