Should I Utilise DB in AppData Folder? 3

[golcarlad]

Just been looking at the AppData folder in my application, and noticed that all the Membership data and stuff gets stored in a SqlServer database - this basically makes my mySQL db irrelevant (esp concerning user info) - would it be better therefore to use this database for all my other applciation data rather than use a seperate db - or should this be used only for internal asp processes?

 

[ca8msm]

Generally, a database is used in the App_Data folder for test purposes. I wouldn't run a production site from it unless that is your only option.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[vbkris]

>>Generally, a database is used in the App_Data folder for test purposes

why? All data files are just MDFs and LDFs. Going by that definition there should be noe issue...

Known is handfull, Unknown is worldfull

 

[philhege]

It's an issue if your production environment runs on MySQL ;^)

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Not NULL-terminated yet.

 

[vbkris]

point!

i did not even notice that. when the poster stated both DBs in the post assumed that there was support for both...

Known is handfull, Unknown is worldfull

 

[Hans8823]

The discussion whether you should store the default MSSQL 2005 Express Membership database in the App_Data folder or somewhere else is not really an answer to the question. The question was 'if all the data should be tranfered to this database or not?'

The answer is NO, you can also build your own custom membership provider so that you can store all membership data into another database, for example a MySQL database:

http://msdn2.microsoft.com/en-us/library/aa479048.aspx

An example how to use a MySQL database can be found at:

http://www.codeproject.com/aspnet/MySQLMembershipProvider.asp

 

[golcarlad]

Nice one Hans - that sounds more like it - I just thought there should be a way to utilise this info than me having to replicate all the functionality/schema in my own DB.

Many thanks