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 |
|
shanly
Starting Member
17 Posts |
 Posted - 2005-11-23 : 00:28:05
|
| Hi,I need to replicate one database(tables with primary key and without primary key) from one server A to another server B. Which replication i can use for it?If I use Transactional replication, the table needed primary key. but i want to replicate a table without primary key. I tried creating index for that table, but asking for primary key.When I tried to use merge replication, a column Rowguidcol(uniqueidentifier) is created. is it possible to configure merge replication without Rowguidcol column.please help me in this.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-23 : 14:44:45
|
| If you don't have a primary key, then you'll need to add one. Just add an identity column as the primary key. Then you can use replication.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Replication