Question:
Best way to share a database between two locations with vpn?
jase
2007-04-05 17:09:06 UTC
Here is the set-up at location A we have a Windows 2000 server (with AD, full domain and static ip) that is set up as a vpn server. On this server is a fox pro (don't giggle too much) database that is shared to a vpn client in location B. As the dbase has gorwn it is now very slow for location B to do anything with the dbase. If I would put a Windows 2000 server at location B and I guess mirror the shared dbase from server in location A with the server inlocation B over the vpn, meaning that location A would be working with a local copy of the dbase and location B would be working with a local copy of the dbase speed sould increase. First off it this set up doable or what is a better option. Don't know too much about vpn and boss doesn't want to pay for faster ineternet. Please help.

Thanks,

Jase
Three answers:
antirion
2007-04-05 17:30:57 UTC
No. This is not doable if you're accessing the database at both locations. A mirror or DFS will fail miserably. If you're entering data at both locations, you'll have two different versions of the same database. Reconciling the mirror/DFS will either totally corrupt the database (most likely) or overwrite one copy with the other. Either you will lose all your data, or all the data entered at one of the locations. This will happen every single day. Very, VERY bad idea.

I can only think of three options. First, split up your database (I'm not familiar with fox pro, sorry). If you can create a sub-database for location B that links to the main database at location A, you'll dramatically reduce your network traffic. I don't know if this is possible with your setup.

Second, you can tell your boss he either has to cough up the money for more bandwidth or pay a whole lot more in lost productivity because your workers can't work efficiently with what he's got. (Count up the man-hours lost each month because of the slowdown vs the cost of bandwidth. Couch it in terms of saving him money, not costing him any).

Third, use telnet instead of vpn. With telnet sessions from the remote location all the data resides at location A. Very, very little data passes between the points. The trade-off is the cost of telnet licenses from Microsoft, but that would be less than a new server and OS at location B.
Tyler W
2007-04-05 17:40:24 UTC
You will most likely need to use a terminal server-based solution to get what you're looking for here. FoxPro, or any flat file database for that matter, simply doesn't play well w/ relatively slow VPN connections (1MB vs. 100MB on LAN)



Depending on your architecture, you may only need to buy terminal server cals (still sold for Server 2K at VioSoftware.com and others). Main gotcha is you will need a server that is Win2K but NOT a domain controller as only admin access is allowed from a domain controller terminal session.



If you already have a member server, enable terminal services in the Windows Components area of Add/Remove Programs, load the FoxPro front-end as you would on any client, then connect via your remote desktop connection. You can either establish the vpn connection first then connect to the private IP of the terminal server or alternatively forward port 3389 from your internet router to private IP of terminal server then have your users connect via your public IP (second method is usually a little faster but does lose a layer of security w/o VPN)
?
2016-11-27 02:33:12 UTC
if the computing device's are linked to a router then you truly can get the computing device's to get right of entry to a minimum of one yet another even nevertheless it must be sluggish. superb way is to place it in a critical place that the two can get right of entry to like a server or externalpersistent


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...