Last post Jul 20, 2017 07:33 AM by Zhi Lv - MSFT
Jul 20, 2017 03:22 AM|farooqspecials|LINK
The Steps to publish website on azure are
but in the above case new database is Created.. what is the way to transfer the existing database with data present locally to azure database
Jul 20, 2017 04:47 AM|kaushalparik27|LINK
Easiest way is to Generate Script and run it against Azure database. Here is step by step approach that you may refer to transfer local database to Azure:
Jul 20, 2017 07:33 AM|Zhi Lv - MSFT|LINK
what is the way to transfer the existing database with data present locally to azure database
Please check my reply in this thread:
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:
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: