Your feedback is highly appreciated! Let's make Vertabelo even better.
Graphical representation of UNIQUE columns
Why isn't there a "U" on the right side next to type like there is a graphical representation for private and foreign keys? I know you can set a variable as unique but it doesn't show in the diagram.
Importing New Tables Into Model Erases Existing Content
I am attempting to import a number of new tables into an existing model, but when I do so (using the SQL Script Option) everything that was in the model previously is erased. Is there way to "merge" in these new tables and not have them simply overwrite what is in place?
SQL preview is not working for references
Actually it was working before new year and now is broken.
Steps to reproduce:
1) Add 2 tables
2) Add reference between then
3) Select reference
4) Press "SQL Preview" button.
Result:
Empty preview (no SQL code except for comments).
"Type not supported" error for the default varchar in Postgres. Why?
In developing an ER diagram for Postgres, I always get "type not supported" error for the default varchar. If I don't change anything, it warns me about % sign, if I leave the () blank then I get a warning, which is better than an error, but this isn't great.
Am I missing something?
Thanks,
willie
I believe the behavior is correct. Let's go through all the cases you described.
First of all, the default varchar (that is one without lenght) has syntax: "varchar" or "character varying". You can write it this way in "Type" field and you get no error:
tests=> CREATE TABLE def_varchar ( tests(> id int NOT NULL, tests(> code varchar NOT NULL, tests(> CONSTRAINT def_varchar_pk PRIMARY KEY (id) tests(> ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "def_varchar_pk" for table "def_varchar" CREATE TABLE
Then, if you try either "varchar()" or "varchar(%)", both Vertabelo and PostgreSQL will raise an error:
tests=> CREATE TABLE def_varchar ( tests(> id int NOT NULL, tests(> code varchar() NOT NULL, tests(> CONSTRAINT def_varchar_pk PRIMARY KEY (id) tests(> ); ERROR: syntax error at or near ")" LINE 3: code varchar() NOT NULL, ^
tests=> CREATE TABLE def_varchar ( tests(> id int NOT NULL, tests(> code varchar(%) NOT NULL, tests(> CONSTRAINT def_varchar_pk PRIMARY KEY (id) tests(> ); ERROR: syntax error at or near "%" LINE 3: code varchar(%) NOT NULL, ^
Please note that the list of data types is only a helper to choose the most common ones. You can provide any text you want into the "Type" field. Vertabelo either warns you or raises an error if it doesn't recognize the type, but you can ignore it if you like.
Hope this helps.
Notes sizing and re-sizing
Selective Table SQL generation
Calculated Fields
Vertabelo is great but it's missing Computed Columns feature, at least in SQL Server projects.
So Calculated Columns are created like this (Inventory), and I really think that implementing this feature for you is not a big trouble.
CREATE TABLE dbo.Products ( ProductID int IDENTITY (1,1) NOT NULL , QtyAvailable smallint , UnitPrice money , InventoryValue AS QtyAvailable * UnitPrice );
Full documentation on https://msdn.microsoft.com/en-us/library/ms188300.aspx
Modify Database
Once I generate SQL and create my database, is it possible to generate "modification" sql, which might involve saving old data and re-inserting in new tables?
Your file is not valid with our XSD
I get this error message while I try to add my old xml doc. I made it with vertabelo in 2015
Hello,
Please send your XML file to our email address: contact@vertabelo.com
Best regards,
Adam
If auto-logged out, please make it so logging back it will take me directly back to the project I was working on
Currently, if my computer goes to sleep or I'm otherwise auto logged off, I'm required to log back in and navigate back to the project I was working on. I would be great if logging back in would take me directly there (or better yet, don't auto log me off and allow me to just reconnect and pickup where I left off)
Customer support service by UserEcho