I am through building web application. I have hosted it on Azure. But I now scared of launching it for general public use because I dont know how to work on a live database.
I was told by a friend that there are softwares that can help check database changes. Making comparison with live and local db.
Please I need advice on how to work on a live db. I built with EF code first approach. I am scared of messing up users datas. I can't afford to make mistakes because I have financial payments on my app.
Please I need advice and recommendation of tools that would help so I simulate this before going live to the public
You don't have to worry. It is pretty straightforward process. Here are some recommendations that you can follow to overcome your fear:
First create your code-first database schema in your Azure SQL instance by changing the connection string in the application to Azure SQL.
Connect your SQL Server management studio with your Azure SQL instance to make sure that your schema worked there.
If you are happy with your schema and now you want the data to be migrated to the production database running in Azure, I don't think you will find any better resource than
this, which are best-practices officially from EF team to manage your on-premises and cloud databases.
Member
168 Points
571 Posts
Changing and modifying database while in Azure
Sep 02, 2016 03:43 PM|skliz4rel|LINK
I am through building web application. I have hosted it on Azure. But I now scared of launching it for general public use because I dont know how to work on a live database.
I was told by a friend that there are softwares that can help check database changes. Making comparison with live and local db.
Please I need advice on how to work on a live db. I built with EF code first approach. I am scared of messing up users datas. I can't afford to make mistakes because I have financial payments on my app.
Please I need advice and recommendation of tools that would help so I simulate this before going live to the public
Member
497 Points
147 Posts
Re: Changing and modifying database while in Azure
Sep 05, 2016 08:17 PM|Janshair Khan|LINK
Greetings,
You don't have to worry. It is pretty straightforward process. Here are some recommendations that you can follow to overcome your fear: