0

I need to migrate my data from postgreSQL (Azure ) to planetscale which is Mysql based , i have set up my planet scale , along side the schemas .

What should i be be doing next ?

Suksham
  • 36
  • 5

1 Answers1

0

As per this planet scale is only compatible with the MY SQL.

enter image description here

AFAIK we can't migrate database from PostegreSQL to MY SQL server directly. So by using third party tools like data factory copy all data from PostegreSQL to Azure Database for MySQL. You can check this for reference.

After copying data collect below details of Azure Database for MySQL.

  • Server name
  • Server admin login name
  • Server admin password
  • Database name

enter image description here

Configure the fire wall rules according to the requirements

enter image description here

Configure Server settings:

enter image description here

In PlanetScale dashboard, click on "New database", and then select "Import database". Fill the form using the collected information. Also make sure the "SSL Verification" field is set to "Verify certificate and hostname". Click "Connect to database" and the import tool will attempt to connect to your Azure MySQL instance.

enter image description here

If it connected successfully the import will start and will complete successfully. For more information you can refer this.

Bhavani
  • 1,725
  • 1
  • 3
  • 6