Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hueby
Posting Yak Master
127 Posts |
 Posted - 2005-01-10 : 16:18:13
|
| Hi all, here are my goals: Have the same DB on two different stand-alone computers, and keep them up-to-date from each other.Basically a user would input to a DB for a week. Then every week or two, update the other stand alone DB with the new input. The DB would be exactly the same. What are my options for this? I'd like it as easy as possible! Are there any software packages that deal with this type of transfer, etc.? Thank you! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-10 : 17:03:22
|
| Why not have one central database on a server, then each user can just connect to the central databse?Tara |
 |
|
|
hueby
Posting Yak Master
127 Posts |
Posted - 2005-01-10 : 17:11:48
|
| My company does not want that unit to have any internet access. Therefore I am stuck with a stand alone DB down there, that has updates sent physically. >:( |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-10 : 17:13:51
|
| That has updates sent physically? What does that mean? You don't need internet access in order for two users to be able to connect to the same database. Besides, whatever solution there is for this is going to require them to be able to communicate with each other.Tara |
|
|
|
hueby
Posting Yak Master
127 Posts |
Posted - 2005-01-10 : 17:21:57
|
| It means, as in burnt onto a CD once a month. I know, I know.. sounds stupid, but that is how it is going to be working. No internet Access... no Network... NO connections. I'll work up a automated backup/restore to use I guess. Thanks! |
|
|
|
|
|
|
Keeping 2 same DBs in 'synch'