[2005] How do I move my ASPNETDB.MDF to my website?

[bomayed]

I have created a login page and applied some rules and every thing is working perfectly on my machine , now how can I move everything to my website ? do I upload my ASPNETDB.MDF to my website ? If so , how do I link my login pages to connect to the database ?

[ComputerJy]

There is a folder called app_data created by VS when automatically or you can add it as manually. put your mdf file there and change your DB connection string to attach DB from file

[mendhak]

And make sure your connection string is correct, and that it reflects what the new structure might be on the remote box.

[bomayed]

Where do I place a connection string ? and what is the correct format ?

[ComputerJy]

You can place it where ever you want. the "web.config" is a good idea (but make sure you encrypt it if it has the login info (password).

And there is no 1 connection string format, you can check this website for methods to build your connection string

[the_menace]

Don't the web.config already do this automatically for you when you created the database anyways? The connection string should be in place in there already, and it is just a matter of re-configuring it to your remote server.

[ComputerJy]

Don't the web.config already do this automatically for you when you created the database anyways? The connection string should be in place in there already, and it is just a matter of re-configuring it to your remote server.

Only when using wizards

[bomayed]

Sorry but I didn't get it ,

I already have a folder called App_Data , I uploaded this folder to my website , then what ?

I looked in to the web.config file and all I can see is this:

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <system.web>
      <authorization>
            <allow roles="Administrator" />
            <deny users="?" />
        </authorization>
    </system.web>
  </configuration>

do I need to add the connection string in between these lines and am all set ?


Oh and my webhosting company supports using (MS SQL Database) , is that the same as (Microsoft SQL Server 2005) ?

[ComputerJy]

1- well, you have to ask.. MS SQL might mean SQL 2000 or SQL 2005 (which supports both)
2- The app_data must contain your DB .mdf file to work.
3- You need to change the connection string where ever you put it. and in your case it's not in the web.config. (even though putting it in the web.config would be a better idea)

[mendhak]

You really should contact your host and ask them these details. They might have a different folder just for MDFs and you'll need to change your connection string to reflect that.