What is the database "standard" in 2.0?

[VB Programmer]

If you want to store custom tables in ASP.NET 2.0, such as Products,
Companies, Shopping Carts, etc... where is the standard place to put the
tables? I want to link it to the user/membership tables. BUT, is it "ok" or
the standard practice to go ahead and use the ASPNETDB.mdf to store your own
tables?

 

[Guest]

For small web sites the solution you've specified is fine.
Larger web sites will likely have their own database, in which case the
membership table either remain in a separate database or the SQL scripts are
run to include the tables in the site's main database.

 

[VB Programmer]

Excellent response!

Now, if I deploy a ASPNETDB.mdf with custom tables, etc..., if I LATER add a
table, or field, etc... what is the best way to update the database without
losting current data? Is Enterprise Manager the tool I can use? If so,
what password do I use to get into the ASPNETDB.mdf? I tried with 'sa' (no
password) with no success.

(I have MSDN Universal account so might have access to other tools you
recommend.)

Thanks!
Robert

 

[Steve C. Orr [MVP, MCSD]]

Check this out:
http://www.microsoft.com/downloads/...98-c57a-419e-acbc-2a332cb7f959&displaylang=en

 

[VB Programmer]

Thanks once again Steve!

Check this out:
http://www.microsoft.com/downloads/...98-c57a-419e-acbc-2a332cb7f959&displaylang=en

 

[VB Programmer]

I don't know which username was selected by default. I never remember
selecting one and have already uploaded the ASPNETDB.MDF to the site here:
http://www.MySite.com/App_data/aspnetdb.mdf

How would I connect to it?

Thanks.