You are here: Re: Replicate between to MSSQL 2000 Servers « MsSQL Server « IT news, forums, messages
Re: Replicate between to MSSQL 2000 Servers

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация