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.
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
Jai Ganesh. J, IDC, India
Please Mark As Answer If my reply helped you.
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
redwoodbev
Member
29 Points
166 Posts
Does club-add.sql set up both databases?
May 22, 2009 05:59 PM|LINK
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.
ClubSite GoDaddy clubsite databases setup club-add.sql
Ganesh@Nilgr...
Contributor
6074 Points
2354 Posts
Re: Does club-add.sql set up both databases?
Aug 27, 2009 08:31 AM|LINK
one database would be sufficient . use aspnet_reqsql and copy all the tables and sps to the existing database
Please Mark As Answer If my reply helped you.
kuttikrishna...
Member
57 Points
48 Posts
Re: Does club-add.sql set up both databases?
Oct 27, 2009 12:41 PM|LINK
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