This article describes how to create a Migration Configuration on the GenRocket web platform.
The GenRocket web platform allows you to fully manage the configuring the migration of a table from a source database to a table in a destination database with synthetic data replacement. The steps below define the initial steps of creating a migration configuration.
Initial Steps to Create a Migration Configuration
Create a new GenRocket project called, UserReplacementDemo.
On the bottom set of tabs, click the Migration Management tab, then click the New Migration Config button.
On the New Migration Config dialog, feel in the parameters as defined in the image below. Once all of the parameters have been filled in, click the Save button.
- Source DB Name: Defines the name of the source database from which you want to migrate data.
- Source JDBC File: Defines the resource that will have the path to Source JDBC configuration file. This Configuration file will have the connection string along with username and password that will help to make the connection with Source Database.
- Destination DB Name: Defines the name of the destination database from where you want to migrate data.
- Destination JDBC File: Defines the resource that will have the path to Destination JDBC configuration file. This Configuration file will have the connection string along with username and password that will help to make the connection with Destination Database.
- Scenario Path: Defines the resource that will have the path to a directory where all scenarios required by GenRocket Migration utility will be stored.
- Dump Directory: Defines the resource that will have the path to where all the temporary dump files that get created during the Migration, will be stored. All the Dump files will be temporarily created and once Migration is complete, it will be removed automatically.
- Files Per Sub Dir: Defines how many dump files should be created per sub-directory inside Dump Directory.
- Rows Per File: Defines how many rows should be stored inside one Dump file into Sub-Directory before creating another file.
Note: If you have followed the previous articles before this one, you should have defined the four resources necessary where specified in the image below. If you do not have the four resources define, please refer to the following two articles before complete step 3: