PostgreSQL Schema Compare: Analyze and Synchronize Differences in Database Schemas | dbForge Studio

Compare and synchronize PostgreSQL database schemas with dbForge Studio for PostgreSQL.

In this tutorial, you’ll learn how to compare two PostgreSQL schemas, identify database object differences, configure schema and table mapping, and deploy schema changes from a source database to a target one.

👀 See how to:
▪︎ Select source and target PostgreSQL databases
▪︎ Configure schema comparison options
▪︎ Map schemas, tables, and columns
▪︎ Review missing, changed, and identical database objects
▪︎ Exclude unwanted differences from synchronization
▪︎ Generate and review a PostgreSQL synchronization script
▪︎ Check warnings and the deployment action plan
▪︎ Synchronize database schemas and verify the results

dbForge Studio for PostgreSQL delivers database synchronization between development, staging, and production environments. The Studio supports on-premises PostgreSQL and a number of related cloud databases and services, including Amazon Redshift, Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, and others.

The video also shows how the integrated dbForge AI Assistant can generate SQL queries using the context of the newly synchronized database.

📌 Chapters:
00:00 Introduction
00:36 Start a PostgreSQL Schema Comparison
00:50 Configure Schema Comparison Options
01:00 Map Schemas and Tables
01:24 Review Schema Comparison Results
01:59 Generate a Database Synchronization Script
02:20 Configure Synchronization Options
02:42 Review and Start Synchronization
02:51 Review and Execute the SQL Script
03:08 Verify PostgreSQL Schema Synchronization
03:20 Generate SQL queries with dbForge AI Assistant
03:47 Try dbForge Studio for PostgreSQL

✅ Learn more about PostgreSQL schema comparison and synchronization:
https://www.devart.com/dbforge/postgresql/studio/database-synchronization.html

👉 Try dbForge Studio for PostgreSQL:
https://www.devart.com/dbforge/postgresql/studio/

🚀 Learn more about dbForge AI Assistant:
https://www.devart.com/dbforge/ai-assistant/

#PostgreSQL #SchemaCompare #PostgreSQLSchema #PostgreSQLSchemaCompare #SchemaComparison #SchemaSynchronization #DatabaseSynchronization #DatabaseCompare #DatabaseSchema #SchemaDiff #PostgreSQLDiff #PostgreSQLTools #PostgreSQLDevelopment #PostgreSQLDeveloper #PostgreSQLIDE #DatabaseDevelopment #DatabaseTools #DatabaseManagement #DatabaseDeployment #SchemaDeployment #SchemaManagement #DatabaseDevOps #PostgreSQLDevOps #dbForge #dbForgeStudio #dbForgePostgreSQL #dbForgeSchemaCompare #Devart

---

Closed Caption:

Welcome to dbForge Studio for 
PostgreSQL tutorials. In this video,
we'll show you how easy it is to 
compare the schemas of two databases,
examine object differences, and deploy 
changes to a target environment.
Whether you need to examine the differences 
between development and production databases,
perform a recovery, or simply 
migrate data to a different instance,
you can do it with dbForge Studio, 
an AI-powered IDE for PostgreSQL,
Supabase, Amazon Redshift, and a variety 
of related cloud databases and services.
Your first step is to start a new 
schema comparison. The wizard will
greet you with a page divided into 
Source and Target sections. Here,
you need to specify the connections 
and databases to be compared.
On the Options page, you can configure 
your comparison further by selecting
to ignore or include certain types 
of changes. For your convenience,
the wizard provides a detailed 
description for each option.
The following page allows you to 
adjust schema mapping. If required,
you can select to compare only mapped schemas.
The next page will show you the mapped tables. You 
can inspect and adjust column mapping for each.
If there are unmapped objects, their 
number will be displayed in the bottom
right corner of the wizard. You 
can check and map them as well.
Once everything is ready, click Compare.
Now the Studio runs the comparison; afterwards,
it provides you with a document that 
contains the comparison results.
As you can see, they are 
grouped into several tabs.
You can view the objects that 
are present only in the source
You can check the objects that are 
present in both source and target,
either with differences or identical
And you can see the objects that 
are present only in the target.
You can exclude object types from the comparison 
by clearing the corresponding checkboxes.
Also, you can exclude the unwanted differences
from further synchronization by 
clearing checkboxes in the results.
Now, let's open the synchronization wizard to 
generate a script that will sync the source
to the target. On the Output page, you have three 
options depending on the deployment process you'd
like to follow. You can select to open the script 
in order to double-check it before execution,
save it to run later, or execute it 
directly against the target database.
We'll go with the first option.
The next page is dedicated to 
configuring the synchronization options.
Here, you can select to generate 
fully qualified object names,
include or exclude comments, and use a 
single transaction for the operation.
On the following page, you 
can add custom scripts to
be executed before or after the synchronization.
We don't have any, so we can proceed further.
Finally, on the Summary page, you can review the
warnings and the actions that will 
be taken during the synchronization.
Once you are ready, hit Synchronize.
Since we have selected to open the script 
before running it, here it is, in the editor.
It's accurate, concise, and easy to read,
which is essential if your colleagues 
will have to review or execute it.
By the way, before hitting Execute,
make sure you've backed up your 
target database, just in case.
And there we go!
To make sure our synchronization has 
been successful, let's refresh the
results in the comparison document 
with the corresponding button.
As you can see, now the source 
and the target are identical.
Now let's retrieve some data 
from a newly synced target table.
To do that, we can auto-generate a query 
using the context-aware AI Assistant,
which creates, explains, optimizes, and 
troubleshoots SQL code in a familiar AI chat.
It's designed to streamline SQL development 
with speed, ease of use, and context awareness.
After our query is generated, we can 
copy it to SQL Editor and run it.
Want to try it all yourself? That's easy!
Download dbForge Studio for PostgreSQL for free,
give it a go, and keep your 
databases in perfect sync.