Data Loader Tour: Page 7 of 7 Previous
Now you are ready for conversion.
Click the Start button to start the conversion.
After conversion click the Finish Button.
As the conversion is done Data Loader will show the progress in the
Progress Bar as well it will record all the actions in a log including any
error messages and warnings. Below is the example full log file
Started loading at :26-Nov-14 6:47:05 PM
___________________________________________________
About to Drop Table :Categories
Droping referencing Foreign Key constraints
Categories Table dropped
About To Create Table Categories
Categories Table Created Successfully
About to Insert Rows in Categories Table
8 Rows Loaded
Time Elapsed :00 Hrs 00 Min 03 Sec
___________________________________________________
About To Create Table Category Sales for 1995
Category Sales for 1995 Table Created Successfully
About to Insert Rows in Category Sales for 1995 Table
Using Bulk Load Method.
8 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About To Create Table Current Product List
Current Product List Table Created Successfully
About to Insert Rows in Current Product List Table
Using Bulk Load Method.
69 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Customers
Customers Table Created Successfully
About to Insert Rows in Customers Table
Using Bulk Load Method.
91 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Employees
Employees Table Created Successfully
About to Insert Rows in Employees Table
9 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About to Drop Table :Invoices
Invoices Table dropped
About To Create Table Invoices
Invoices Table Created Successfully
About to Insert Rows in Invoices Table
Using Bulk Load Method.
2152 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About to Drop Table :Order Details
Order Details Table dropped
About To Create Table Order Details
Order Details Table Created Successfully
About to Insert Rows in Order Details Table
Using Bulk Load Method.
2152 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About To Create Table Order Details Extended
Order Details Extended Table Created Successfully
About to Insert Rows in Order Details Extended Table
Using Bulk Load Method.
2152 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Order Subtotals
Order Subtotals Table Created Successfully
About to Insert Rows in Order Subtotals Table
Using Bulk Load Method.
828 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About to Drop Table :Orders
Orders Table dropped
About To Create Table Orders
Orders Table Created Successfully
About to Insert Rows in Orders Table
Using Bulk Load Method.
828 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About To Create Table Product Sales for 1995
Product Sales for 1995 Table Created Successfully
About to Insert Rows in Product Sales for 1995 Table
Using Bulk Load Method.
77 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About to Drop Table :Products
Products Table dropped
About To Create Table Products
Products Table Created Successfully
About to Insert Rows in Products Table
Using Bulk Load Method.
77 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Products Above Average Price
Products Above Average Price Table Created Successfully
About to Insert Rows in Products Above Average Price Table
Using Bulk Load Method.
25 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About To Create Table Quarterly Orders
Quarterly Orders Table Created Successfully
About to Insert Rows in Quarterly Orders Table
Using Bulk Load Method.
84 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Sales by Category
Sales by Category Table Created Successfully
About to Insert Rows in Sales by Category Table
Using Bulk Load Method.
77 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About to Drop Table :Shippers
Shippers Table dropped
About To Create Table Shippers
Shippers Table Created Successfully
About to Insert Rows in Shippers Table
Using Bulk Load Method.
3 Rows Loaded
Time Elapsed :00 Hrs 00 Min 01 Sec
___________________________________________________
About To Create Table Suppliers
Suppliers Table Created Successfully
About to Insert Rows in Suppliers Table
Using Bulk Load Method.
29 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
About To Create Table Ten Most Expensive Products
Ten Most Expensive Products Table Created Successfully
About to Insert Rows in Ten Most Expensive Products Table
Using Bulk Load Method.
10 Rows Loaded
Time Elapsed :00 Hrs 00 Min 00 Sec
___________________________________________________
___________________________________________________
Importing Primary Key Constraint for table Categories
Importing Primary Key Constraint for table Customers
Importing Primary Key Constraint for table Employees
Importing Primary Key Constraint for table Order Details
Importing Primary Key Constraint for table Orders
Importing Primary Key Constraint for table Products
Importing Primary Key Constraint for table Shippers
Importing Primary Key Constraint for table Suppliers
Importing Unique Constraint for table Categories
Importing Unique Constraint for table Customers
Importing Unique Constraint for table Employees
Importing Unique Constraint for table Order Details
Importing Unique Constraint for table Orders
Importing Unique Constraint for table Products
Importing Unique Constraint for table Suppliers
Importing Foreign Key Constraint for table Order Details
Importing Foreign Key Constraint for table Orders
Importing Foreign Key Constraint for table Products
End Time is :26-Nov-14 6:47:19 PM
Total Time Elapsed for Session:00 Hrs 00 Min 14 Sec
*******( F.I.N.I.S.H )*********
The conversion log is saved and you can view it anytime by
choosing Manage Existing Sessions option in Data Loader Start Screen.
To view the just converted data you can click the Browse DB
button to browse the target database from Data Loader itself.
In this tour we have just covered the basic conversion from one database
to another database. Data Loader is capable of doing conversion with many
advance features like UPSERT and INSERT and Folder Polling and it can also
create SQL dumps for MySQL, MS SQL Server and Oracle from any data source.
SQL dumps are useful where you don't have direct access to the database.
That's it thanks for viewing.
Previous
