Programmatically Migrate From Relational Database

GSQL Loading
#1

Hi TG Team,

I just found that GraphStudio allows us to migrate data from mysql and postgres. Could it be done programmatically?

Thanks

#2

Hi @luyilun32661!

Yes, it is possible! For example, MySQL and most (hopefully) all RDBMSes have a way to export data as a CSV file (and in other formats as well).

So, export the data you want to load into TigerGraph as one or more CSV files, and import into TigerGraph. Check out the TigerGraph docs on load jobs to learn how to write and run the scripts to load your data programmatically. Here is an instructional video on load jobs as well.

I hope this helps, have a great day!

2 Likes