Migration from any on-premises databases to Google Cloud PostgreSQL opens up many opportunities with low overhead and management costs.
In this article we are going to look through the necessary steps for this to synchronize and migrate data from Oracle, MySQL, MS SQL, PostgreSQL, and MS Access databases into a Google Cloud PostgreSQL instance.
Before you follow the steps below, make sure that you have a Google Cloud Platform account.
Step 1: Create A New PostgreSQL Instance On Google Cloud SQL
Log in to the Cloud Console to choose SQL in the navigation bar on the side and click the “Create instance” button.
- Next, select the PostgreSQL Server option to begin the configuration of PostgreSQL Server.
- Press "Choose PostgreSQL" .
- Configure the necessary settings for your instance. In a couple of minutes, your PostgreSQL instance will be created.
Make a note of the instance’s IP address, as you will need it later to connect from our program.
Step 2: Creating PostgreSQL database
- On the "Databases" page click the button "Create database" and type the needed database name.
Step 3: Enable Access to PostgreSQL
Once your database instance is running, the next step is to allow remote access to the PostgreSQL database server. To do this:
Go to the "Connections" page, click the instance ID you just created. Tick "Public IP", click on the button "+Add network" and add your PC IP address where DBConvert or DBSync is installed (on our example we added 126.96.36.199 ). Click "Save" to save the changes.
Go to the "Users" page to create a new user for your database. In our case, we created user dbconvert .
Note: Save this user name and password. You will need them later for connection in DBConvert/DBSync GUI.
Step 4: Connecting to Google Cloud PostgreSQL from DBConvert tools
- Public IP address that you have on page "Overview" copy and paste in filed 'Hostname' in DBConvert/DBSync GUI, in 'Username' type user that you created earlier. In 'Password' type your user name password. Press the' Test connection' button. If all your credentials are correct, the corresponding message will appear.
- Press on the button 'Refresh' to choose the database you created before on On Google Cloud SQL.
- Press button "Next" to go to the Customization stage to configure your migration process.
Read more about Google Cloud Migration And Sync software at https://dbconvert.com/google-cloud