Description

This lesson describes how to download a migration configuration file and running the migration via the GenRocket command line utility.


Overview

The GenRocket Migration Management form takes care of packaging the migration configuration file for download to an encrypted file.  If you want to see what the contents of the migration configuration file, you can click the preview button and have a look.



If all steps were followed correctly, GenRocket will create the following migraion configuration instructions:


 

Downloading the Scenario

Make sure you remember to download the Scenario and placing it in its respective folder before downloading the migration configuration file.


Downloading the Migration Configuration File

Goto the main dashboard.  In the bottom left panel, click the Migration Management tab, then click the download icon for your management configuration.  Name the configuration file, UserMigration; it will download to an encrypted file named, UserMigration.gredb, 



Running the Migration

From the command line, run the following GenRocket command:

  • genrocket -dbm UserMigration.gredb


Below is example output of a migration of the User table with synthetic data replacement of 50,000 rows from the source user table to the destination user table.


imac:@htaylor:~/Downloads: genrocket -dbm UserMigration.gredb 

GenRocket Runtime Version: 3.5.11
GenRocket Version: 3.5.11.1
GenRocket Engine Version: 3.5.11.4
GenRocket Generator Runtime Version: 3.5.11.3
GenRocket Receiver Runtime Version: 3.5.11.0

Initializing the State of UserScenario, version number: 1
Preparing Statement: insert into beta.user(activation_date,external_id,middle_initial,id,first_name,last_name,username,ssn,password) values (?,?,?,?,?,?,?,?,?)

Reading Dump File dump1.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump2.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump3.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump4.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump5.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump6.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump7.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump8.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump9.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump10.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump11.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump12.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump13.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump14.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump15.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump16.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump17.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump18.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump19.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump20.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump21.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump22.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump23.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump24.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump25.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump26.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump27.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump28.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump29.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump30.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump31.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump32.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump33.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump34.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump35.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump36.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump37.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump38.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump39.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump40.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump41.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump42.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump43.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump44.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump45.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump46.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump47.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump48.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump49.csv from directory /Users/htaylor/Downloads/USER1
Initializing the State of UserScenario, version number: 1
Reading Dump File dump50.csv from directory /Users/htaylor/Downloads/USER1
Deleted the scenario state for Scenario ID 2566. 12 rows affected.
All Done! Time Elapsed: 0m:18s
imac:@htaylor:~/Downloads: