running lan based project in two cities

Hi everybody
i need help one of our client uses MIS solution developed by us running on
their LAN, they want same package to run at other factory too located in
other city 200 miles away.They wish to access the same package at both
cities without making this package available to others on net.
Please help me out how to achieve this. One solution i have in mind is
having Virtual Private network whether it will work. I need detailed help
Thanks in Advance
Please help this is urgent

VPN will work alright. but still the redundancy factor will be a major
problem.

You could work with Both Scenarios:
1. Either installed MIS servers on both end and use it as an distributed
environment with database synchronising at a fixed interval. (I rate this
option above all other. you have enough leverage with this then any thing,
unless the server crashes) :)

2. or you could go for redundant VPN links for that you would be needing at
least a router and a professional who can handle Redundancy protocols.

I don't know much about the VPN solution but I would be aware
that often applications will not run over the limited bandwidth
of a wide area network. The Lan based users probably have 100Mb
or more bandwitdth available while WAN users often have 1 Mb or
less. If I were in your shoes I would ask my network engineers
about the WAN and LAN capabilities and then test the application
to ensure that large files, reports... were not being sent over
the network since the impact on performance would be
significant, perhaps to the point of making the application
unusable.
You may also want to consider using Citrix since it generally
requires less bandwith.

Thanks a lot for replies.
well i will elaborate upon scenario they will be accessing MIS Package at
Branch Location from Head Quarter. One solution is to host the Package on
Internet along with their web site but they are worried about data as any
employee leaving organisation can easily leak data to competitors prior to
leaving organisation. So they wanted something like VPN etc. which could not
be accessed at any other location aprt from their Office systems.
So which one will be cheap and best option.
Thanks in advance.
Regards
Surendra

If you are going to be sending highly delicate information over the open web i would have to agree with using something hamachi. The other solution to your problem is to purchase a Cisco VPN box at one site and setup a client server relationship. this will be as secure as you would possible every get it. You would simply just make it a perminant connection filting only the traffic that you wish through it.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.