How to Transfer Database from One Server to Another (5 Ways)

This article mainly discusses how to transfer database from one server to another or how to transfer Microsoft SQL database from one computer to another computer in three effective ways, including using the EaseUS server migration software, the Copy Database Wizard, the backup and restore method, the Import and Export Wizard, and the Generate Scripts.

EaseUS Todo PCTrans

  Free Download

100% Secure

Page Contents
 

Page Table of Contents

"I have a database in SQL Server 2008, which I want to copy to another server. How do I make such a copy? What should I do at the other server computer to build the database once again from my copy?"

Workable Solutions Step-by-step Troubleshooting
Fix 1. How to transfer database using EaseUS server migration software (Support SQL Server, Mysql, and Oracle Now) Launch EaseUS Todo PCTrans > Select the applications...Full steps
Fix 2. How to copy database with other four ways

1. Using Copy Database Wizard...Full steps

2. Using backup and restore method...Full steps

3. Using Import and Export Wizard...Full steps

4. Using Generate Scripts...Full steps

Do you have the same demand for migrating some critical databases from one Windows server to another or from one computer to another? Right, we provide five possible ways to solve how to transfer a database from one server to another. Not all the mentioned migration is easy to apply, but following each step will completely solve the database migrating problem.

If you are a beginner of computer or programs user, the EaseUS server migration software is the simplest solution with minimal effort. The other four are useful but need more extra knowledge.

P.S. EaseUS Todo PCTrans's latest version also supports transfer SQL Server 2008/2004/2019.

  Free Download

100% Secure

related articles

How to Migrate MySQL Database to SQL Server | Step-by-Step

This article will provide three ways to convert MySQL to SQL Server, including using EaseUS Server Migration Software and SQL Server Migration Assistant. Read on to learn more solutions to migrate MySQL database to SQL Server.

migrate sql

Method 1. How to Transfer Database from One Server to Another with EaseUS Server Migration Software

As the most reputed PC to PC transfer software, EaseUS Todo PCTrans runs full compatible with SQL server 2004, 2008, or 2019, you'll first download the software on both PCs. It adopts Windows XP - Windows 11/10 and Windows 2003 - Windows 2019.

What it can transfer lies in programs, files, data, programs, settings, user accounts, or server databases. That why we recommend this Windows Server 2016 migration tool, with the highly visited post to transfer applications from Windows one server to another.

In fact, EaseUS Todo PCTrans is able to transfer everything in bulk on multiple computers at once, and automatically. You can easily do the database migration by simply setting up the involved computers in the same LAN, select the database on the source server computer, and use a click to migrate the selected database to the target server computer over the internet.  

Important
Computers are not located on the same LAN? Don't bother. The other transfer mode "Backup & Restore" is available to use, which can perfectly solve the non-internet environment problem when transferring a database across servers.

Guide: How to transfer database over the internet

Step 1. Launch EaseUS Todo PCTrans on your source and target computers, connect both PCs via the internet.

1. At the "PC to PC" section, choose the transfer direction and click "Start" to continue. 

select pc to pc

2. Select your target computer via its device name, then enter its account password or verification code. Then click "Connect" to continue.

You can check the verification code on the right top of "PC to PC" mainscreen on the target computer.

connect the two pcs

Step 2. Select the categories Applications, Files, and Accounts to transfer via the internet.

If you want to transfer data selectively, click "Edit" under each category, and choose the specific items.

select applications, files or accounts

Step 3. Click "Transfer" to start transferring your apps/files/accounts from one computer to another computer via the Internet.

transfer applications, files or accounts via internet

You can view the video to get a brief introduction of EaseUS Todo PCTrans:

The below methods contains many steps than this part, trying one of them with the correct steps. Do not miss this tool to help you. Installing it to help after learning its features below.

EaseUS Todo PCTrans Enterprise

Batch computer program transfer, Windows account transfer, domain account transfer, virtual-physical machine transfer, local to cloud desktop transfer.

Technical Chat 24/7

Method 2. How to Copy Database from One Server to Another Using Copy Database Wizard

The Copy Database Wizard is built in the SQL Server Management Studio. When you have two servers and plan to migrate a database from Server A to Server B, at the same time, you're kind of server experts or administrators, then using the inbuilt database migration feature is a good way to start.

There are some noticeable limits to know if you choose the Copy Database Wizard to copy a database from one server to the other.

  • The Copy Database Wizard is not available in the Express edition.
  • A database cannot be moved or copied to an earlier version of SQL Server.
  • The Copy Database Wizard cannot be used to copy or move databases that are system, marked for replication, marked Inaccessible, Loading, Offline, Recovering, Suspect, or in Emergency Mode, or have data or log files stored in Microsoft Azure storage.

Open SQL Server Management Studio and follow the steps:

Step 1. Right-click on the database and select Tasks > Copy Database...

how to transfer database from one server to another using copy database wizard step1

