Migrating from traditional databases

In this section, we will outline a few generic steps that are involved in migrating data between any two databases. After that, we will go over a specific example of migrating data from PostgreSQL into CockroachDB.

Migrating from other databases into CockroachDB usually involves the following generic steps:

1. Export the schema from the source database.
2. Export the data from the source database.
3. Transform the data into a desirable format. In most cases, comma-separated values (CSV) should work just fine.
4. Compress and transfer the schema and the data to the desired location where it can be imported into CockroachDB.
5. Do the data type mapping in the schema from the source to the CockroachDB database.
6. Import the schema, along with the data, into CockroachDB.
7. Manually create users and privileges.
8. All the application teams also have to map current queries from the source database to CockroachDB.

Now, let&apos...