Replication

aboomar
aboomar Member Posts: 47
edited 2008-08-16 in NAV/Navision Classic Client
If i have server in showroom , server in warehouse and main sever for navision

i need to now if it possible make replication form warehouse to showroom and from showroom to server navision online or not

and the capacity bandwidth

if i can what the steps should i taken

Comments

  • garak
    garak Member Posts: 3,263
    if all 3 servers are SQL Servers, use the SQl Server replication option.
    Its very easy to handle. For Bandwith. Some customer of mine use replication with an 2MBit VPN.

    Regards
    Do you make it right, it works too!
  • aboomar
    aboomar Member Posts: 47
    Thanks garak

    But i need to ask you about this way can make replication from warehouse server to showroom server to NAV server after finished transaction in same time
  • bbrown
    bbrown Member Posts: 3,268
    aboomar wrote:
    Thanks garak

    But i need to ask you about this way can make replication from warehouse server to showroom server to NAV server after finished transaction in same time

    Wouldn't it be much simpler (and less expensive) to have 1 database and host Terminal Server/Citrix access form the other 2 sites?
    There are no bugs - only undocumented features.
  • aboomar
    aboomar Member Posts: 47
    Sorry garak

    one more question

    can i make this replication from navision without using SQL
  • bbrown
    bbrown Member Posts: 3,268
    Are we talking about replication between 3 NAV databases, or 1 NAV database and 2 third-party databases?
    There are no bugs - only undocumented features.
  • aboomar
    aboomar Member Posts: 47
    I m talking about replication between 3 NAV databases
  • bbrown
    bbrown Member Posts: 3,268
    aboomar wrote:
    I m talking about replication between 3 NAV databases

    See my comment about Terminal Server/Citrix above.

    Savings:

    No need for 2 additional database servers plus OS and SQL licensing

    No need to license 2 addtional NAV systems. Yes, they are separate systems and as such must be licensed.

    Lower bandwidth requirements. This will vary depending on the volume of data being replicated but will likely be greater then the demand placed by TS.

    Easier setup and maintenance.


    Can you help me to understand the requirments that have brought you to replication?
    There are no bugs - only undocumented features.
  • garak
    garak Member Posts: 3,263
    edited 2008-08-16
    @Luc: please delete.
    Do you make it right, it works too!
  • garak
    garak Member Posts: 3,263
    @bbrown: its true. For the firsr view, we could say on database is enought (with TS or Citrix). But in some cases (appl.) a seperate DB is very usefull (needed). Like an offline POS, with a sepereate DB.

    @abo: Replication without SQL :-k .
    It's also possible, but i will not call it replication. So it's an easy file sharing to an AppServer or an NAV-Client (ok, SQL Replication is the same princp.).

    but back to the question of bbrown: do you realy need 3 DB's :?:
    you're realy sure you need 3 DB's. If the customers do the same, like purchasing or sales, i would use the same dB, and let the user connect per Microsoft Terminal Service or Citrix Terminal serive.

    so, this is my last post this day, because we have a festival this weeekend in Hannover ..... \:D/

    Regards.
    Do you make it right, it works too!
  • bbrown
    bbrown Member Posts: 3,268
    garak wrote:
    @bbrown: its true. For the firsr view, we could say on database is enought (with TS or Citrix). But in some cases (appl.) a seperate DB is very usefull (needed). Like an offline POS, with a sepereate DB.

    ...
    Regards.

    Yes, I would agree that there are situtations where a seperate DB makes sense. But these rarely require replicating the entire database.
    There are no bugs - only undocumented features.
  • garak
    garak Member Posts: 3,263
    i doen't know what aboomar need.
    We need more informations, what he mean to replicate for datas.

    O, i see many spelling mistake in my posts .... so it's enought for me this evening -.....
    Do you make it right, it works too!
  • aboomar
    aboomar Member Posts: 47
    My client have a three sites and he want to install in every site server
    One for warehouse
    One for Showroom
    And the main server for NAV in HO
    In the beginning I suggest working should be with Citrix but he want to install on every site one server and make the replication on the main server from other Sites but in same time we finished the transaction in the sites and he thinking to work with database Cside Client
    So what can I do with this issue?
  • bbrown
    bbrown Member Posts: 3,268
    Is your client aware that this will require licensing (aka: purchasing) three NAV systems?
    There are no bugs - only undocumented features.
  • aboomar
    aboomar Member Posts: 47
    Yes he know
  • bbrown
    bbrown Member Posts: 3,268
    What are your client's reasons for wanting 3 seperate databases versus using Terminal Services?
    There are no bugs - only undocumented features.

Categories