<div>
Let me expand on the problem.<br />
Server A is our OLTP system, i use snapshot replication to a developement environment once a week on a sunday night to Server B.<br />
I then want to use transactional replication from Server B to Server C for other purposes.Problem is when the snapshot replication happens to Server B the primary key constraints are not transferred, i cannot implement transactional replication without primary keys from Server B to Server C?<br />
<br />
If i make the index a primary key as soon as the next snapshot happens it becomes a normal index again even though i am not dropping the table at the subscriber only deleting all data?<br />
<br />
Any advice?<br />

</div>


Let me expand on the problem.
Server A is our OLTP system, i use snapshot replication to a developement environment once a week on a sunday night to Server B.
I then want to use transactional replication from Server B to Server C for other purposes.Problem is when the snapshot replication happens to Server B the primary key constraints are not transferred, i cannot implement transactional replication without primary keys from Server B to Server C?

If i make the index a primary key as soon as the next snapshot happens it becomes a normal index again even though i am not dropping the table at the subscriber only deleting all data?

Any advice?


<div>
No way , i saw that option but i thought it only referred to foreign keys, i should have just tried it anyway.<br />
Thanx
</div>


No way , i saw that option but i thought it only referred to foreign keys, i should have just tried it anyway.
Thanx

<div>
<div class="content wysiwyg-content">
Hi There<br />
<br />
I have a table being replicated using snapshot replication.<br />
The table has a primary key, on the subscriber the index of the primary key is replcated but only has an index it is no loner a primary key on the subscriber.<br />
Is there anyway i can transfer the primary key constraint with snapshot replication?<br />
<br />
Thanx
</div>
</div>


Hi There

I have a table being replicated using snapshot replication.
The table has a primary key, on the subscriber the index of the primary key is replcated but only has an index it is no loner a primary key on the subscriber.
Is there anyway i can transfer the primary key constraint with snapshot replication?

Thanx

Snapshot Replication\Primary Keys

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.