# dbForge Schema Compare for Redshift/PostgreSQL Reviews **Vendor:** Devart **Category:** [Database Comparison Software](https://www.g2.com/categories/database-comparison) **Average Rating:** 4.5/5.0 **Total Reviews:** 3 ## About dbForge Schema Compare for Redshift/PostgreSQL dbForge Schema Compare is a tool for easy and effective comparison and synchronization of Amazon Redshift and PostgreSQL database structure differences. It helps compare database schemas, gives comprehensive information on all differences, and generates clear and accurate SQL synchronization scripts to deploy database changes. ## dbForge Schema Compare for Redshift/PostgreSQL Reviews ### 1. Great tool to compare enterprise level Redshift data warehouses !!! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** December 26, 2022 **What do you like best about dbForge Schema Compare for Redshift/PostgreSQL?** I use this tool to compare the production and non-production instances of our enterprise data warehouse on AWS Redshift which has 30+ TBs of data spread throughout 1000+ tables. dbForge can seamlessly connect to both of our Redshift instances and maintain that connection continuously. The way it filters out identical and different tables/views is very helpful and easy to identify. Side by side view of both DDLs is great to capture the differences fast. SQL query editor is awesome that it can give suggestions better than most of the well-known DB Clients out there (It creates the catalog out of 1000+ tables/views in many different schemas pretty fast and intelligent enough to give suggestions across aliases as well). UI is also fairly intuitive and user-friendly. Dark skin is also really good and naming the skins is clever in relation to the mostly used MS Office and Visual Studio (Office Black, Visual Studio Dark, etc) so that the user can expect the same color theme as his/hers mostly used software (This is the first time I'm seeing a naming like this !). **What do you dislike about dbForge Schema Compare for Redshift/PostgreSQL?** dbForge tool is really good, so I'd probably be nitpicking here. The first time I tried to create a new DB connection, I thought it should be there under "File" -> "New", but it was not since they have a separate menu as "Database". So I still think "New Connection" should go under "File" -> "New" for it to be more intuitive to a first-time user. I use the "Object Filter" side pane menu all the time to filter what I want to see from tables, views, schemas, etc, but it is not resizable so it has a lot of space unused because it only takes a little to show the names "Functions", "Tables", "Views", "Schemas" etc. When viewing the data results of a table with many columns, it's hard to find one column so it will be easier if the tool has a column search. **What problems is dbForge Schema Compare for Redshift/PostgreSQL solving and how is that benefiting you?** We have not yet set up a CI/CD mechanism to migrate the tables and views from our non-production database to the production Redshift database. So it's essential for us to see the differences between the DDLs in non-prod and prod to do a proper production deployment. Checking the differences is also useful to identify the new modifications to be done in the non-production environment related to the new features/data additions to the warehouse. ### 2. Best Data Comparer for the Postgres **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 18, 2022 **What do you like best about dbForge Schema Compare for Redshift/PostgreSQL?** DBForge has the option to compare the data in both Postgres and Redshift. We are performing the data migration and upgradation. We will be using this comparer tool to compare the data. **What do you dislike about dbForge Schema Compare for Redshift/PostgreSQL?** Other than the data Comparison, if it also has the other objects comparison, it will be good. Stored Procedures also needs this type of comparison using this tool **What problems is dbForge Schema Compare for Redshift/PostgreSQL solving and how is that benefiting you?** Time-Saving tool to compare the data between two homogenous databases. It is especially getting used in migration and upgradation activities. This will benefit the Business to deliver the projects within the deadlines. ### 3. Very easy to use at a great price **Rating:** 4.5/5.0 stars **Reviewed by:** Peter M. F. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 31, 2023 **What do you like best about dbForge Schema Compare for Redshift/PostgreSQL?** It's very easy to use and is priced right! **What do you dislike about dbForge Schema Compare for Redshift/PostgreSQL?** From what I know about the tool, there is not much to dislike **What problems is dbForge Schema Compare for Redshift/PostgreSQL solving and how is that benefiting you?** The problems schema compare resolved was to identify the differences between our development, test and production environments - [View dbForge Schema Compare for Redshift/PostgreSQL pricing details and edition comparison](https://www.g2.com/products/dbforge-schema-compare-for-redshift-postgresql/reviews?page=1§ion=pricing&secure%5Bexpires_at%5D=2026-06-01+02%3A10%3A34+-0500&secure%5Bsession_id%5D=26e1bb05-2eaa-4042-8dea-9c9fc9b78029&secure%5Btoken%5D=5b21d25f658a763460ada4e0d5c902034f98b510ded6b8b5bfbf5297d211d0cc&format=llm_user) ## dbForge Schema Compare for Redshift/PostgreSQL Features **Functionality** - Schema Comparison - Database Export **Management** - Database Synchronization - Reporting - Selective Synchronization ## Top dbForge Schema Compare for Redshift/PostgreSQL Alternatives - [Studio 3T](https://www.g2.com/products/studio-3t/reviews) - 4.5/5.0 (190 reviews) - [Beyond Compare](https://www.g2.com/products/beyond-compare/reviews) - 4.6/5.0 (150 reviews) - [Liquibase](https://www.g2.com/products/liquibase/reviews) - 4.5/5.0 (28 reviews)