How can I move a SQL Server LocalDb database from one machine to another?
I have a SQL Server database that was created from VS2012. I located the
database files for that. I would like to back up the database and move it
to a different machine.
My application already has started up and is running. Do I need to somehow
stop the database before I copy the files?
Can I just make a copy of the files and move them to another machine?
I have the following connectionString:
The database files are in my C:\Users\Melina folder. Will the VS2012 on
the other machine be able to access the data files without me doing
anything?
<add name="TestContext" connectionString="Data
Source=(LocalDb)\v11.0;Initial Catalog=Test;Integrated Security=SSPI;"
providerName="System.Data.SqlClient" />
No comments:
Post a Comment