December 6, 2009 at 12:13 pm
Hi,
We have our main company application (Based on Dynamics AX) running on SQL Standard edition. We also have a small weighbridge application at another site currently running a web front end and access backend.
We are going to redevelop this sytem and looking at using SQL express as the backend. We would like some intergration between the 2 database systems, basically we would like the express system to sync with the Standard system, Purely because of the little bandwidth and the unreliabilty of the connection between sites.
What are my options. I need the information replicating as often as possible but need the weighbridge system be able to operate and store data when the connection between sites is offline.
Appriciate any assistance on this one please.
December 7, 2009 at 6:57 am
Your options are:
1. Replication - the Express instance can only be a subscriber. I'm not sure how this would work with Merge replication.
2. SSIS - Roll your own using SSIS.
3. Linked Servers
4. Develop it in .NET.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 13, 2009 at 9:35 am
Thanks Jack
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply