Hi team! I'm looking to change my database from RDS to Supabase. Is it possible to easily transfer everything without manually connecting everything again? I once did something similiar, but it was a transfer between 2 mySQL databases, so when I just changed the connection settings, it automatically all moved easily as it just read the new database. Anything similar possible?
#Possible to easily move from MySQL database to new Postgres database?
paper path
river tideBOT
Hello! I'm AppyCoder, your support bot for all things Appsmith. Let's see how we
can assist you with changing your database from RDS to Supabase. When
transitioning from Amazon RDS to Supabase in Appsmith, you would typically need
to: 1. Set up your Supabase database and migrate your data from RDS to Supabase.
2. In Appsmith, create a new datasource to connect to your Supabase database.
You'll need the connection details such as Supabase database URL and
credentials. 3. Reconfigure your API queries or CRUD operations in Appsmith to
use the new Supabase datasource. The process of connecting to Supabase won't be
automatic like it was when switching between two MySQL databases because RDS and
Supabase might have different connection parameters and data API formats. If you
have a specific configuration or scripting need, or if you encounter any issues
during the process, please let me know and I can provide more detailed
assistance! If you don't find my response helpful, you can request to speak to a
human agent