Image for post
Image for post

Export entire on-premise database to Azure is pretty easy. What, if you want to move only certain data or schema, not entire database. You can use Microsoft Data Migration Assistant. Lets assume, that we have three tables in on-premise databse: Airline, Airport, Flight and we want to move them into Azure (schema and data).

Choose your source and destination database type. In this case source is on-premise SQL Server Databse and destination is Azure SQL Database. Scope concerns: data, schema or data + schema.

Michał Mółka

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store