Connecting multiple offices together

Dear Experts,

I have a project, and I would need your help in order to implement it.

I have five different offices in three different countries, and one web application.

All the offices needs to access this web application that is a form of a workflow for all the departments.

I'm planning to use one server in the main headquarter, and allow a connection to it for all the other offices.

The problem that I will have is that I'm in need to constantly upload and download files with large size. All the users in the offices needs also to have access to all the files that exist on the main server at any given time.

I need also to have the ability to share some folders that exist on the server, and allow users in other offices to have access to them (Same technology as dropbox).

I need a way that would allow the users to keep on working even if the internet is down.

I would highly appreciate any suggestions that you have.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Frank WhiteCommented:
For large-scale programming and application development, SVN, CVS and Git already implement all the features required for this type of distributed workflow, and allows users to keep on working even with no active connection (though if two people work on the same file during that downtime, you'll obviously have more trouble re-merging them afterwards).

For your particular problem, the most viable solution I can think of would be to allocate cloud-like drive space for the entire server or at least often-used files in at least one copy per office, so that if the internet goes down at any time each office has at least once copy of any given file somewhere in their local network. After that, it's a question of figuring out a good system for centralizing these cloud-like local copies for user access - it might require custom network indexes keeping track of all files and a custom user-interface to access those files. My knowledge of cloud networks is limited, but there might already be some software out there that does this (and/or more).

Keep in mind that SVN-like setups need to create "working copies" for each user, which could make the initial network load pretty heavy, but afterwards it only syncs file changes (for most filetypes relevant to coders, that is...).
jmhabis2Author Commented:
Just to elaborate more what I have is a workflow solutions based on a web application that is already developed. It is a form of a centralized system for the users where they can interact with each others. They will have to always upload  new and different types of files: PDF, Indesign, Images... that would be used and downloaded by users in all the offices.
Frank WhiteCommented:

In that case, it seems to me like the only viable solution is to have cloud-like distribution for each localnet as above, and make the webapp able to be used locally as client even when internet access is down, switching to an alternate indexing mechanism retrieving files from the distributed local network "filesystem" instead, and when a user attempts to upload register in the localnet index and list the file for later syncing with the master server.

If you can't modify the webapp at all whatsoever, then there really is no solution I can think of other than pure cloud storage or having duplicate synchronized servers in each physical location. Any alternative I can see would mean constant updating and re-synchronizing of all files across all clients continuously, which is obviously bad news for your network.
SD-WAN: Making It Work for You

As bandwidth requirements and Internet costs grow, businesses naturally want to manage budgets by reducing reliance on their most expensive connection types. Learn more about how to make SD-WAN work for your business in our on-demand webinar!

Your workflow manager software should perform most of your functions. It should have a file sharing and compression utility built in to compress the files and send them easily between offices.

If your workflow management software doesn't offer this, may I suggest another alternative. Akamai uses this software to improve workflow management on their cloud computing:

With that said, if this is pretty much a windows server environment, you can use the built in 2008 server and Win 7 BRANCH CACHING... This form of caching is used for file and print sharing between sites and you can also configure it to be used in the event of a downtime between sites.
Also look at Signiant technology.
jmhabis2Author Commented:
@ChiefIT Our application is an in house solution, so changing to another workflow solution is out of the question.

I was thinking about the suggestion of doing a cloud-like drive space that would be similar to what dropbox actually does.

It is a windows environment using a windows 2008 server, I never tried the banch cashing. I will check the document, and check if it would do me any good.

I did a little research, and found out that we can VPN connections, or Remote desktop. What do you think ?
With a service like DropBox the information exists in three places, a dropbox folder in  your server, in the cloud and a dropbox folder at the remote location.  The information is mirrored so that when your server is down the information is available in the cloud and at the remote location.

Think about this; a change made to a document on the local server is mirrored to the cloud and the remote server. A change done at the remote server is mirrored to the cloud and to the local server.

VPN and RDP require a live internet connection and the data is residing in only one place.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Save yourself the grief of using excessive traffic to remote into a site. Host your files/data locally using branch cache at each site.

These are the features you should look at:
Caching data to all sites=== Branch Cache
Data Compression for smaller file transfers===Build that into your software app
A quick folder for file transfers==Build that into your workflow using the AD browser as a point of contact for forest computers.

These types of features are build into third party applications that are used for workflow management. Then, Akamai takes that one step further by hosting their own cloud environment for networking that they have control of.

Your web developers can develop an intranet web page that uses a SQL database and queries the AD database to communicate and drop data between computers and users. Don't ask me how they do it. I would rather shoot myself in the foot that program a simple batch file.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.