how to install two databases in the personal starter kit

[sweet]

http://community.discountasp.net/emoticons/nono.gifhere are two databases in the personal starter kit, aspnetdb.mdf and personal.mdf. I think aspnetdb takes cares of user information and personal takes control of albums and photos. Do I have to combine these two or leave it as is. And how do I set up web.config to get it running. Thank you.

[vvsharma]

See : http://community.discountasp.net/default.aspx?f=25&m=8785


Use personal-add.sql(Incldued w/ Starter Kit) instead of club-add.sql




Post Edited By Moderator (Joel Thoms) : 11/16/2006 10:37:30 PM GMT

[sweet]

Thank you Vikram, for your response. You answered part of my question. Another part I am going to ask is that on discountasp.com, I need to set up 2 database or just 1 database. They charge $10 for every single database. Do I need personal.mdf or aspnetdb.mdf or both? Thank you. Sweet.

[sweet]

Thank you Vikram foryour clear explaination. It seems clear to me now.

I runosql -S SQL_SERVER_NAME -U USERNAME -P PASSWORD -d DATABASE_NAME -i personal-add.sql
command.

I got the following:

1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 4> 5> 1> 2> 3> 4>
5> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9> 1> 2> 3> 4>
5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25>
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1>
2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 1> 2> 3> 4> 5>
6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1
1> 12> 13> 14> 15> 16> 17> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16
> 17> 18> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4
> 5> 6> 7> 8> 1> 2> 3> 4> 1> 2> 1>

I guess it creates the personal DB schema.

But when I opened my website, everything is OK except I can't see all the albums and pictures.

Sweet

[vvsharma]

Yes the personal Starter Kit has two DB's,i.e personal.mdf or aspnetdb.mdf and you need both.
If you see in the link I provided ,
1>aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name] will install the schema for ASPNETDB.mdf and
2>for the personal.mdf you could either </font> attach it using the MS SQL tools(Control Panel) or run this command in your command prompt:sqlcmd -S SQL_SERVER_NAME -U USERNAME -P PASSWORD -d DATABASE_NAME -i personal-add.sql,which will create the db schema for personal.mdf instead.

So having one DB is fine .

Vikram

DiscountASP.NET
www.DiscountASP.NET (http://www.discountasp.net/)

[bruce]

what error do you see? any URL?


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[sweet]

Thank you for the response. I just need to add some albums and photos because I just created the database schema andit is still empty. Now it is working well. Thank you again.

Sweet