SingleStore Migration Tools

MySQL-compatible real-time analytics migration and synchronization

Move data to and from SingleStore with DBConvert and DBSync tools for distributed SQL, in-memory performance, and real-time analytics workloads.

MySQL
Wire protocol compatibility
Real-time
Analytics on live data
Scale-out
Distributed in-memory platform

Migrating into SingleStore

SingleStore (formerly MemSQL) is a distributed SQL database that speaks the MySQL wire protocol. DBConvert connects to it as a MySQL target, so moving data into SingleStore works the same way as a migration into MySQL.

Point a supported source at your SingleStore endpoint and DBConvert maps the data types, creates the tables, and transfers the rows.

Plan for this up front: SingleStore does not enforce foreign keys. DBConvert transfers tables and data, but referential integrity moves to your application.

Download the converter for your source

Each tool connects to SingleStore as a MySQL target. Pick where your data is coming from.

MySQL

MySQL / MariaDB to SingleStore

Same wire protocol - DBConvert Studio handles the transfer into SingleStore.

Download DBConvert
Details

FoxPro/dBase and other MySQL-family sources work too - see all MySQL-family tools.

What to plan for

SingleStore is MySQL-compatible on the wire, but its storage model differs. Account for these before the run:

No foreign keys

SingleStore does not support foreign key constraints. DBConvert transfers tables and rows; enforce referential integrity in the application layer.

Shard and columnstore keys

Data distribution and columnstore are SingleStore's own design. DBConvert creates standard tables - set shard and sort keys in SingleStore afterwards for performance.

First load compiles

SingleStore generates code the first time a schema loads, so the initial run is slower than MySQL. It speeds up once tables are compiled.

Connection

Connect with a standard MySQL connection string to the SingleStore endpoint - host, port, user, and SSL from your SingleStore deployment.

DBConvert Streams

Need log-based, real-time replication?

DBConvert Streams is a separate product for continuous, log-based change data capture. The DBConvert and DBSync tools on this page cover migration, scheduled sync, and trigger-based sync.

See Streams

Ready to migrate into SingleStore?

Download the converter for your source above and run the first job on a free trial.