Description

This lesson instructs how to set up two databases that will be used in the following lessons to perform an actual database migration using synthetic data replacement.


Overview

Two fully simulate following the steps to complete a database migration with synthetic data replacement, two databases will need to be created, each having the same user table as defined below.


The Source and Destination Databases

For our example, we will use the MySQL database platform with the INNODB database engine. Within the MySQL database, you will need to create the following source and destination databases:

  • source database: alpha
  • destination database: beta

Within the source and destination databases, create the following table:


CREATE TABLE
    USER
    (
        id INT(10) NOT NULL AUTO_INCREMENT,
        external_id VARCHAR(50) NOT NULL,
        first_name VARCHAR(25) NOT NULL,
        last_name VARCHAR(25) NOT NULL,
        middle_initial CHAR(1),
        username VARCHAR(100) NOT NULL,
        ssn VARCHAR(15) NOT NULL,
        password VARCHAR(255) NOT NULL,
        activation_date DATE,
        PRIMARY KEY (id),
        CONSTRAINT external_id UNIQUE (external_id)
    )
    ENGINE=InnoDB DEFAULT CHARSET=latin1;



Move onto the next lesson >