CockroachDB

CockroachDB

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

CockroachDB supports the PostgreSQL wire protocol, so we use our well-tested native PostgreSQL client driver to work with it.


Omni Loader is especially well suited to ingest data to CockroachDB in a massively parallel way, as it can export compressed CSV data, automatically partitioned.

Full Convert Pro Full Convert Ultimate Omni Loader

We support CockroachDB directly. No additional drivers are required.

CockroachDB data types we support

Integral

bigint (int8), int (integer, int4), smallint (int2)

Decimal

decimal (dec, numeric, fixed), double precision (double, float8), float, money, real (float4)

Text

char (bpchar, character), text (string), varchar (character varying)

Binary

bit

Date/Time

date, time (timetz, time without time zone), timestamp (timestamp without time zone, timestamp(2) without time zone), timestamptz (timestamp with time zone, timestamp(2) with time zone)

Large objects

bytes (bytea, blob), text (string)

Other

array, boolean (bool), enum, inet, interval, jsonb (json), uuid, varbit (bit varying)

Export your CockroachDB database

It may make sense to migrate your data away from CockroachDB. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current CockroachDB database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Export CockroachDB to:

Import data into your CockroachDB database

If you want to import data on a regular basis and do not want to recreate the whole target database from scratch every time, but rather do tiny targeted sync of only changes since the last run, use Full Convert Pro or Ultimate.

Take a look at the quick tutorials below to see how it's done using Full Convert.

Import data into CockroachDB from: