Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Replication on SQL
Dennis_Decoene
Member Posts: 123
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).]
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).]
0
Comments
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
Navision Service Partner
david@mindsource.co.uk
info@mindsource.co.uk
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.