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 |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-07-22 : 09:20:15
|
| Hi,I need a tutorial with examples on Transactional Replication. Can you suggest something on this. How to carry out transactional replication, what are the constraints etc. I have a database in which not all the tables have primary or unique keys. When I opt for transactional replication, the tables which do not have a primary key are not selected. How do I carry out a transactional replication under such a scenario. I want to replicate all the tables irrespective of whether it has a key or not using transactional replication. Would be grateful if you could help on this.ThanksP.C. Vaidyanathan |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-22 : 09:24:48
|
quote:
When I opt for transactional replication, the tables which do not have a primary key are not selected. How do I carry out a transactional replication under such a scenario. I want to replicate all the tables irrespective of whether it has a key or not using transactional replication.
Can't do it. From Books Online:quote:
Primary KeysAll published tables in transactional replication must contain a declared primary key. Existing tables can be prepared for publishing by adding a declared primary key using the Transact-SQL statement ALTER TABLE.
There is a great deal of documentation in Books Online regarding replication; this specific entry was under "Planning for Transactional Replication". Take a look there for more information. |
 |
|
|
|
|
|
Transactional Replication