User1751268424 posted
Hi Mike,
In SQL Server 2012 is introduced a new database called LocalDB, it is smaller than SQL Express edition. the data base name is also xxxxx.mdf and can be used on SQL Express 2012 and rSQL 2012 standard.
This localDB is automatically install on VS 11 beta, and use on SPA and other project template, the location of db is under username folder. For example my user id is j.siahaan, the folder is c:\Users\j.siahaan and then database
is located and named automatically when we create a new project. But we can modified it. on sample attached I commented the automated connectionString and I change from localDB to SQL Express 2012.
<connectionStrings>
<!--<add name="AppDbContext"
connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-DeliveryTracker-201242195131;Integrated Security=true"
providerName="System.Data.SqlClient" />-->
<add name="AppDbContext"
connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=aspnet-DeliveryTracker-201242195131;Integrated Security=true"
providerName="System.Data.SqlClient" />
</connectionStrings>
At the code, database file name are: "aspnet-DeliveryTracker-201242195131.mdf" and it's log "aspnet-DeliveryTracker-201242195131_log.ldf" located under "C:/Users/j.siahaan" folder, again j.siahaan is my user name on my computer. I copy these two
files to other folder, and I attached them to my SQL Express 2012. We can not use the previous version of SQL Server. This is working fine, and I am still working on it.
Hope this can answer your question.