How do I migrate data from some On-Premise SQL Database to Azure SQL Database

Question

I have an existing database with several tables in on-premise SQL Database. In AZURE SQL Database, I have created 2 databases i.e. DatabaseA and DatabaseB. What I want to do is just load data from 1 table in on-prem SQL Database, do some staging and then load some fields into DatabaseA and some to DatabaseB.

What is the best way to achieve this DATA migration? (just to be clear, I don't want to migrate the whole database)

In a nutshell, I want to insert data into Azure SQL Databases (DatabaseA and DatabaseB) from my ON-PREM SQL Database....

Alberto Morillo · Accepted Answer · 2020-03-20 18:48:00Z

1

Use SQL Server Integration Service (SSIS) to create a project that will load that from the SQL Server instance into both databases. Here you will find an example, you just need to add any transformation of data you need.

answered Mar 20, 2020 at 18:48

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How do I migrate data from some On-Premise SQL Database to Azure SQL Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related