Synchronizing Sql 2000 database. Need help.
-
Hey everyone, I am working on this project, mostly database driven. this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work. What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database. Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000... your help would be highly appreciated... thanks.
Nab
-
Hey everyone, I am working on this project, mostly database driven. this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work. What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database. Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000... your help would be highly appreciated... thanks.
Nab
Hi, U can use the Replication feature built in SQL Server 2000. Here a goog article about it : http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/[^] HTH