How to host ASP.NET website with ms sql file?

Question

1.30/5 (3 votes)

See more:

Hello,

I am not new to .NET, but developing & hosting website for 1st time.

I have created an asp.net website for a bookstore, on my local machine using visual studio.

For backend I created ms sql database file (mdf) and used that in my website. I stored connections and commands @ web.config.

Now i want to host my website on a paid server & make is accessible to everyone! (Bring it Online)

Please help me how can I proceed, specially as I have database file as well with me.

Do I need to upload the mdf file as well on server & will it work in similar manner as it is working in my local machine's project?

Or do i need to use the SQL Servers present on the Web Server providers? Anything else i need to take care ?

My Website is ready & it works flawless with db connection? Do i need to test anything extra after uploading it?

I would really really appreciate If you help me in my genuine work, though it sound silly to you.

Plz don't leave links of other websites unless they are really helpful :)

Thanks in Advance

Rahul

Posted 23-Sep-14 23:47pm

Rahul Sarkar

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Deepak Kr Choudhary · Answer 1 · 2014-09-24T00:29:00

Hi
it is very easy to deploy your website online.
1> First your purchase domain name and sever space.which is provided by multiple of web hosting portal like godady.com,hostgatter.com,Bigrocks.com etc.

2> After that you have userid and password provided by the hosting sever site.

3>Using userid and password open Control Panel of the Server site.

3>After that upload the all the file and folder related to your website.

4>for the database web server site provide sql server database space as well.

4>for database attachment first your crate a backup or scrip file of your database.

5>After that server site provide a option like restore backup file or new query file etc choose one option if your have a backup file or scrip file.

6>after successfully restore file now copy the connection string which is provided by the server site online on the same control panel.

7>Change the connection sting of your web config.

7>Control panel also provide default document option that is which page your want to open first.

8>now open your domain name of browse and enjoin.

Codes DeCodes · Answer 2 · 2014-09-24T00:17:00

Upload your website on your paid server. Your paid server might allow you to add your database into their server. If they allow, its fine, else, you can created your database in server somewhere and manage your connectionstring in web.config to access database of remote server via public ip..

How to host ASP.NET website with ms sql file?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0