How to send mdf in new ASP.Net to the web

Question

User-775831949 posted

I have created new ASP.Net using VS2017 and it is working fine on my PC. It is a  standard site with register/login.

I have published from VS2017 to Azure and the page loaded ok.

However I found the database in my PC did not publish to Azure. I already subscribed to SQL Database and have created SQL server and created new database. I have created SQL Data Connection to point to this database too. Still, when I click register it does not connect to database and lead to no SQL database found error.

So how to copy the mdf in App_Data folder to Azure ?
I cannot find upload mdf to Azure. In Azure Portal SQL database section I cannot find upload too.

Please help...

Answer 1

User-1946294156 posted

If you are using Entity Framework, it should automatically build it.  

If you are not, you need to know that Azure SQL Server is not the same as (it is the same product, but behaves differently from a management perspective).  

Overall, you are talking about doing a DB migration, this article might be helpful, https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate.  

Answer 2

User1771544211 posted

Hi hkbeer,

So how to copy the mdf in App_Data folder to Azure ?

I find a similar issue here : https://stackoverflow.com/questions/12870996/using-a-localdb-mdf-file-on-azure

You can't use an .mdf file in App_Data, but you aren't forced to SQL Azure -- you can use SQL Server Compact. Deployment from LocalDB to Compact is easy if you are using Code First Migrations; otherwise you will have to migrate to SQL Server Compact before you deploy.  If you decide to go with Compact you'll have to make sure the database engine gets deployed, and you can find instructions for that in this tutorial:

http://www.asp.net/mvc/tutorials/deployment/deployment-to-a-hosting-provider/deployment-to-a-hosting-provider-deploying-sql-server-compact-databases-2-of-12

Best Regards,

Jean