up vote 0 down vote favorite
share [g+] share [fb]

All,

Situation

  • We are in retail industry with about 10 distributors and use Solomon as the standard ERP for all our systems

  • Each distributor has 1 HQ and 5 - 10 branches, each branch has their own server (Windows 2000/XP/2003 + Solomon + another built-in POS system)

  • Everyday, branches has to extract data and send (via email/Skype) to HQ for data consolidation purpose

  • When we first deployed our ERP, the infrastructure (e.g. Internet connection) wasn't reliable enough. That's why we went with the de-centralized model (each branch got their own server)

  • Now, the infrastructure is mature already. And we need to consolidate data more quickly (not from branches --> HQ --> our company but something like HQ --> our company only)

Goal

  • We just have Solomon servers in distributor HQ. All the transactions in branches (retrieved from POS) will by synchronized with HQ server directly)

  • There is a backup plan just in case the Internet goes down, or HQ server goes down

Question

  • With the above question, could you guys suggests some model for me ? Should we use Terminal services, any other solutions ?

  • Any watchout/suggestions ? Any good article to read 'bout this ?

Thanks a lot

link|improve this question
What you're describing is a simple file transfer, which should be built into the application itself. There are many ways to do this but it's really a programming issue rather than system administration. Discuss it with your programmers. – John Gardeniers Apr 27 '10 at 10:21
Hi, It's not just simple file transfer. We'd want to setup something like a VPN so that all the clients in the branches can "talk" to the server in HQ. I know we can achieve it using Terminal services, however I don't now if there are any other best practices (since I'm more of a PM than network engineer). That's why I think it somehow belongs to ServerFault (infrastructure questions ?) Thanks – Sim Apr 27 '10 at 10:45
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.