MSSQL send data to azure

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

, +

Hi,

1) Is there any way to automatically for MSSQL 2012 to send data to Azure when new data is insert? Which mean, every new data inserted will trigger some SQL Script to send the data to Azure too..is it exist?

I want to search for my question here but I don't know proper words for searching it. Does it call "Replication"?

2) And how about running Visual Studio script for MSSQL insertion?

** Got a task and quite thinking the keywords for the task to Google for it.
Appreciate if someone can give a correct keywords for searching these two things

What I have tried:

I'm not try anything yet. This is a general question without code.

Posted 22-Mar-16 21:27pm

Luiey Ichigo

Updated 23-Mar-16 0:50am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-03-23T00:50:00

Solution 1

If you are saying that you have a database on a local server (or PC or VM) and also want that data sent to a database on Azure then "Replication" would be a good start point.
This blog implies that there are things to come - Transactional Replication to Azure SQL DB now in public preview | Microsoft Azure Blog[^]

"Synchronization" would be another topic to research e.g. - Getting started with SQL Databases Data Sync[^]

Posted 23-Mar-16 0:50am

CHill60

Comments

Luiey Ichigo 23-Mar-16 21:08pm

Hi CHill,

The database is on another place e.g. server but seems you are giving two things. So I try googling for "sql server replication vs synchronization" so I need to understand the details first before start. Thanks :-)

CHill60 24-Mar-16 5:28am

Have a look at both the options and see which suits you best. A lot will depend on whether you want to have the databases mirror each other in real time, or if you want to "batch up" updates to Azure.
I also thought of another couple of terms to search for - Configure Publishing and Distribution[^].
Once you've decided on the method of keeping the data up to date there will be options to script the process.

Luiey Ichigo 24-Mar-16 21:34pm

Hi CHill,

I'm using Visual Studio to perform Schema Comparison because in VS2015 Pro, it don't have "Data Compare & Schema Compare". Now I can perform schema update which it detect which part of the target data that differ from source.

Now I'm hanging on how to perform automation script to running on some interval. Do you have any thought/idea/suggestion/recommendation?

CHill60 26-Mar-16 14:22pm

I personally would not use a Schema Comparison tool - you said you wanted to send data not compare structurs. I'm afraid I have no suggestions to help you with automating this.