𝗠𝗼𝘃𝗲 𝗟𝗼𝗰𝗮𝗹 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝘁𝗼 𝗔𝘇𝘂𝗿𝗲 𝗦𝗤𝗟 𝘄𝗶𝘁𝗵 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 𝗔𝗽𝗽 – 𝗙𝘂𝗹𝗹 𝗗𝗲𝗽𝗹𝗼𝘆𝗺𝗲𝗻𝘁 𝗚𝘂𝗶𝗱𝗲

When deploying an ASP.NET Core app to Azure, you may also need to move your 𝗹𝗼𝗰𝗮𝗹 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲 to 𝗔𝘇𝘂𝗿𝗲 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 so your application can access it online. Here's how to do both using 𝗩𝗶𝘀𝘂𝗮𝗹 𝗦𝘁𝘂𝗱𝗶𝗼**.

𝗦𝘁𝗲𝗽-𝗯𝘆-𝗦𝘁𝗲𝗽 𝗚𝘂𝗶𝗱𝗲

𝗦𝘁𝗲𝗽 𝟭: 𝗣𝗿𝗲𝗽𝗮𝗿𝗲 𝗬𝗼𝘂𝗿 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 𝗣𝗿𝗼𝗷𝗲𝗰𝘁

• Ensure your project is running locally with the SQL Server database (typically via appsettings.json connection string).

𝗦𝘁𝗲𝗽 𝟮: 𝗖𝗿𝗲𝗮𝘁𝗲 𝗔𝘇𝘂𝗿𝗲 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲

1. In 𝗩𝗶𝘀𝘂𝗮𝗹 𝗦𝘁𝘂𝗱𝗶𝗼 > 𝗩𝗶𝗲𝘄 > 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗢𝗯𝗷𝗲𝗰𝘁 𝗘𝘅𝗽𝗹𝗼𝗿𝗲𝗿.
2. Right-click 𝗔𝘇𝘂𝗿𝗲 > 𝗔𝗱𝗱 𝗔𝘇𝘂𝗿𝗲 𝗔𝗰𝗰𝗼𝘂𝗻𝘁 and sign in.
3. Right-click your 𝗔𝘇𝘂𝗿𝗲 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻 > 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿𝘀 > 𝗔𝗱𝗱 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿.
4. Create a new 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗮𝗻𝗱 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲.

• Choose 𝗙𝗿𝗲𝗲 𝗧𝗶𝗲𝗿 if available.
• Note the 𝘀𝗲𝗿𝘃𝗲𝗿 𝗻𝗮𝗺𝗲, 𝗮𝗱𝗺𝗶𝗻 𝘂𝘀𝗲𝗿𝗻𝗮𝗺𝗲 & 𝗽𝗮𝘀𝘀𝘄𝗼𝗿𝗱.

𝗦𝘁𝗲𝗽 𝟯: 𝗗𝗲𝗽𝗹𝗼𝘆 𝗟𝗼𝗰𝗮𝗹 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝘁𝗼 𝗔𝘇𝘂𝗿𝗲

1. In 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿 𝗢𝗯𝗷𝗲𝗰𝘁 𝗘𝘅𝗽𝗹𝗼𝗿𝗲𝗿, right-click your 𝗹𝗼𝗰𝗮𝗹 𝗗𝗕 > 𝗣𝘂𝗯𝗹𝗶𝘀𝗵 𝘁𝗼 𝗔𝘇𝘂𝗿𝗲.
2. Choose the Azure SQL Server you created.
3. Review settings > Click 𝗣𝘂𝗯𝗹𝗶𝘀𝗵.

• It creates tables, schemas, and data in Azure SQL.

𝗦𝘁𝗲𝗽 𝟰: 𝗨𝗽𝗱𝗮𝘁𝗲 𝗖𝗼𝗻𝗻𝗲𝗰𝘁𝗶𝗼𝗻 𝗦𝘁𝗿𝗶𝗻𝗴 𝗶𝗻 𝗮𝗽𝗽𝘀𝗲𝘁𝘁𝗶𝗻𝗴𝘀.𝗷𝘀𝗼𝗻

Replace local DB connection with the Azure one:

"ConnectionStrings": {
"DefaultConnection": "Server=tcp:.database.windows.net,1433;Initial Catalog=;Persist Security Info=False;User ID=;Password=;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
}

𝗦𝘁𝗲𝗽 𝟱: 𝗗𝗲𝗽𝗹𝗼𝘆 𝗔𝗦𝗣.𝗡𝗘𝗧 𝗖𝗼𝗿𝗲 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝘁𝗼 𝗔𝘇𝘂𝗿𝗲

• Right-click the project > 𝗣𝘂𝗯𝗹𝗶𝘀𝗵.
• Choose 𝗔𝘇𝘂𝗿𝗲 𝗔𝗽𝗽 𝗦𝗲𝗿𝘃𝗶𝗰𝗲, sign in, and create App Service if needed.
• Publish the app.

Now your ASP.NET Core app is live on Azure and connected to 𝗔𝘇𝘂𝗿𝗲 𝗦𝗤𝗟 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲.

𝗛𝗮𝘃𝗲 𝘆𝗼𝘂 𝗲𝘃𝗲𝗿 𝘁𝗿𝗶𝗲𝗱 𝗱𝗲𝗽𝗹𝗼𝘆𝗶𝗻𝗴 𝘆𝗼𝘂𝗿 𝗹𝗼𝗰𝗮𝗹 𝗗𝗕 𝘁𝗼 𝗔𝘇𝘂𝗿𝗲 𝗮𝗹𝗼𝗻𝗴 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗮𝗽𝗽? 𝗪𝗵𝗮𝘁 𝘁𝗶𝗽𝘀 𝗼𝗿 𝗰𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲𝘀 𝘄𝗼𝘂𝗹𝗱 𝘆𝗼𝘂 𝘀𝗵𝗮𝗿𝗲 𝘄𝗶𝘁𝗵 𝗼𝘁𝗵𝗲𝗿𝘀?