Copy Sql Database on-premisse to SQL Database Azure

Question

Hello, everybody

I have a doubt:

It is possible do a copy from on-premise database to sql dabatase in azure?

I am doing a test like: copy data from on-premise via data factory, and paste in a blob storage and later i paste in sql database, but it is possible copy directly? on premise and sql database?

Answer 1

Copy on-premises database to Azure SQL database is fully supported in data factory, as long as your Azure SQL database is accessible to the on-premises data gateway.

Depends on your Azure SQL database access rules, if it allows IP from your on-premises gateway, then direct copy will work. Otherwise if it only allows Azure IP, you could use the way your described as a route path, or use Staged Copy (https://docs.microsoft.com/en-us/azure/data-factory/data-factory-copy-activity-performance#staged-copy ).

Answer 2

Tks for answering ....

I used the wizard, and I created this connection :)

https://docs.microsoft.com/en-us/azure/data-factory/data-factory-copy-data-wizard-tutorial