Error comparing with a database restored from a backup of a database created with DBCC CLONEDATABASE
AnaSL
Posts: 9 Bronze 1
Hello.
We have restored a database backup in our development environment. The original database backup was created from a database (in production environment) who was created using the “DBCC CLONEDATABASE” command.
When we compare the database we have created in our development environment with the production original database we are receiving the error in the next picture:
¿How we can solve this issue?
Thanks.
Answers
Can you confirm what version of SQL Compare/Data Compare that you're seeing this under? Can you also confirm the version of SQL Server instances involved between the development and production environment?
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
The SQL Compare version I am using is 14.0.7.13517 Standard. Both databases are in the same instance, SQL Server version 12.0.5000.0.
Thanks.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Unfortunately at this time SQL Data Compare doesn't have a way to account for this discrepancy.
Apologies for the inconvenience that this brings.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?