Migrate From Relational Database

Migrate From Relational Database

Starting from 3.0, you can easily migrate your relational database into TigerGraph database without having to write a single line of code!

At GraphStudio home page, click the Migrate From Relational Database link to start the process.

rdnms link

Step 1. Choose relational database type

Currently we support PostgreSQL and MySQL. We will support more RDBMS types in the future.

step 1

Step 2. Input connection information

Provide the credentials to connect to your relational database. You need to specify which database you want to migrate from in this step.

step 2

Step 3. Choose tables/attributes to be migrated

GraphStudio will connect to your relational database and retrieve all the table schemes of the database. You can choose which tables and which attributes of each table you want to migrate. By default everything will be migrated.

step 3

Step 4. Configurations

You can set the migrated graph’s name (by default it will be your RDBMS type concatenated with the database name). You can choose to create index for the attributes if an index exists in the relational database. You can also choose to only migrate the top several records of each table (by default the whole dataset will be migrated).

The foreign keys will be treated as edge types. This is the fixed migration rule we are using. In the future we will provide more migration rules for you to choose.

step 4

Step 5. Start migration

The migration will take a few minutes. After migration finished, a new subgraph will be created.

The data from RDBMS will be imported to the server’s filesystem before being loaded into TigerGraph database. Please make sure that the server has enough disk space!

step 5 migrating

Verify Migration Result

After migration, a popup message will guide you to go to Design Schema page to verify the graph schema.

migration verify

You can take a look of the auto-generated schema and make appropriate modifications.

rdbms schema

Then go to Map Data To Graph page and check the auto-generated data mapping.

rdbms data mapping

Then go to Load Data page and load the data into the graph.

rdbms data loading

Well done, you can play with your data and work on your business logic! Here is an example of playing with the data in Explore Graph page.

rdbms graph exploration