SQL Database Compare and Copy data having Circular reference
Vedavathi
Posts: 2
Hi All,
I try to copy data from one database to other database using Red Gate SQL data compare tool, unfortunately it is throwing few errors as below.
Circular Reference
Table [dbo].[xxxxxx] has foreign keys to other undeployed tables; the database may be left in an inconsistent state
Can you please guide us the limitation of RedGate data compare tool during this kind of scenarios.
Without Primary key in database tool
Table1==> Table2==>Table3 - whehter tool follows the sequence that first Table1 data has to be copied later Table2 and Table3
I try to copy data from one database to other database using Red Gate SQL data compare tool, unfortunately it is throwing few errors as below.
Circular Reference
Table [dbo].[xxxxxx] has foreign keys to other undeployed tables; the database may be left in an inconsistent state
Can you please guide us the limitation of RedGate data compare tool during this kind of scenarios.
Without Primary key in database tool
Table1==> Table2==>Table3 - whehter tool follows the sequence that first Table1 data has to be copied later Table2 and Table3
