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:32:00
|
| 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:20:44
|
| explore merge replication, read 'merge replication, overview' and see if this is what you need.for the ID's, you have to make the IDs unique for each site, since they are assigned, add identifying character(s) like..S1001, S2001 where S1 = site 1, S2=site 2this way you will know which record was from which site, especially when your creating the reports and pulling out dataHTH--------------------keeping it simple... |
 |
|
|
|
|
|
database replication/synchronisation problem