2.2.0 Data Migration - Gs1TestTeam/MongoDB_Task GitHub Wiki

2.2.0 Data Migration

There are several ways we can Migrate data from source RDBMS to MongoDB:

• Export all the data in JSON file format and Import them in already created Collection on MongoDB.
• Use SQL server tool SSIS and ZappySys tools to Migrate data.

SSIS and ZappySys have been show to work for migrating data from both SQL Server and MySQL to MongoDB. More information can be found in ETL Tool section

Data Migration using SSIS

We can use SSIS to migrate data from RDBMS to MongoDB.

Steps to follow for Migration:

Prerequisite: Must have Visual Studio 2017 installed.

• Download and Install SQL Server 2014

• Download and Install CData SSIS Component

• Download and Install SSDT

• Alternatively, we can also download & install ZappySys's SSIS PowerPack and download individual MongoDB Components.

Creating an SSIS Project

• Open Visual Studio.
• Click on File > New > Project
• Select Business Intelligence > Integration Services from the left Pane.

• Drag and drop a Data Flow Task from the menu to create a Data Flow in which the migration process will be defined.

Connecting to MongoDB as a destination

In the Data Flow task, drag and drop a ZS MongoDB Destination component from the SSIS Toolbox.

• Editing ZS(Zappy's Sys) MongoDB Destination.
  • Add a "New Connection" for MongoDB.
  • Edit the Connction property Accordingly.
  • Edit Connection properties. Select newly created MongoDb Connection from drop down.
  • Edit Component properties and add the Mongo Table in which we want to Import the data.
  • Lastly, match/map the Source and Destination Columns.