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 |
|
kenchee
Starting Member
49 Posts |
 Posted - 2007-08-21 : 22:58:34
|
| Hi, is it possible to have a snapshot replication and transactional replication done on one database. The reason i'm asking is that if i were to just use transactional replication, some of the tables does not have primary key on them, so they cannot be replicated, hence using the snapshot to grab all of the tables that cannot be replicated by the transactional replication. is that possible or have i got the whole concept wrong. Sorry, but i'm new to replication. or is there a better way of doing thing?ThanksKen |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-21 : 23:08:20
|
| It's possible. Or you can set transaction replication for tables with pkey and snapshot replication for tables without pkey. |
 |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2007-08-22 : 18:50:01
|
| thanks.. will give that a go. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-22 : 18:58:37
|
| Why don't you have primary keys on these tables? If you don't have a natural key on the table, why not add a surrogate key such as an identity column?There are very few reasons where tables should not have primary keys. The primary reason would be staging tables that are used for importing data.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
2 different replication method on one db