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 |
|
gundan01
Starting Member
3 Posts |
 Posted - 2008-02-20 : 11:27:08
|
| I doing a transactional replication with two servers. Server A, the Publisher and Distributor. Server B, the Subcriber. I did the replication using a dummy DB for practice purpose and it works fine. When I try to implement the replication in original DB, I found that some tables don't have primary keys and to be able to implement transactinal replication all the replicated tables need to have a primary key. I want to add the primary keys to those tables and also implement the replication but the problem is those tables have data in it. I'm thinking in create the new table and do a DTS to import the data to the new table or it's fine just to modify the table in design to add the primary key "Those table have record in it". Some of you have any advice to me? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-20 : 13:08:45
|
| But you need to have unique records to add primary key for column. |
 |
|
|
gundan01
Starting Member
3 Posts |
Posted - 2008-02-21 : 08:20:51
|
| If I have unique records is not going to be a problem if I add the primary keys? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 14:44:15
|
| You can put pkey on column that has unique values, or add an identity column to that table and put pkey on it. |
|
|
|
gundan01
Starting Member
3 Posts |
Posted - 2008-02-23 : 12:52:22
|
| Ok thanks |
|
|
|
|
|
|
SQL 2000 transactional replication