Step 2. On the Copy Database Wizard window, you need to click Next to move on.

Step 3. Select a source server by entering the source server name. Use Windows authentication or SQL Server authentication mode with user name and password to enter the server. Click Next.

how to transfer database from one server to another using copy database wizard step2

Step 4. Enter the destination server name and apply the authentication information this time. Click Next.

how to transfer database from one server to another using copy database wizard step3

Step 5. Between the two transfer methods, choose to Use the SQL Management Object method and click Next.

how to transfer database from one server to another using copy database wizard step4

Step 6. Now you arrive at the step where you can choose the specific database. After selecting the database, there are options to Move or Copy the selected database. Tick Copy if you wish to keep it on the original server. Otherwise, tick Move, which will move the database to the next server.

how to transfer database from one server to another using copy database wizard step5

Step 7. Next, you can check the MDF and log file path on the destination machine. Follow the wizard to the final step. After success, you can see the database (according to its name) is on the right path of the destination server machine.

Method 3. How to Move Database from One Server to Another Using Backup and Restore

As you've learned, SQL Server Management Studio itself is an all-around server management toolkit. Besides using the direct way of using the copy and move feature to transfer a database from one server to another, there is another backup and restore in it you can also make full use of.

Follow the steps to create a full backup and restore it on the other server computer:

Step 1. In SQL Server Management Studio, right-click the database and select Tasks > Back Up...

how to transfer database from one server to another using backup and restore step1

Step 2. Make sure that the backup type here is Full. Click Add and specify the location and backup name.

how to transfer database from one server to another using backup and restore step2

Step 3. After creating the full backup on the source server computer, now you need to copy the created backup file to another computer.

Step 4. Open SQL Server Management on the destination computer, right-click the SQL Server instance and select Restore Database...

how to transfer database from one server to another using backup and restore step3

Step 5. Here select Device, and you'll choose the created backup files on the source location and restore it to the destination location on the new computer.

how to transfer database from one server to another using backup and restore step4

Method 4. How to Copy Database in SQL Server Using Import and Export Wizard

Method 4 and method 5 are also built in the Microsoft SQL Server Management Studio.  

Step 1. Open Microsoft SQL Server Management Studio, right-click the database and choose tasks.

export database

Step 2. Click the small triangle symbol. Choose Data source, Server name, and Database.

import and export wizard 1

Step 3. Next, choose a destination. Specify where to copy data to.

Step 4. Select source tables and views. And choose Next.

Once it completed, check your exported files.

Method 5. How to Copy File from One Server to Another Using Generate Scripts

Step 1. Open Microsoft SQL Server Management Studio.

Step 2. Right-click the database > tasks > Generate Scripts >Next

generate scripts 1

Step 3. Move to the Choose Objects and select specific database objects.

generate scriptes 2

Step 4. Under the Set Scripting Options, choose output type and select Advanced. Choose Save to new query window.

Step 5. In the Advanced Scripting Options, choose Schema and Data from the drop-down list and click OK.

Which Way Do You Prefer to Transfer Database from One Server to Another?

This article mainly discusses how to transfer database from one server to another or how to transfer Microsoft SQL database from one computer to another computer in five effective ways, including using the EaseUS server migration software, the Copy Database Wizard, and the backup and restore method, the Import and Export method, and the Generate Scripts.

By contrast, the first method of using EaseUS Todo Backup is the most straightforward and smartest, with the least chance of making mistakes during the course of the database transfer. No matter you're familiar with the server database copy wizard, or the backup and restore method or not, it's applicable to everyone with different technical levels.

About the Author

Updated by Cici

Cici is the junior editor of the writing team of EaseUS. She accepted the systematic training on computers at EaseUS for over one year. Now, she wrote a lot of professional articles to help people resolve the issues of hard drive corruption, computer boot errors, and disk partition problems.

Read full bio

Written by Jean

Jean is recognized as one of the most professional writers in EaseUS. She has kept improving her writing skills over the past 10 years and helped millions of her readers solve their tech problems on PC, Mac, and iOS devices.

Read full bio

Reviews and Awards

Product Reviews

TrustScore 4.7 | 34 reviews
  • EaseUS Todo PCTrans Free is a useful and and reliable software solution created to serve in computer migration operations, be it from one machine to another or from an earlier version of your OS to a newer one.

    Read More
  • EaseUS Todo PCTrans is by the folks at EaseUS who make incredible tools that let you manage your backups and recover your dead hard disks. While it is not an official tool, EaseUS has a reputation for being very good with their software and code.

    Read More
  • It offers the ability to move your entire user account from your old computer, meaning everything is quickly migrated. You still get to keep your Windows installation (and the relevant drivers for your new PC), but you also get all your apps, settings, preferences, images, documents and other important data.

    Read More

How to Transfer Database from One Server to Another (5 Ways)

Try smart Windows 11 data transfer tool to move all data in 1 click.

EaseUS Todo PCTrans

  Free Download

100% Secure