Move my login application to my host

[Marty]

As you will soon be able to tell I am new to web development.
I am using VS2005 and I have created a simple site and used the Login
control to have members login. I used the ASP configuration to create
a database.
Now I would like to move this to my hosting account except there are
problems.
My host allows me 1 SQL 2005 data base. I would like to move all of
the required tables from my ASPNETDB to my hosted database and change
the connection string to use that database.
Is this possible? If so how? Is there any place that I could go that
explains how to do this?

 

[Mark Rae]

As you will soon be able to tell I am new to web development.
Hello.

I am using VS2005 and I have created a simple site and used the Login
control to have members login. I used the ASP configuration to create
a database.
OK.

Now I would like to move this to my hosting account except there are
problems.
OK.

My host allows me 1 SQL 2005 data base. I would like to move all of
the required tables from my ASPNETDB to my hosted database and change
the connection string to use that database.
Is this possible? If so how? Is there any place that I could go that
explains how to do this?

I'm presuming that you have used SQL Server 2005 locally...

I'm also assuming that your ISP has provivided you the credentials necessary
to connect to "your" online database...?

If so, then it should be a fairly simple matter to use the Copy Database
Wizard:
http://msdn2.microsoft.com/en-us/library/ms188664.aspx

As for your connection string, again your ISP should have provided you with
that, though you should be able to construct it from your login
credentials...
http://www.connectionstrings.com/?carrier=sqlserver2005

However, some ISPs (mine does this) will require you to specify an internal
IP address for the database when your website connects to it, rather than
the external IP address which you use to connect to it... They should be
able to provide you with everything you need...