User-271186128 posted
Hi hkbeer,
is there a way to copy the existing mdf file on my machine to Azure ? Any links to teach me to do that ?
I already created new Data Connection on Azure. In creating, I have subscribed to SQL server service, and created server and database
Here are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL DataBase.
Method1: Export the database copy to a .BACPAC file on the local drive, then, import the .BACPAC file as a new Azure SQL database using any of several BACPAC import tools
More details, you could check these articles:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database#prepare-for-migration
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-import
Method2: Use Transactional Replication
To use this method, the source database must meet the requirements for transactional replication and be compatible for Azure SQL Database.
In both cases, you need to ensure that the source database is compatible with Azure SQL Database using the Data Migration Assistant (DMA).
More details, see:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate
Best regards,
Dillion