# Replication

**URL:** <https://www.dynamicsuser.net/t/replication/2570>\
**Category:** User Forum\
**Created:** [June 22, 2001, 8:50pm UTC](https://www.dynamicsuser.net/t/replication/2570 "2001-06-22T20:50:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\
**Post date:** [June 22, 2001, 8:50pm UTC](https://www.dynamicsuser.net/t/replication/2570/1 "2001-06-22T20:50:51Z")

</div>

Potential client has an operation in Europe that needs to be connected to the Canadian Head Office. Is the daily database replication possible since they are trying to avoid continuous connection due to the Internet/phone cost in Europe. Any other suggestions?

---

<div class="post-metadata">

**Author:** ![AlexZ](https://avatars.discourse-cdn.com/v4/letter/a/5daacb/32.png) [@AlexZ](https://www.dynamicsuser.net/u/AlexZ)\
**Post date:** [June 23, 2001, 1:02am UTC](https://www.dynamicsuser.net/t/replication/2570/2 "2001-06-23T01:02:19Z")

</div>

Landsteinar developed a set of replication functions (C/FRONT based) for their Retail Back Office. Their website is [gopro.net](http://gopro.net) Alex

---

<div class="post-metadata">

**Author:** ![vshal](https://avatars.discourse-cdn.com/v4/letter/v/7c8e57/32.png) [@vshal](https://www.dynamicsuser.net/u/vshal)\
**Post date:** [June 23, 2001, 3:19pm UTC](https://www.dynamicsuser.net/t/replication/2570/3 "2001-06-23T15:19:49Z")

</div>

Dear Zoran Bogdanovich, Could you elaborate a little on the problem that you are having. 1. what database are you using SQL/Navision 2. you want to replicate the whole database or just the daily transactions. Thanx Vishal

---

<div class="post-metadata">

**Author:** ![lars\_westman](https://avatars.discourse-cdn.com/v4/letter/l/e47774/32.png) [@lars\_westman](https://www.dynamicsuser.net/u/lars_westman)\
**Post date:** [June 23, 2001, 10:57pm UTC](https://www.dynamicsuser.net/t/replication/2570/4 "2001-06-23T22:57:31Z")

</div>

You can also take a look att [http://www.databackbone.dk](http://www.databackbone.dk) //Lars

---

<div class="post-metadata">

**Author:** ![horrigan](https://avatars.discourse-cdn.com/v4/letter/h/a87d85/32.png) [@horrigan](https://www.dynamicsuser.net/u/horrigan)\
**Post date:** [June 24, 2001, 3:21am UTC](https://www.dynamicsuser.net/t/replication/2570/5 "2001-06-24T03:21:52Z")

</div>

> quote:
> 
> * * *
> 
> **Originally posted by Zoran** : [Is] daily database replication possible since they are trying to avoid continuous connection due to the Internet/phone cost in Europe. Any other suggestions?
> 
> * * *

My suggestion is to get the European office or offices an always-on high-speed internet connection with some sort of wide area network to connect the two offices. This would have a lot of other advantages beyond making the Navision setup work better. Yeah, I know I just suggested that they do the one thing they are trying to avoid doing. Sorry about that, but this is MY suggestion. You make it sound like they are still using dial-up internet access. Dial-up internet access is SOOOOOO 20th century! 🙂 One problem with any form of replication in this case would be that both offices would be making changes to their respective databases at the same time. So it isn’t enough simply to do a backup and restore routine twice a day. ------- Tim Horrigan [horrigan@aol.com](mailto:horrigan@aol.com)

---

<div class="post-metadata">

**Author:** ![FormerMember](https://avatars.discourse-cdn.com/v4/letter/f/74df32/32.png) [@FormerMember](https://www.dynamicsuser.net/u/FormerMember)\
**Post date:** [June 25, 2001, 10:50am UTC](https://www.dynamicsuser.net/t/replication/2570/6 "2001-06-25T10:50:40Z")

</div>

If there are only one reason - money, I don’t think that they will save it by using replication. Replication mostly are more expensive than on line solutions. Costs covers: On-line: soft/hardware of terminal, connections costs; Replication: replication software, connections costs (N times lower, depending on remote users count), Administrator salary; Then you should use replication: 1.If departments are independent financial units. 2.If departments are doing more than 40 % of work. 3.If departments needs high perfomance. 4.If information refresh isn’t very important. This is not the end. You should do desired data flow analysis. Sometimes is very hard to achieve desired goal, if data flow have a lot of data collisions. If you think that replication is Setup.exe file and all that you should do it run it, YOU ARE WRONG !!! Replication covers a lot of challenges.
