Switch DB From local SQL to AZURE DB with MVC5 App

Question

I've Create MVC5 APP with Local DB like the following link(step 1 to 5) http://www.asp.net/mvc/tutorials/mvc-5/database-first-development/creating-the-web-application And the application is running as expected and now I need to change the DB from the sql Lite to azure DB ,I have created the same DB in azure (same data structure)and now what I want that the application use this DB ,There is simple way to do that ?

Im using VS2013 for web.

Have you followed the tutorial for this? If you want to deploy your website on azure as well, there's a step-by-step documentation for this — Marco
– Marco, Commented Mar 23, 2014 at 12:22
windowsazure.com/en-us/documentation/articles/… there you go — Marco
– Marco, Commented Mar 23, 2014 at 16:06
@Serv- Thanks I already see that...the adding class but I didnt see where you actually connect it to the azure DB. in addtion there is no way to do that by add ADO.net entity frame work and generate from the DB that I already created in azure? — 07_05_GuyT
– 07_05_GuyT, Commented Mar 23, 2014 at 16:12

Andrea Coluccio · Accepted Answer · 2014-03-23 18:36:48Z

2

Just change the "source" and "initial catalog" parameters of the connection string in the web.config file. Also, SQL Azure doesn't work with integrated security so you need to remove the "integrated security" parameter from the connection string and add the parameters "User ID" and "Password" with the credential of a user that you created in SQL Azure.

Open Visual Studio In Solution Explorer
find the file web.config
Look for the section connectionStrings

You should find something similar to:

<add name="testEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=(LocalDB)\v11.0;attachdbfilename=|DataDirectory|\test.mdf;integrated security=True;connect timeout=30;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

You need to:

Replace (LocalDB)\v11.0 with the name of your server
Remove "attachdbfilename=|DataDirectory|\test.mdf;integrated security=True;"
Add "Initial catalog=[name of your database in SQL Azure];user id=[name of your user id on SQL Azure];password=[your password]

edited Mar 23, 2014 at 18:36

answered Mar 23, 2014 at 14:14

Andrea Coluccio

8366 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

07_05_GuyT Over a year ago

Thanks Andrea, voted up,Im very new to this topic e.g. where the source is locketed etc ,can you please provide step by step example

Andrea Coluccio Over a year ago

I put some step-by-step example in my previous reply

Collectives™ on Stack Overflow

Switch DB From local SQL to AZURE DB with MVC5 App

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related