Skip to main content
Sign in MENU

How do you transfer SQL data from one server to another?

MS Info
  • Updated
  1. You will need to detach the databases from the current SQL Server instance using SQL Server Management Studio.
  2. Then, copy both files for each database from the data directory for the SQL Server Instance and paste them into the new data directory for the new SQL Server
  3. Next, connect the databases to the new SQL Server instance using SQL Server Management Studio.
    Lastly, make sure you change the SQL Server path settings in MicroSale to use the new SQL Server instance.

To disconnect:

Open SQL Server Management Studio > Connect to Instance -> Expand Databases > Right Click on Database you wish to detach > Task > Detach

To connect:

Open SQL Server Management Studio -> Right click on Databases -> Attach -> Add ->Select database you with to attach -> ok => ok

Related articles