Replicating partial database
Hi there, actually I have a set of tables from my database model on SQL SERVER 2005 that I want to replicate (using merge replication) to a different server with SQL SERVER 2005 EXPRESS, Everything seems to be ok until I try so replicate just a portion of my model. I’ve got some parent tables to replicate but I’m not going to replicate some of their children, when I try to move them (just the parents and SOME children) to the other server using subscription, I have to erase some foreign keys (the children’s foreign keys I wasn’t supposed to migrate) in the target server to get my database migrated.
What Can I do to solve this problem?
Well you might have to remove the FK constraint. If thats not possible let the parent tables replicate.
No comments:
Post a Comment