HOw to host sql database and visual studio programm

Verheffen Systems - Admin 1 Reputation point
2022-05-02T05:15:00.733+00:00

Hi

I have a project build on Visual Studio and SQL Database.
Can you help me to host the same on my domain with MS Azure.

Regards
Danish Shaikh'
9370902913

Azure SQL Database
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,579 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2022-05-02T09:02:48.603+00:00

    Thanks @Verheffen Systems - Admin for providing more details.

    As you mentioned we need to migrate database as well as web application, lets look at it step wise:

    1). Migrate local SQL Server to Azure SQL Database using DMS:

    Tutorial: Migrate SQL Server to Azure SQL Database using DMS

    This article provides step by step process of migrating the database from local(on-premise) server to Azure.

    2). Once this is done you can try connecting to Azure SQL Database using any tool like SSMS, Azure Data Studio etc. After testing the connection, you can make these db changes in connecting string of your web application accordingly.

    3). Then we need to deploy the web application to Azure. Please refer to below article that uses Visual Studio to deploy it on Azure App service.

    Quickstart: Deploy an ASP.NET web app

    This is again step by step process to deply.

    Please let us know if this helps or else we can discuss further on the same.

    ----------

    If answer is helpful, you can mark it 'Accept answer'