January 16, 2017 at 1:50 pm
We need to sync an online Azure database to an on prem database. The database in Azure is a transactions database collecting online purchases and customer data from our ecommerce sites. We need to pull this data down to our on prem CRM so the first step is to copy down the data to a database on premise in order for our importing application to ETL it into the CRM. We have been tinkering with SSIS on prem to connect and pull down data from the Azure Db and that seem to have worked ok. We need to poll this database as realtime as possible but every few minutes isn't a problem. Is SSIS the best way to do this type of thing or should we be using a different service/tool to do the continuous download of data into the on prem database for processing.
April 24, 2017 at 3:34 pm
This post was a while ago, but I thought I would reply.
Have you heard of data sync services? I am looking to do the same thing. I have an azure database that I need to sync with an on premise database. From a few articles that I have come across, this may be the way to sync my database from azure.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply