.NET Azure Database Upload

Wednesday, February 7, 2018 by Nate Bross

Someone asked on Stack Overflow:

This is my connection string for my azure database:

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

my .NET database connection string is:

Data Source=|DataDirectory|Linkofy-Release.sdf

In the Package/Publish SQL do I just add my azure connection string to the destination database with my username and password, will this upload my database to azure?

What would my web.config transformation connection string then be?

I posted the following answer, which was chosen as the accepted answer and received 1 upvote:

I would get the database up to Azure myself. I recommend you look into the Data Migration Assistant.

Once on Azure, you can use the Azure App service App Settings to specify the connection string your application should use instead of web.config transformations.

Originally posted on Stack Overflow — 1 upvotes (accepted answer). Licensed under CC BY-SA.