Your feedback to us
Generate Data Dictionary
As well as the ability generate the SQL, could there also be the option to generate a data dictionary?
Visually connect relations to correct columns
It'd be incredibly useful if the editor showed the lines starting and ending at the connecting fields in a relation.
This would help anyone eyeball the diagram to see which fields are related to other fields without having to click around the diagram.
user defined data types or domains
I would like to use user defined data types or domains
Add Support for Azure SQL DW Tables
I would like to build tables for Azure SQL DW as Far as I know no other product has support for this curently:
The key features are support for the Distribution, index and partition properties
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
Copy/Paste feature
Copy\Paste or Duplicate feature would be useful, when you have similar tables and do not want to create a new one over and over.
Possibility to copy tables from one project to another
It would be easy to replicate or use some diagrams as base to other projects
We are glad you created this "Idea" ticket. 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
Poll: Convert Project to other database type
Please tell us, If you wish to convert your project from one database type to another one and this conversion is not implemented by SqlDbm team yet.
- Please specify "FROM Database Type" and "TO Database Type" in your message here.
For Example: SqlServer to Snowflake
You suggestions and number of users who need same feature will help us to prioritize our backlog.
How do I add an FK to an existing column
I've imported an existing schema that didn't have any FK's set, but all of the columns are there ready for the FK.
So, how can i add a new FK for the PK of the parent table to the existing column in the child table.
At the moment I have to delete the column and add the FK, otherwise it adds the column in again with a "_1" suffix.
Thanks
Andrew
To connect two table, tool creates new FK column in child table, this is done deliberately to avoid any mistakes by the user. Otherwise there are lot of chances of mistake, like not all the properties/attributes of the column be same. For example if Parent column PK is of datatype nvarchar(45), and child table column (which user wants to make as FK) is nvarchar(46).
Probably, in future we will add the feature where when user tries to add relationship, and the tool finds same column in child table with same properties/attributes, then use existing column.
For now, just delete the column and create relationships, which makes sure that new FK column has correct attributes.
Thanks
Team - SqlDBM
Sorted diagrams
Please can we have the list of diagrams sorted alphabetically. I have many diagrams now, they represent database schemas, and having them in the order they were created is not so flash.
Customer support service by UserEcho