|
fcaglayan
Starting Member
1 Posts |
 Posted - 11/16/2011 : 05:47:21
|
I want to carry the database to another disk formation to speed up I/O. But the problem is before removing the replication publisher's db do not allow me to do it and because of removing the replication and resetting it cause a big problem, first I want to test it on my computer instead of live server.
But the problem is when subscriber have the database and datas on it, I am getting Foreign key errors:
"The schema script could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001)
Could not drop object 'dbo.x' because it is referenced by a FOREIGN KEY constraint."
Because of there will be database and datas on the subscriber I don't want it to drop tables because synchronization may take too much time.
What may I do to avoid this error or what may I do to reject dropping the tables. |
|
Merge Replication Foreign Key Error
