I am developing an ASP.NET site with Visual Studio 2008 Standard SP1 and SQL Server Express 2008 on Windows Vista SP1. Debugging is running via IIS.
Until now I've been using a regular database stored in the MSSQL\Data, but would like to move to the web project's APP_DATA dir so I can use version control with the database.
But how can I do this?
If I try to detach my existing database, move it into app_data and re-attach, SQL server moves it back into MSSQL\Data. When I try to create a new file-based database in app_data via Visual Studio via right-click -> Add new Item -> SQL Server Database it gives me this error message
>>Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251<<
This makes no sense since I am using SQL Server Express 2008.
So, how can I do this? Any suggestions and pointers to newbie-friendly tutorials would be greatly appreciated