Migrating Data between Databases using Data Pump

Migrating Data between Databases using Data Pump


In this tutorial, learn how to migrate data between databases using dbForge Data Pump. It covers exporting and importing data from CSV files, configuring settings, mapping columns, and using templates for recurring tasks.

Timestamps:

0:00 Introduction

0:44 Migrating Data Between Databases with CSV

1:28 Exporting Data to CSV File

1:47 Selecting Tables and Configuring Export Settings

2:15 Customizing Data Export Settings and Options

2:41 Saving Export Template and Completing Data Export

3:23 Importing Data using Data Pump

4:06 Configuring and Saving Import Settings

5:23 Importing Data with Command Line

👉 Check full overview of Data Pump for SQL Server here: https://www.devart.com/dbforge/sql/data-pump/

🔥 You can download Data Pump for SQL Server Trial here: https://www.devart.com/dbforge/sql/data-pump/download.html

🔔 Subscribe to our channel and get dozens of tutorials about Devart tools: https://www.youtube.com/c/DevartSoftware
Closed Caption:

[Music]
hello there and greetings from devart in
this video we will show you how to use
dbforge data pump for SQL Server to
quickly and easily fill your database
with data
dbforge data pump is a powerful add-in
for SQL Server management Studio that
lets you populate SQL Server databases
with data and migrate data between
systems the tool delivers Rich
customization options and supports 15
most popular data formats it also allows
automating data export and import using
the command line we would really
appreciate it if you like this video And
subscribe to our Channel where we
publish lots of useful information
let's get started
using the example of the sales.customers
and sales dot orders tables that reside
in the bike stores Dev database we will
demonstrate how to migrate data between
two databases bike stores DAV and bike
stores test by exporting data to the CSV
format and then importing it again to
another database
to show the functionality of data pump
to the full we will import the data of
one table via the user interface and the
other via the command line
let's first retrieve data from the
sales.customers and sales.orders tables
that are located in the bike stores Dev
and bike stores test databases as you
can see there is data in these two
tables in the bike stores Dev database
while the tables of the bike store's
test database are empty
so our first step is to export data from
the bike store's Dev database to the CSV
file for this in object Explorer
right-click the database and select data
pump export data then on the export
format page of the wizard that appears
select the desired data export format in
our case we select CSV next on the
source page of the wizard select the
tables whose data you want to export we
select the sales.customers and
sales.orders tables it's worth noting
that dbforge data pump allows exporting
any number of tables on the output
settings page enable the export data
into separated files option in the file
name field specify a path to save the
files with the exported data you can
select to save the export data either to
a single file or to separate files on
the options page of the data export
wizard you can configure the export
settings
those depend on the selected data format
on the data formats page you can select
the columns for export and check their
aliases and data types
on the exported rows page you can select
to export all rows export selected rows
only or export a specified range of rows
on the errors handling page you can
configure the Tool's error processing
Behavior if you want to save your export
settings as a template for reoccurring
tasks click save template please note
that you will need a template for
setting up data export using the command
line
on the completion page of the wizard you
can select to view the log file open the
folder containing the exported files or
continue exporting data as a result of
our export efforts we got four files
data export log contains the log of the
data export process
sales.customers contains data from the
sales.customers table in the CSV format
sales.orders contains data from the
sales.orders table in the CSV format
table export is the data export template
file
now let's use dbforge data pump to
import that data to another database in
object Explorer we right-click the bike
stores test database and select data
pump import data in the Wizard that
opens we select the CSV format and
provide a path to the sales.order CSV
file we got when we exported data from
the bike stores Dev database
the second file sales.orders will now be
imported using the command line
functionality of dbforge data pump to
demonstrate the capabilities of the tool
to the fullest on the destination page
of the wizard we select a schema and
table to import data you can import data
either to a new table or to an existing
one please note that there is no data in
the Target table
on the options page you can configure
the import options for the selected file
format on the data formats page you can
adjust data formats if necessary
on the mapping page you can map The
Source columns to the Target ones if you
were importing data into a new table the
tool will automatically create and map
all the columns you can see the results
in the preview section
if you are importing into an existing
table Only The Columns with the same
names will be mapped so you will have to
map the rest manually on the modes page
of the data import wizard you can select
an import mode we select append and move
on
on the output page you can configure how
the data will be added to the database
we select import data directly to the
database and click next
on the errors handling page we configure
the tools error processing Behavior
if you want to save your import settings
as a template for reoccurring tasks
click save template a quick reminder you
will need a template for setting up data
import from the command line
on the final page of the wizard you can
view the number of rows imported view
the log file or continue importing data
as you can see the data has been
successfully imported into the
sales.orders table while the
sales.customers table remains empty now
let us import data to the
sales.customers table from the command
line
let's open the console and navigate to
the folder where dbforge data pump is
located we enter the command where we
specify the path to the CSV file
containing the data to be imported the
name of the target sales.customers table
and the path to the template file to be
used during the import process
now let's execute the command as you can
see the import is successful and
1445 records have been imported
we would like to mention that you can
not only import data from the command
line but also export it
as you can see both tables contain data
the sales.orders and sales dot customers
tables in the bike store test database
are populated with data from the
corresponding tables of the bike store's
Dev database
in the simple way using dbforge data
pump you can quickly Import and Export
database data
want to try it download a free 30-day
trial of dbforge data pump and evaluate
all the advanced features it delivers

Video Length: 06:30
Uploaded By: Devart
Published: 3/30/2023
View Count: 1,174

Related Software Products
dbForge Data Pump for SQL Server
dbForge Data Pump for SQL Server

Published By:
Devart

Description:
dbForge Data Pump for SQL Server: Import and Export Wizards Inside SSMS, With Templates and a Command Line dbForge Data Pump for SQL Server is a $189.95-a-year add-in for SQL Server Management Studio that imports data into SQL Server from 10 formats (Excel, CSV, JSON, XML, Google Sheets, Access and more) and exports tables to 14. It's for DBAs, developers and analysts on Windows who move data in and out of SQL Server often enough that the...

Copyright © 2026, Ivertech. All rights reserved.