Ok I created a web app with membership & role, intially I had 2 db but combined data with the default aspnetdb.mdf created to simplify.
I then used "copy web" to move all asp files & roles folders to remote server in a sub domain directory.
Created a backup of the aspnetdb.mdf and then ftp to sub domain directory which was then loaded by the host as MS SQL db name: aspnetdb3.
Now, I know I need to change the web.config connection settings but to what???
here is the initial connection setting:
<add name= Go to the complete details ...