CODEWITHSUNDEEP
c#sqlasp.net
Hephaestious
Hephaestious

Reputation: 451

How to put database on azure website

I recently finished my asp website, bought the domain and azure hosting. Unfortunately, when I try to do anything that accesses the database I just get stuck on a loading screen. I just used the default asp razor mvc 5 project I think for the database along with a couple of custom tables.

Upvotes: 0

Views: 38

Answers (1)

alphamalle
alphamalle

Reputation: 192

So here is how I would do it since you have an existing database. I would follow azures website, and set up a SQL database. I would then script out the database on you local machine, and log into your azure database using SQL Server Express. Execute the script you generated from localDB. Then all of your data will be good to go. You will then need to take the connection string from azure, and put it in your applications config file. After modifying the connection string in your application you should redeploy, and verify everything is working the way you want. You will be able to verify your data is there in SQL Server Express.

Here is a link that may be of quite a bit of assistance to you. It includes step by step instructions as well as screen shots.

Another option is using this tool. I have never used it, but I know a few people who have had great success with it.

Upvotes: 1

Related Questions