Friday, 1 October 2021

change Data base mysql to pg

 1. Create same database(database_name-thera_dev) both rails application in mysql and pg

2. Import sql file in mysql rails application.

3. then run this command for pg rails application .

"

pgloader mysql://root:root@127.0.0.1/DATABASE_NAME_SAME postgresql://root:root@127.0.0.1/DATABASE_NAME_SAME

"


4. then Export pg dupm file---this command run pg application

pg_dump -U root DATABASE_NAME_SAME > sql_file_name.sql