Much to my surprise, I didn't know that SQL Server Express (*.mdf) files are compatible with regular SQL Server 2008 Databases. Related problems concern "Personal.mdf" and "aspnetdb.mdf" and "club.mdf" and other files that are common with ASP.NET examples.
I always thought SQL Server Express files were stand alone data files. So, I never bothered with them. As I was trying to get a standard SQL Server installation to work as if was a "aspnetdb.mdf" database for log-in functions. I found a solution. Much to my surprise, I could attach "aspnetdb.mdf" in SQL Server Management Studio just like a regular SQL Server database. From there, scripts can be created and reused to meet your needs.
This is cool because you can convert databases back and forth using SQL Server Management Studio.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment