Your feedback to us

+24
Accepted

VSTS / Github support

Jason Horner 6 years ago updated by hannah gryska 2 years ago 8

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

Answer
anonymous 6 years ago

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

+24
Completed

Table highlighting

lesya 6 years ago updated by anonymous 4 years ago 7 2 duplicates

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.

Answer
anonymous 4 years ago

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

+22
Completed

Drop DB and Tables Should have an `IF EXISTS` Option

m snoddy 6 years ago updated by anonymous 5 years ago 11 2 duplicates

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.

Answer
anonymous 5 years ago

Hi, the new version with Forward Engineer improvements has been rolled

Thank you for your assistance,

SqlDBM Team

+21
Accepted

Ability to directly connect to Snowflake and choose the DB, Schema, and tables to pull into the model

chris soule 4 years ago updated by Support 4 years ago 1

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.

+21
Under review

Text Entry Option in UI

chris soule 4 years ago updated by Support 4 years ago 1

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. 


Image 917

Matillion

Image 918


Text Mode: Able to paste in tab-delimited text into a window in order to populate fields.

Image 919

+21
Completed

Snowflake Reverse Engineering

anonymous 5 years ago updated by Support 5 years ago 5

8/24/2019

Released new version of SqlDBM with support of Snowflake Reverse Engineering.

Enjoy Data Modelling :-)

Thank you for you support and patience.

+21
Accepted

Desktop version

lesya 6 years ago updated by arthur mills 3 years ago 5

It would be great to see a desktop version for offline designing

+20
Accepted

Export to XML, JSON or another text based format in order to integrate with git

zachjallen 6 years ago updated by danny tishenko 4 years ago 4

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.

+20
Accepted

tablet / touch screen mobile device support

scott dragoo 6 years ago updated by anonymous 6 years ago 2

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.

+19
Accepted

multiple snowflake database

fyin 4 years ago updated by Support 4 years ago 4

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.