SqlDBM Release Update – December 22, 2019

Alter Script for Snowflake and MS SQL Server

At SqlDBM, one of our core beliefs that we really strive to infuse into everything we do, is to truly listen to our users’ requests and feedback. A significant percentage of our users expressed that they would want the ability to have Alter Script functionality for Snowflake and MS SQL Server  in SqlDBM. We listened and actualized that.

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

Generate Alter SQL Script 

SqlDBM provides the Alter Script functionality that helps incorporate the changes to the already existing Database/Data Warehouse design to fully complete development lifecycle. This is vital to ensure that your project can be easily kept up-to-date with your ever-evolving data model.

  • Generate Alter Script to modify objects in existing DB/DW
  • Select between SqlDBM revisions to apply Alter Script

NOTE: At this stage “Generate Alter Script” is only available for MS SqlServer and Snowflake. Soon we are going to add support for this feature for MySql, PostgreSQL and Redshift.

Following are screenshots on how  “Generate Alter SQL” feature can be used and how the output looks like:

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.