05-16-2011 03:51 PM
I recently obtained a new notebook, which I will use as my field system.
I'm trying to figure out how to connect the two computers so that the remote db will sync with the base db. I had no problem getting the sync set to the remote system, but I can't figure out how to sync back to the base system.
This might help - the base system is on my company's domain and the field system is a personal unit not provided by the company. I tried setting up a home network, but the company has restricted that option on the firewall.
Is there any way to sync the two systems using "sneaker net" or something like that?
05-18-2011 05:44 AM
How did you get the remote (RDB) over to the notebook? Are you able to connect the notebook to the company network while in the office? If you can connect while in the office, you should be able to get it to sync.
If you cannot connect to the office network directly, is setting up a Hamachi VPN an option?
Backend option would be: backup remote, restore on work computer, use import/export to update. Then create a backup of the updated database and restore it on the notebook. And repeat these steps each time you want to update them. If using this option you wouldn't need to create it as a remote, just use a backup (since they will never actually sync). You would also want to delete the older versions of the database as newer ones are created.
05-18-2011 02:46 PM
I created the RDB on an external HDD and then copied to a flash drive. I then moved the flash drive to the remote computer and double clicked on the RDF file.
I will give Hamachi a try as well.
Many thanks as always.