I have a database in MySQL and I have been asked to use postgreSQL now the question as the step? It is 12 tables and 250 records, the documentation that I find is old, I do not know if there will be new methods.
I have a database in MySQL and I have been asked to use postgreSQL now the question as the step? It is 12 tables and 250 records, the documentation that I find is old, I do not know if there will be new methods.
The database you have is small, I would recommend migrating it by hand, that is, recreating the posgress schemes one by one, for that you can use mysqldump, and pg_restore.
On the data, you can import the data from mysql to an XML or CSV file for it you can use mysqlworkbench as a mysql client.
already in postgress you can use pgadmin to import the data directly into the created tables.