Copy Table from Local Sql Database to Azure SQL Database

Question

How can I go about copying a table from a local SQL database to an Azure SQL database nightly? Maybe I should use SSIS packages?

one more approach with out using any technologies or spending time in configuration is to use Linked servers.. — TheGameiswar
– TheGameiswar, Commented Jun 13, 2017 at 13:11

David Browne - Microsoft · Accepted Answer · 2017-06-13 14:57:08Z

6

Options (in rough order of preference):

answered Jun 12, 2017 at 22:02

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

No Data Factory with Gateway?

@wBob I Added it to the list.

lol thanks @DavidBrowne. It seems like a decent candidate given Azure SQL DB is involved.

4c74356b41 · Accepted Answer · 2017-06-12 20:43:01Z

4

Looks like a good job for Azure SQL Data Sync.

I won't copy paste the article here, but the main steps are:

Step 1 - Create sync group
Step 2 - Add sync members
Step 3 - Configure sync group (here you can choose tables)

The link I've provided has the details

answered Jun 12, 2017 at 20:43

4c74356b41

71.4k7 gold badges118 silver badges155 bronze badges

Mark West · Accepted Answer · 2017-06-12 22:06:03Z

1

i used SSIS was the quickest way in the end, doing a data task

answered Jun 12, 2017 at 22:06

Mark West

1171 silver badge13 bronze badges