I've started with the development of a website which will use a sql server 2005 database. I want to use the asp.net membership and roles functionality. In the end the website will be hosted by a hosting company.
What is the best way to store the database? In the App_data folder or outstide the App_data folder?
Second, do hosting companies support placing sql server databases stored into the App_data folder?
1) app_data - not good idea. the database file in app_data folder maybe will work for you intranet project but in my opinion it is not good idea. It works great when you want to "play" with VWD and SQL express... BTW SQL express is GREAT so use it but do not create databse file ! - just login to your SQL server and create db. When you finish your project backup db and restore on live server.
2) no ! i mean not the one i know :) i work with 10 diffrent hosts and NO they don't. I guess if you will look for one you will find one... but most hosting companies offers full SQL 2005 servers and they don't support app_data folders. What some hosting companies do, they offer tools that will allow you to copy/upgrade your db to SQL 2005
hope this helps
No comments:
Post a Comment