Solved

MSSQL SERVER

Posted on 2009-06-30
4
305 Views
Last Modified: 2013-11-23
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 .

0
Comment
Question by:seraj786
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 24745373
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
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 250 total points
ID: 24745656
As angelIII did sum it up: you need to implement merge replication.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question