# Data exchange between sql servers

**URL:** <https://www.dynamicsuser.net/t/data-exchange-between-sql-servers/59858>\
**Category:** Technical Forum\
**Created:** [February 12, 2016, 12:00pm UTC](https://www.dynamicsuser.net/t/data-exchange-between-sql-servers/59858 "2016-02-12T12:00:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ariuka](https://avatars.discourse-cdn.com/v4/letter/a/9f8e36/32.png) [@Ariuka](https://www.dynamicsuser.net/u/Ariuka)\
**Post date:** [February 12, 2016, 12:00pm UTC](https://www.dynamicsuser.net/t/data-exchange-between-sql-servers/59858/1 "2016-02-12T12:00:26Z")

</div>

Hello all,

I need an advise from our experienced and valuable members, we have a task to exchange data between sql servers.

1. From server /MS SQL 2012 standard/to POS database import basic information like customer, item, sales price etc. /no updates on POS/

2. From 4-5 POS databases /MS SQL 2012 express/ to the server database import sales header and line. /no updates on server side/

We are planning to use merge replication for this task. The question is:

- Could MS SQL Replication is proper solution?

- If not, what else would be?

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [April 1, 2016, 7:59am UTC](https://www.dynamicsuser.net/t/data-exchange-between-sql-servers/59858/2 "2016-04-01T07:59:38Z")

</div>

Hi Niura,  
Are you planning to do replication between your different NAV database (which version) just using the standard SQL replication?  
Surely possible, and surely NOT a solution that I would recommend.  
Normally this is “out-of-the-box” functionality for POS systems like LSRetail.
