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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2009-09-24 : 23:22:30
|
| hiIs that a way to replicate tables that has no primary key? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-25 : 03:02:43
|
| Snapshot replication is an option. ie copy the entire table every time the replication runs.Transactional replication requires that tables have a primary key and there's no way around that requirement.--Gail ShawSQL Server MVP |
 |
|
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
Posted - 2009-09-25 : 08:30:06
|
| Thanks |
|
|
|
|
|
|
Replicate Tables That Has No Primary Key