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
> it�s very important that there are no duplicate IDs.
>
> Is that possibly and how?
>
>
> ~Peter

• Next in forum: Re: How can I remove duplicate entries in a sql query?
• Prev in forum: Re: what are cursors in sql???
• Thread view: Re: Replicate between to MSSQL 2000 Servers

[Reply to this message]