News We Recently Launched AD Migrator and AD Reporter | News SysTools Commitment to Child Safety: Upholding the Fight Against CSAM |
News We Recently Launched AD Migrator and AD Reporter | News SysTools Commitment to Child Safety: Upholding the Fight Against CSAM |

SysTools SQL Server Migration Software Guide

Migrate Records and Schemas from All the Objects of an SQL Server to Another

STEP 1

Download & Install SysTools SQl Server Migrator Tool

Start screen

STEP 2

Next, Click on Open Button to Add SQL Server Database

login

STEP 3

Software Provide Two Mode to Browse SQL Server Database: Online & Offline

enter domains

Browse SQL Server Database

STEP 4

Next, Select Online Mode to Process Further

enter domains

STEP 5

Select Live SQL Server with Authentication

login

STEP 6

Next, Select Required SQL Server Database from Drop Down List

login

STEP 7

Click OK to Process Further

login

STEP 8

SQL Server Database Scanning Started, Click on Close to Preview

login

STEP 9

Next, View Loaded SQL Server Database Objects

login

STEP 10

Now, Preview SQL Server Database Table, View, Procedure, Rules in Details

login

STEP 11

Next, Click on Export Button to Start Migration Process

login

STEP 12

Software Provides Three Migration Option. Select the one prefered:

  • SQL Server Database
  • SQL Server Scripts
  • Azure SQL Server

login

SQL Server Migration Type

STEP 13

Next, Select Migration Type: SQL Server Database

users

STEP 14

Select Server Name with Authentication

users

STEP 15

Select Destination Database: Create New Database or Export to Existing Database

users

STEP 16

Next Select Collation Settings (if required)

users

STEP 17

Select Required SQL Server Database Objects for Migration

STEP 18

Next, Select Export Option: With only Schema or With Schema & Data

users

STEP 19

Click on Save to Process Further

users

STEP 20

Export Completed Pop-up Will Generate, Click on OK

users

STEP 21

Select Location and Click on OK to Save Report.

users

Resultant

Check Migrated Database in Live SQL Server

8

STEP 13

Select Migration Type: SQL Server Compatible SQL Scripts

users

STEP 14

Select Required SQL Server Database Objects for Migration

users

STEP 15

Next, Select Export Option: With only Schema or With Schema & Data

users

STEP 16

Click on Save to Process Further

users

STEP 17

Select Destination Folder and Click OK to Save SQL Server Database in SQL Server Scripts Format

STEP 18

Export Completed Pop-up Will Generate, Click on OK

priority

STEP 19

Now, Click on Close to Finalize Migration Process.

Resultant

Check Migrated Database in Live SQL Server

8

STEP 4

Next, Select Offline Mode to Process Further

STEP 5

Click on Browse button to Add MDF File

STEP 6

Select Required MDF File and Click on Open

STEP 7

Next Select Scan Mode: Quick Scan (For Normal File) & Advance Scan (For Corrupted File)

STEP 8

Software Auto Detect SQL Server Version or User Can Choose the SQL Server Version Manually.

STEP 9

Software Provide Option to Recover Deleted Objects when You Selected Advance Scan Mode

STEP 10

Click OK to Load MDF File

STEP 11

MDF File Loaded on the Software, Click on Close to Process Further

STEP 12

Software Prompt to Save Scanned File, Click Yes to Proceed

STEP 13

Save Scanned File in .str Format, Click OK

STEP 14

Next, View Loaded SQL Server MDF File Objects

STEP 15

Now, Preview SQL Server Database Table, View, Procedure, Rules in Details

STEP 16

Click on Export button. Software Provides Two Export Option: SQL Server Database & SQL Server Scripts

SQL Server Migration Type

STEP 17

Next, Select Migration Type: SQL Server Database

users

STEP 18

Select Server Name with Authentication

users

STEP 19

Select Destination Database: Create New Database or Export to Existing Database

users

STEP 20

Next Select Collation Settings (if required)

users

STEP 21

Select Required SQL Server Database Objects for Migration

users

STEP 22

Next, Select Export Option: With only Schema or With Schema & Data

users

STEP 23

Click on Save to Process Further

users

STEP 24

Export Completed Pop-up Will Generate, Click on OK

users

STEP 25

Now, Click on Close to Save Report. Click on Yes

users

STEP 26

Select Location and Click on OK to Save Report.

users

Resultant

Check Migrated Database in Live SQL Server

8

STEP 17

Select Migration Type: SQL Server Compatible SQL Scripts

users

STEP 18

Select Required SQL Server Database Objects for Migration

users

STEP 19

Next, Select Export Option: With only Schema or With Schema & Data

users

STEP 20

Click on Save to Process Further

users

STEP 21

Select Destination Folder and Click OK to Save SQL Server Database in SQL Server Scripts Format

users

STEP 22

Export Completed Pop-up Will Generate, Click on OK

users

STEP 23

Now, Click on Close to Finalize Migration Process.

users

Resultant

Check Migrated Database in SQL Server Script Folder

8

Get SQL Server Migrator Software Free Download Now