are there supposed to be 2 databases?

Last post 05-30-2009 12:56 PM by whighfield. 5 replies.

Sort Posts:

  • are there supposed to be 2 databases?

    05-27-2009, 9:39 PM
    • Member
      55 point Member
    • RaeKC
    • Member since 11-28-2008, 10:52 PM
    • Posts 338

    Looking at the installed web, i notice two databases, the asp.net .mdf and the personal.mdf? Do you need both for this web package??

    RAchel

  • Re: are there supposed to be 2 databases?

    05-27-2009, 10:28 PM
    • Contributor
      7,249 point Contributor
    • whighfield
    • Member since 01-02-2006, 10:37 PM
    • Winterpeg, Manitoba
    • Posts 1,205

    Yes and no, most people combine the aspnet.mdf and the personal.mdf into one database.  The aspnet.mdf holds your user information like logins and user settings, the personal.mdf holds your album and picture information.

    FYI: the stock personal web starter kit (pwsk) stores the images in the database which is not very web hosting friendly if you plan on using it for your personal site on a paid hosting account.  You might want to search for articles about how to convert the default photo storage to storing them to disk (file system).  There are many articles out there and guides on how to do this.

    Please mark the most helpful reply/replies as "Answer".

    - William
    http://thefrozencoder.ca
  • Re: are there supposed to be 2 databases?

    05-27-2009, 11:02 PM
    • Member
      55 point Member
    • RaeKC
    • Member since 11-28-2008, 10:52 PM
    • Posts 338

     Thanks.

    How do you combine the asp.net and personal? -- Can you just add the tables in the personal, to the asp.net?

    Rachel

  • Re: are there supposed to be 2 databases?

    05-27-2009, 11:22 PM
    • Contributor
      7,249 point Contributor
    • whighfield
    • Member since 01-02-2006, 10:37 PM
    • Winterpeg, Manitoba
    • Posts 1,205

    Yep, I beleive that there are scripts in the app_data to add the tables and such

    Please mark the most helpful reply/replies as "Answer".

    - William
    http://thefrozencoder.ca
  • Re: are there supposed to be 2 databases?

    05-29-2009, 8:38 PM
    • Member
      55 point Member
    • RaeKC
    • Member since 11-28-2008, 10:52 PM
    • Posts 338

     thanks. This web has some features I like but needs too many changes/upgrades. For example, I don't see any way to recover a lost password and then there's the thing with holding the images in a database. .... But I like being able to create the photo albums and the way its presented.  I'd like to combine some parts of this web with the beerhouse for a project i have in mind.

    I wonder how hard it would be to just lift the album maker feature and the style layout?

    Rachel

  • Re: are there supposed to be 2 databases?

    05-30-2009, 12:56 PM
    • Contributor
      7,249 point Contributor
    • whighfield
    • Member since 01-02-2006, 10:37 PM
    • Winterpeg, Manitoba
    • Posts 1,205

    I am not to familiar with the beerhouse project so I don't know if the design of either would be compatible with each other, certainly not just a drop in place and it works but who knows.  Probably easier to add the features to the beerhouse kit and then style the beerhouse like the PWSK if the beerhouse is designed with master pages in mind it might not be to hard.

    Please mark the most helpful reply/replies as "Answer".

    - William
    http://thefrozencoder.ca
Page 1 of 1 (6 items)