SqlDBM Release Update – June 6, 2019

Amazon Redshift Support |  PostgreSql: Column Default |  Fixed Bugs

The SqlDBM team is proud to announce the release of SqlDBM v.2.9 based on our roadmap/feedback.

In this release, our top features include:

Support for Redshift is Finally Here!

With that, SqlDBM is very proud to present a fantastic enhancement to the tool – Redshift Support! With this feature you can improve your productivity as you develop and model your Redshift Data Warehouse. And of course, you can take advantage of and adapt SqlDBM features into your Redshift projects such as Subject Areas, Relationships, Diagrams, View Modes, Revision history , Team Collaboration etc. For details check this article.

Support for access to “Backup” table option and “Compression Encoding” Column option 

  • User has the ability to turn on or off table backup, which allows whether the table should be included in automated and manual cluster snapshots.
  • Also, user can set Compression Encoding to specify the type of compression that is applied to a column of data values as rows are added to a table.

Generate Redshift DDLs / Forward Engineer support

User can design Resdhift DW and easily materialize their beautiful designs into valuable SQL script


Feature to add Default Constraint value for column in PostgreSQL:

Now SqlDBM supports feature to Add Default Value for Column in PostgreSQL


Fixed following tickets reported on Support Forum


This isn’t all we’ve done, we’ve also made a few minor tweaks to improve the overall experience with SqlDBM.

Please check out SqlDBM at https://sqldbm.com, let us know how we can improve SqlDBM to resolve your current issues related to database designing/modeling. Help us get the next update to SqlDBM in the best possible shape. Your feedback is important to securing a solid update release, and we greatly appreciate your assistance.