Your feedback to us
VSTS / Github support
I would like to store the model in a VSTS / Github Repository to control versioning. Ideally, you would provide a web API or a set of PowerShell cmdlets to interact with the projects to enable DevOps / CI CD
We are glad you created this "Idea" tickets. We will discuss it with our team and work on it, in case there are lot of user votes for this.
Thank you for your assistance,
SqlDBM Team
Table highlighting
It would be nice to have a table in diagram highlighted when its table name is selected in the diagram explorer. It can be hard to find a table otherwise.
Now you can easily locate objects on diagram. The object you clicked on in the Database Explorer or the Database Explorer is highlighted and the diagram view will be refocused to point that object.
https://support.sqldbm.com/knowledge-bases/5/articles/3767-locate-on-diagram
Drop DB and Tables Should have an `IF EXISTS` Option
When generating the SQL for a database there is an option to add DROP statements for TABLES and the schema, however if these don't have an IF EXISTS in the SQL statement, they won't work on the first run. It would be nice to have a check box for this to reduce manual editing.
Hi, the new version with Forward Engineer improvements has been rolled
Thank you for your assistance,
SqlDBM Team
Ability to directly connect to Snowflake and choose the DB, Schema, and tables to pull into the model
The only way currently to ingest Snowflake tables is to copy the DDL out of Snowflake and reverse engineer the text.
For an enterprise tool, I would like to see the ability for us to setup a connection to a Snowflake instance in SqlDBM and then be presented with which DB, Schema, and tables we would like to ingest into the model.
Essentially the groundwork has been done (DDL Reverse Engineering) and all you would need is to run infoschema queries against Snowflake to supply the choices and then from there you can form the GET_DDL statements using the data from the infoschema directly instead of making the user do this for SqlDBM.
This elevates the value of SqlDBM exponentially, reduces the work the user needs to perform, and better facilitates keeping the model in sync with the physical tables.
Text Entry Option in UI
It would be extremely useful to add the ability to mass enter columns and other detail for a table in a tab-delimited text method like the one used in Matillion(Screenshots below). This would reduce the number of clicks to create a table and increase the interoperability between ELT tool software.
Matillion
Text Mode: Able to paste in tab-delimited text into a window in order to populate fields.
Snowflake Reverse Engineering
8/24/2019
Released new version of SqlDBM with support of Snowflake Reverse Engineering.
Enjoy Data Modelling :-)
Thank you for you support and patience.
Export to XML, JSON or another text based format in order to integrate with git
Our business does not allow us to use binary files in our git repositories based on past misuse and mistakes.
I love this software, especially the representation of the tables and the dark color scheme, but we won't be able to buy into it unless we can import a sql script, organize it/add notes in the app, and then export diagram to a text based format that can be included in our git repositories alongside the database.
tablet / touch screen mobile device support
I've recently attempted using an iPad to work with sqlDBM and found that, for the most part, it works ... sort of. The biggest issue is that it does not seem possible to pan within the drawing. I also have only worked with relatively small database designs and have not had to deal with many tables. This has allowed me to zoom to extents and just use device zooming to see what I was doing. Although this leads to a bunch of scrolling around on the device viewport to get to the menus and properties entry areas, it is still technically "usable".
If you could come up with either a native app or a mobile friendly web interface, that would be a great improvement.
multiple snowflake database
In a large work environment, each snowflake user will have multiple database, either owned by the user or shared by other users. Currently multiple snowflake database is not supported and thus limit the capability of visualizing cross-database references.
Customer support service by UserEcho