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 |
|
scottikon
Starting Member
9 Posts |
 Posted - 2005-07-24 : 10:33:06
|
| I am a final year student working part time for a software company developing a CRM application for my project and they have asked me to research a problem they are having.To maintain a synchronous database over two sites. Any changes made to the database from either site has to be replicated to each server.The main problem is ensuring synchronisation of ID's over the two databases. Whe new records are created on either side, they are assigned ID’s that are sequential and not random therefore as a result there are problems in synchronising the data due to the duplication of ID’sCan anyone shed any light into this situation? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-24 : 21:43:21
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52779--------------------keeping it simple... |
 |
|
|
|
|
|
database replication/synchronisation problem