MSSQL SERVER

We are having IP MPLS Connectivity between our Head Office and Branch Office.

In our head office we are using EPICOR SCALA SERVER DATABASE IS ON MS SQL SERVER and branch office is connected to Head office SCALA Server by remote login (Terminal Server 2008 ).
Since we are facing connectivity problems, we would like to implement a REMOTE SCALA Server at Branch Office  and get it synchronized with Head Office SCALA Server.!

IS it possible to have 2 different Scala Server /DATABASE SERVER WITH THE SAME DATA AT BOTH THE END at 2 location and get both of them Syncronize ?

For that we would like your EXPERT opinions and help to guide us to implement the REMOTE SCALA SERVER.

Kindly note that our Head Office USES EPICOR Scala BASED ON MSSQL SERVER ( DATABASE)  users consist of Finance , HR , and some LOGISTICS USERS
Also Our Branch Office Scala Users consists of LOGISTICS USERS

We are looking for your valuable expert opinions  and guidance to implement Remote SCALA SERVER to ensure smooth working of SCALA ERP at both location.
SIMPLY WE WANT BOTH THE USERS USES THE SAME ERP SERVER(DATABASE) ONE LOCATED IN THE HEADOFFICE FOR THE HEADOFFICE USERS AND ONE LOCATED AT THE BRANCH OFFICE FOR BRANCH OFFICE USERS AND AT THE SAME TIME THE DATABASE IS SYNCRONIZE  WITH EACH OTHER.
BRANCH OFFICE CONSIST OF 12 USERS AND HEAD OFFICE ALSO CONSISTS OF 12 USERS .

seraj786Asked:
Who is Participating?
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.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
this sounds like you want to implement merge replication (also known under multi-master replication).
means that data can be updated on both systems, and changes are replicated to the other sites.
however, as for any transactional replication system, your database schema must be compliant for replication, you will need to check with the software provider if this is the case.

>Since we are facing connectivity problem
note that if you have connectivtiy problems, your replication might run into the same problems, so your real problem should be solved first.
0

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
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
As angelIII did sum it up: you need to implement merge replication.
0
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
Enterprise Software

From novice to tech pro — start learning today.