Publishing SQL Server database to Azure

Question

User-1286266314 posted

Hi,

I have published a Web Forms web app to Azure.

Now, I am trying to create a database which will contain data to be displayed on this website.

Can someone please tell me the required steps to create & deploy an SQL Server database on Azure please?

I've created databases previously by adding .mdf files to Visual Studio projects, but nothing else.

Thanks a lot for the help!

Answer 1

User-1315512054 posted

Hello,

You could check at:

https://docs.microsoft.com/en-us/sql/relational-databases/databases/deploy-a-sql-server-database-to-a-microsoft-azure-virtual-machine

https://azure.microsoft.com/en-us/resources/videos/create-a-sql-database-in-azure/

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

Regards

Answer 2

User-271186128 posted

Hi damosull,

Can someone please tell me the required steps to create & deploy an SQL Server database on Azure please?

If you want to create Azure SQL Database, you could refer to the following articles:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-portal

if you want to migration local database to Azure SQL 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

Besides, you could refer to the following articles to use Azure SQL Database:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-dotnet#get-connection-information

Best regards,
Dillion