I want to migrate my DB from mysql to postgres

[njprrogers]

Hi,

I have inherited a mature retool app with a lot of pages.

1. I'd like to migrate the app from using a Mysql DB to Postgres. The underlying tables and schema are the same for now.
2. We are using cloud based retool.
3. I have tried export to JSON, do a find and replace on the resource name and re-import but that has not worked.

Thanks in advance!

[Shawn_Optipath]

Hi @njprrogers and welcome to Retool!

I would do some testing between the 2 resources, building an app with 2 queries and test your resource swapping with that.

You will notice there is a resource name as well as a uuid which needs to change as well. You can find it in the UI as in the screenshot.

In the JSON file, you will see the uuid just before the resource name.

I just tested swapping the resource name along with tht uuid and it worked. In my JSON file you will notice the 2 resources have identical queries and after swapping them, they function correctly with the other resource.
Switch resource.json (9.2 KB)

Hopefully this helps!

[Shawn_Optipath]

Hi @Sudhakar, are you able to ask this in a separate question, include a few screenshots and send me the link. Happy to help but need a little more context.