Replication on SQL

Dennis_Decoene
Dennis_Decoene Member Posts: 123
edited 2001-03-14 in Navision Financials
I would like to be able to set up a kind of replication services for Navision. As I am a developer, I want to be able to have a copy of the customerdatabases on a server of mine. It should be up-to-date at all times, to give support. The thing is that sometimes, customers have a license to make changes to the database too. What my idea was, was to have SQL Server replicate the db if some object changed.

This would mean, that if an object changed due to customer intervention, in a matter of hours, our copy would be actualised automatically. Likewise, if we modify the db here, changes would be reflected in his database too. All this without having to go back and forth with disks or CD's. And, this way, you never have inconsistency's or overwrite your own programming nor the customers programming (give or take a delay time).

Now the problem arises that I don't want the customers data (invoices, vendors, account shedule,...) because it takes a lot of space.

My question to you: is there a way to split the objects (with their C/AL and all) from the data to accomplish this kind of replication?
Dennis Decoene
Navision Software Engineer
http://www.microcomputing.be

[This message has been edited by Dennis_Decoene (edited 20-02-2001).]

Comments

  • Ian_Wilson
    Ian_Wilson Member Posts: 25
    Will just replicating the Object table work?
  • Dave_Cox
    Dave_Cox Member Posts: 83
    how do you control this?

    Just train the customer to send updates by email.

    What would happen if you replicated an object that was uncompiled crashing the Customers Database?
    or replicated unfinished and tested work!



    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
  • Dennis_Decoene
    Dennis_Decoene Member Posts: 123
    I figured it out before your reply, Ian, and it does work.

    Dave, we allways have a Programming and a Production database. when we are confident that a certain piece of software is finished at our site, it is moved to the production database. This is thent replicated to the customers site. Same for on-site programming. We have allways done it this way.

Categories