Question Locked

Network Sync. Help

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, i'm new to networking, and i need some help setting up about five computers together (On three totaly different networks eg. one's in CA and another is in SD) The network needs two admin computers, and all the file need to be sync.

4 replies

by toivo talikka

Are all the computers Windows XP Professional? One in each of the three 'networks' and then two 'admin' computers - where, doing what?

What exactly are these 'different networks' - one individual standalone computer in each location, connected to the internet, or something else?

What sort of data volumes are you talking about, in megabytes (MB)? How often does the data change? Is the data Word and Excel documents, graphics or something else? Perhaps a database?

By sync, do you mean synchronizing the contents of directories instantaneously when something changes in one location, or on an hourly basis, or perhaps overnight?

I hope you realise that a networking solution can only be put together once enough is known about the business requirements, i.e., what the users of the computers are expected to do, what the business objectives are and what the management thinks is important, like speed of access, availability, reliability, security of the systems and confidentiality of the data.

'Horses for courses', but we need to know a bit more about the course first.

by aadee92

Thanks for the quick reply, Toivo.

What's been done:

There are two computers in CA, at the work shop, they are locally connected through a router. One computer (office admin) has access to the other computer (employee)... as best I could set it up. (I need a better setup, if the employee went to "My documents" properties, he could easily deny the admin access. Even though he has a "Limited" account) both computers are Windows XP Media Edition, with 64x Processors. Plenty of Memory, (around 200 GB) and about 1 GB ram.

There is also a computer at the house, the administrator?s main computer. This computer is on a totally different ISP, is Windows XP Home-edition, 150 GB memory, and 512 MB ram. I don?t have this one connected to the others at the shop yet.

What I need to do:

Setup a computer in SD? (on a third ISP) Probably running XP Media or Vista. Ill call this computer employee 2

Connect them all together with the following requirements:

? Admin (home) has access to all computers in the network
? Admin (office) has access to all computers in the network
? Employee 1 (CA) has access to a certain shared folder
? Employee 2 (SD) has access to the same certain shared folder
? Employee 1 & 2 have Read and Write privileges to this folder, but nothing else on the network
? We will be mainly working with excel files, I want each computer to HAVE THE SAME FILE, on EACH computer that way if one computer is shut down they can still update & access the file, and when they load the file I need it to check for changes made by the other computer users.

Oh, the security doesn't have to be THAT great, but i don't want the casual hacker to be able to acess the files. No credit card numbers or banking numbers will be stored between the computers.

Thanks,

by toivo talikka

Excel is not that wonderful in your situation. You will need to write a macro which compares the different versions of the spreadsheet once they have been copied to one computer. Unless you want to do it manually, the synchronisation and replication of the changes is a programming job. In terms of the cost of the design, implementation and testing you are pretty close in being able to justify a simple database like Access. Daily transactions could be written to a separate table which can then be merged with the master list of transaction with relative ease.

If you are planning to use a database, you might as well implement a centralised database with the option for the users to go off-line and use a local copy if the internet connection goes down.

Your networking requirements can be fulfilled with a DSL modem/router which supports VPN tunnels. Each site needs to have a fixed external (public) IP address allocated to it by their ISP. You can use different ISPs but they will need to offer a package with a fixed IP address.

In this scenario, the CA sites will be networks (subnets) 192.168.1.0 and 192.168.2.0, the SD site will be 192.168.3.0. The PCs will belong to the same workgroup, and the VPN will make it look as if all the the PCs were subnets in the same building.

The rest, folder security and things, is relatively straight forward.

I have used an inexpensive ADSL modem/router solution to create a VPN based Wide Area Network (WAN) between three sites. The device is Netcomm NB5580 which supports five (5) VPN end-points, details from http://www.netcomm.com.au/ADSL/NB5580.php

Another product you may find in your part of the world is Watchguard Firebox SOHO 6tc which supports "meshed VPNs between several branch offices". It can connect to up to 10 sites, according to the information at http://www.watchguard.com/products/fireboxsoho6tc.asp

This discussion is closed to new replies.