Does club-add.sql set up both databases?

Hi, I'm trying to set up the clubsite on godaddy and following the excellent GoDaddy Installation Walkthrough on this forum. I'm confused about the databases. In my clubsite there are two databases under App_Data. One is ASPNETDB.mdf and one is Club.mdf. There is one club-add.sql file.

As I understand the instructions...I should create my databases in GoDaddy, then copy the club-add.sql and paste the text in the Query Analyzer and submit. This will create the tables, etc. for the database.

Do I do this just once into one database, or once into each database, or is there another file I should be copying and pasting for the second database? Also, must I do this first, before uploading my site to the host? Thanks.

Re: Does club-add.sql set up both databases?

redwoodbev

Hi, I'm trying to set up the clubsite on godaddy and following the excellent GoDaddy Installation Walkthrough on this forum. I'm confused about the databases. In my clubsite there are two databases under App_Data. One is ASPNETDB.mdf and one is Club.mdf. There is one club-add.sql file.

As I understand the instructions...I should create my databases in GoDaddy, then copy the club-add.sql and paste the text in the Query Analyzer and submit. This will create the tables, etc. for the database.

Do I do this just once into one database, or once into each database, or is there another file I should be copying and pasting for the second database? Also, must I do this first, before uploading my site to the host? Thanks.

one database would be sufficient . use aspnet_reqsql and copy all the tables and sps to the existing database

Re: Does club-add.sql set up both databases?

hai

the ASPNETDB you found under the app_data folder is used for the authentication and authorization purpose of the users in ur site

you just dont do any thing in the aspnetdb it is automatically created when the website administration tool is used .

you just do in the club database only , you can run the file before or after hosting its not a problem , if you use aspnet_regsql .exe tool to copy the schema of the aspnetdb to the newly created database there is no need to host both the db's one is enough and change the connection string in machine.config file to your applications web.config file then every thing will be ok