Hello All,
We are migrating our db from Mysql to Postgre.
Postgre uses some different datatypes as compared to mysql (eg. boolean)
Has anyone worked on the migration of the whole db to postgre, if yes can you please provide few steps on best way to do it? Esp the cdt(xsd) part. Database we have migrated, but we are finding hard time in updating the cdts.
Thanks in advance!!!
Discussion posts and replies are publicly visible
The steps to migrate your MySQL database to PostgreSQL using pgLoader:
Install pgLoader on your system. Create a PostgreSQL role and database.Create a dedicated user in MySQL and manage certificates.Migrate the data from MySQL to PostgreSQL using pgLoader.
suika game
It works for both my issue. Many thanks.
geometry dash subzero
How about changes in Appian cdts? Few data types are different than postgre than in mysql (e.g bigint/boolean)
Was the changes done manually in cdts for those data types?