How to syschronize sql server 2000: need help, please....
-
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
My recommendation is to have a backup server that mirrors the other server on a regular basis. I think you are going to have a real headache with trying to synchronize at the end of the day. I don't know of anyone who does it that way.
_________________________________________ You can't fix stupid, but you can medicate crazy.
-
My recommendation is to have a backup server that mirrors the other server on a regular basis. I think you are going to have a real headache with trying to synchronize at the end of the day. I don't know of anyone who does it that way.
_________________________________________ You can't fix stupid, but you can medicate crazy.
thanks, would you suggest that i write a utility program to do so? one that copies all table to the backup database...and at the same time be able to access the information from server level or standalone at anytime..
Nab
-
thanks, would you suggest that i write a utility program to do so? one that copies all table to the backup database...and at the same time be able to access the information from server level or standalone at anytime..
Nab
No. You let SQL Server handle the replication between two servers.
Dave Kreskowiak Microsoft MVP - Visual Basic