SQL Database Compare and Copy data having Circular reference

VedavathiVedavathi 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
Sign In or Register to comment.