can not propagate schema .dri script to subscriber ?

[Romanov]

On one SQL server I have a Publischer. When I'm trying to make a subscriber on another SQL server, it fails when it tryes to build DRI.

It builds the tables and bulk copies the data, but when it comes tol the .dri schema scripts it fails.

Any ideas ??

BR
Romanov

 

[mrdenny]

Could be a key violation error. Look in the dri file (it's just plane text sql file). You may need to remove the relational constraints and readd them later.

Denny

--Anything is possible. All it takes is a little research. (Me)