Skip to content
This repository was archived by the owner on Oct 25, 2022. It is now read-only.

README.md

Latest commit

 

History

History
40 lines (26 loc) · 1.31 KB

README.md

File metadata and controls

40 lines (26 loc) · 1.31 KB

MySQL to KwilDB data migration tool

A Node.js script to migrate MySQL data to KwilDB.

Migrate existing MySQL data into KwilDB

Open terminal/command prompt and follow any of the following methods.

Before you continue, ensure that you have Node.js installed on your system. See here for more instructions. If you have it installed, you can continue below.

  1. Clone project

    git clone https://github.com/Mohd-Taqiuddin/MYSQL-to-Kwil-migration.git

  2. Change working directory

    cd mysql-kwil-etl

  3. Install dependencies

    npm install

  4. Copy private key from KwilDB and paste it in privateKey.json
  5. Copy your secret from KwilDb and paste it in lib/migrate.js (line 13) and also in src/lib/migrate.ts (if previous doesn't work)
  6. Make it happen 😉

    npm run migrate

You will be prompted to enter authentication credentials for your MySQL database. Ensure that you have access credentials that have read/write roles enabled, or else you will encounter errors.

You should be ready to migrate your data now.

Roadmap

  • Retrieve MySQL database models and data
  • Generate Kwil schemas in Typescript
  • Dump MySQL data to KwilDB
  • Support migrations over the network
  • Prevent duplicates in subsequent migrations