Can I control the order of tables in data loading of snapshot creation?

I need the data loading will start with foreign key tables and finish with
primary key table, so the foreign key tables will not contain new records
that their key not exist in the primary key table.



Any help is appreciated!!

Yuval Peleg

Hi Yuval,

Since the loading of the data (bcp-in) can be done in parallel, there is no
way to guarantee any particular order. Off the top of my head, the creation
of foreign keys should happens after bcp-in so they should not cause any
problems even if the data is not loaded in fk order. Perhaps I am missing
something crucial in your replication setup?

-Raymond

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]