7

I'm currently using SymmetricDS 3.8.27. I have a comma separated file that includes data for a database table. Is it possible to replicate that data from the CSV file into a MySql database table using SymmetricDS? If so, what are the steps I need to take to do this?

Klementina Stojanovska Chirico
  • 73
  • 3

1 Answers1

6

You can use dbimport included in the bin folder to import a csv file.

dbimport --format=csv --table=mytable myfile.csv

The first line in the file is used to read the column names.

J.Wilmer
  • 76
  • 2