|
Home > Archive > MS SQL Server > November 2005 > Merge Replication and Keys
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Merge Replication and Keys
|
|
|
| A couple of questions about Merge Replication (involving two 2000 servers):
1. From what I read Merge Replication requires a uniqueidentifier column
and will create one if you do not already have one. Correct?
2. If #1 is true, then do you have to have primary keys for every table
involved in Merge Replication?
Thx.
| |
|
| 1. Yes
2. Not for merge since it will use rowguid columns, but you really should
have PK on every table in your database.
MC
"CLM" <CLM@discussions.microsoft.com> wrote in message
news:F06DE00E-F49B-49A9-90BA- 7415204A4E99@microso
ft.com...
>A couple of questions about Merge Replication (involving two 2000 servers):
>
> 1. From what I read Merge Replication requires a uniqueidentifier column
> and will create one if you do not already have one. Correct?
> 2. If #1 is true, then do you have to have primary keys for every table
> involved in Merge Replication?
>
> Thx.
|
|
|
|
|