|
Posted by Greg D. Moore \(Strider\) on 10/01/90 11:41
"Peter" <SPAM@Changer.dk> wrote in message
news:4406c2f8$0$78285$157c6196@dreader1.cybercity.dk...
> Hello
>
Look at Merge Replication and at a mechanism that ensures your keys are
unique.
If it's only two locations somtimes it's easiest to have location one start
at 1 and count up and location two start at -1 and count down.
> I have 2 locations, that each has an MSSQL 2000 server.
> Since the locations are to far from each other and the connection is
> very slow.
>
> My thought was to have a database on both servers that should replicate
> on the fly or as asynchronous sync.
>
> The problem is that both locations work in the database frequently. So
> its very important that there are no duplicate IDs.
>
> Is that possibly and how?
>
>
> ~Peter
[Back to original message]
|