473,695 Members | 2,109 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Replicate between to MSSQL 2000 Servers

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
Mar 2 '06 #1
4 1565
Peter,

What datatype are you using for your IDs and how are you generating
your IDs?

Dave

Mar 2 '06 #2
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

Mar 2 '06 #3
The problem is that there is no way (until you work out how keys are
generated) of ensuring that duplicate keys are not created. If they're
created as a uniqueidentifie r you could potentially use merge
replication but you need to understand the schema of your database to
do this and work out which tables you need to replicate.

I think the key to solving this problem is working out how your keys
are generated.

Mar 2 '06 #4

"Peter" <SP**@Changer.d k> wrote in message
news:44******** *************** @dreader1.cyber city.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

Mar 3 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3649
by: Samuel | last post by:
I am building an web application that will be hosted on load balanced servers (multiple front and one backen db). The application will have to allow users to upload files onto the server. For performance reasons, I do not want to store binary files in the db (cuz there will be frequently retrieved and stored and many will be within the range of 10 MB - powerpoint slides and pdf files) so uploaded files will have to stay on the front end web...
2
1374
by: Chris Auer | last post by:
Hopeing this is something I can accomplish. I use MS-SQL for close to 100 CMS web servers. Everytime I create a new website I have to create a new database and then use the export from SQL to SQL option and copy all data / SP's / etc... Just no security information. My question is can I automate this? Can I create a script that will run all this? Thanks for any help, and thanks for reading. Chris Auer chris.auer@methodfactoy.com
1
1902
by: Uli | last post by:
Dear group, I have to replicate remote data to a SQL Server in the headquarter. The data are on a site which does not have permanent online-connection to the headquarter. I have written a script which replicates the data and i want to set up a process / batch on the headquarter-machine which roughly does the following
1
1627
by: interuser | last post by:
I have a football school mdb used at the following locations: 1. office 2. home of owner 3. training fields Once a day (eg morning) all mdbs must be replicated. Since none of the pcs is online all the time, I thought to store the data on the company's webserver (hosted by a 3rd party and has asp.net and MSSQL) , and all pcs should sync with the database on the webserver.
3
4315
by: gharmel | last post by:
I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server #1 MSSQL 2000 sp4 Windows 2000 Server PHP4 on IIS5 (CGI)
4
6006
by: kenneth.osenbroch | last post by:
Hi, I have a MSSQL Server communicating with an Oracle database through a MSSQL linked server using a MS ODBC connection. If I query the Oracle database through the Oracle ODBC 32Bit Test, the result is fine: select addrsurname from address where addrnr = 6666; HÅKANSSON
16
1758
by: davemateer | last post by:
Hi We have a current system: Linux / Apache / PHP4.x talking to Microsoft SQL 2000 Thinking about going to: Windows 2003 / PHP4.x talking to the same Microsoft SQL 2000 box...
2
1413
by: grandmasterneil | last post by:
I have a couple of servers here at work that run IIS, MSSQL, and ASP.NET. I have PHP installed and running via Apache on my laptop. I was wondering if I can run code on my laptop (PHP/Apache) to access the information in the MSSQL databases here at work or do I have to install PHP onto the servers? Thanks in advance.
0
1444
by: Derftics | last post by:
Hi Guys, Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer? I have tried using MSDE and successfully install the MSSQL 2000 server but when I tried installing MSSQL 2005, it allows only the client tools. I have revert the process and successfully install MSSQL 2005 server but now the MSDE was prompting me an error. Is possible to install both versions of MSSQL servers in one desktop...
0
8625
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8565
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9113
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8977
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8822
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6488
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5838
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4339
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4577
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.