Posted by Peter on 03/02/06 16:03

Peter wrote:
> Hello
>
> 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

the database drives an HelpDesk/ServiceDesk system.

since it is to slow to use on the same database from the other location
, the plan was to make a dtabase on both locations that replicates.

How it generates the id and where/wich type. I do not no.
There must be over 300 tables on that database.

~Peter

[Back to original message]