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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-24 : 07:43:52
|
| Rishi writes "Dear Sir/madam, I have the following scenario where i am currently working...I have 2 SQL2000 servers who are in the same work group and in the same subnet with 100mbps ethernet connection.I have configured one as a publisher and one as a subscriber and i want to enable Transactional replication between the two servers.I am facing the problem like when i replicate the database the tables contaning primary keys and identity fields(auto incrementing) are not getting replicared to the subcriber server.I use a custom made application to access the database. Suppose i point the application to the subscriber database and try to insert or update some records it gives me error saying null values found in the table.Please advice as to how should I setup the replication so as the database will be replicated with all the settings and data.regards,Rishi" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-03-25 : 08:32:43
|
| When you say the 'tables contaning primary keys and identity fields(auto incrementing) are not getting replicared' do you mean the primary key and identity parts of the table are not being replicated and not the entire table ? If so, this is normal for uni-directional transactional replication. Primary keys and identity columns are not meant to be replicated. Identity fields become integer fields i believe and the primary key is removed although the fields obviously stay there.With this setup you are not meant to attach a front-end to the data and do inserts or updates - you can however view the data with a front-end at the subscriber.I may have misread what you mean but if so i can't work out what it is you are getting at...sryPerhaps you need to use merge replication !?===========Paul |
 |
|
|
|
|
|
replicating identity fields in sql2000