Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SGrannan
Starting Member
3 Posts |
 Posted - 2011-03-08 : 13:18:55
|
So it was decided recently that my company needs to use Merge replication to solve inconsistency issues with our master DB and client DBs. So I have the correct setup and everything was working well with replication.However - I found that when I setup the publication/subscriptions the RowGUID column was added (no biggie) BUT all of the PK and FK are no longer designated as such?? Why did it remove the PK and FK designations on my tables? What is happening during the initialization of replication? And how can I get around this? I need these PK and FK because the application front-end requires them. Thank you! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-03-25 : 11:37:28
|
| did you mark them for replication when you ran the setup?--------------------keeping it simple... |
 |
|
|
|
|
|
Replication - Simple Explanation Please