we’re evaluating CockroachDB for our business, currently we have a Postgres 12.x little cluster (just master and slave with replication).
In the documentation is suggested that the primary key should be a UUID field, to avoid monotonic increasing values.
Problem is, our currently db use the “serial primary key” (integer) data types for every primary key in every table.
So if we would migrate it to CockroachDB we would trasform it to UUIDs ? (of course searching and modifying all and every primary key values and foreign key references in every table ! A huge and not so easy work !)
Is there some tool that we could use to migrate ?
A. de Manzano