Your feedback is highly appreciated! Let's make Vertabelo even better.
Схожі теми не знайдені.

0
Є відповідь
how to export the DB model into VISIO 2013?
Chaithanya Naik 10 років тому
•
оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому •
1
I have created 2 DB models in vertabelo but now i need to export it to VISIO 2013..
is there a way to export this to VISIO 2013 format?
is there a way to export this to VISIO 2013 format?

+1
Planned
Update columns in view fails to determin type for CASE expression
Tomasz Traczyk 10 років тому
•
оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому •
1
In my model I have a view using the CASE expression for some column, like this:
SELECT
(...)
CASE WHEN <some condition> THEN b.name
ELSE c.name
END AS name
(...)
When I click the Update columns button, column name is constantly interpreted as int, while both b.name and c.name are varchar (in fact in my case they even refer to the same column of the same table).
I suppose it might be difficult in general to reason about the desired type of case expression, but as for me, silently assuming that it's int, without any warring is a bug.
I've fixed the type manually sometime ago, then today I've added some new columns to my view and then, not remembering about the issue, hit "Update columns", which silently broke my model. I'd rather get an error, that Vertabelo is unable to update columns.
SELECT
(...)
CASE WHEN <some condition> THEN b.name
ELSE c.name
END AS name
(...)
When I click the Update columns button, column name is constantly interpreted as int, while both b.name and c.name are varchar (in fact in my case they even refer to the same column of the same table).
I suppose it might be difficult in general to reason about the desired type of case expression, but as for me, silently assuming that it's int, without any warring is a bug.
I've fixed the type manually sometime ago, then today I've added some new columns to my view and then, not remembering about the issue, hit "Update columns", which silently broke my model. I'd rather get an error, that Vertabelo is unable to update columns.

0
Under review
Adding a group to view my large schema
I'd like to add a group of email addresses to view my large database schema.
I don't want to have to pay individually for each member because they are based around the world and I do not have access to their email addresses. I would like to add them to my account. I have tried setting up a company account but the members are unable to view because there are too many tables.
Is this possible?
I don't want to have to pay individually for each member because they are based around the world and I do not have access to their email addresses. I would like to add them to my account. I have tried setting up a company account but the members are unable to view because there are too many tables.
Is this possible?

Відповідь
anonymous
10 років тому
Well, I think it'd be much more useful to learn about database basics and good DB design rather than SQL. We even created a series of videos called "Vertabelo Database Academy" that you can find on YouTube:
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI
If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.
Hope this helps.
https://www.youtube.com/playlist?list=PLghpIrBTN3RJdlnubOCuCmQMQOkgKAYWI
If you want to learn SQL, you can look at the changes in generated SQL while adding tables, references, indexes, keys, etc to your model. This might help you to understand the structure of DDLs. However, it won't be much helpful to learn SQL queries. Here, I'd recommend SQL Fiddle, which allows you to run queries against database "in cloud". You can use SQL script generated with Vertabelo to create a DB structure in SQL Fiddle and then play with inserting, updating and querying the data.
Hope this helps.

+1
Fixed
How do i move a model into my team account ?
I have bought a team subscription... but your system won't let me move my models ? How do I move them into team account ?

0
Fixed
Typo in bonus-page
On http://www.vertabelo.com/bonus-points there's a typo at the end: "For new and valueble feature request..."

0
Є відповідь
How to change the text size
When I export an PDF, my printout looks so tiny. I need to make the text size larger. But I can't

0
Not a bug
SQL Server Model with column name of Order adds quotes
When adding a table for SQL Server and with a column name of Order, the generated SQL incorrectly adds quotes around the column name:
The generated SQL should be using brackets:
I haven't tried other key words; if you fix this, I'd suggest testing other key words as well.
Thanks!
-- tables-- Table: OrderTest CREATE TABLE OrderTest ( "Order" int NOT NULL, Value varchar(250) NOT NULL ) ;
The generated SQL should be using brackets:
-- tables-- Table: OrderTest CREATE TABLE OrderTest ( [Order] int NOT NULL, Value varchar(250) NOT NULL ) ;
I haven't tried other key words; if you fix this, I'd suggest testing other key words as well.
Thanks!

0
Fixed
Allow .media and other new top level domains in email address validation
I was not able ot use my work email address sam@seed.media to sign up

0
Fixed
Prepaid Code Purchase Destination
When I am on the pricing page and click the premium account pay per day link, it just takes me to one of my model's page. I want to pay money but can't!
Служба підтримки клієнтів працює на UserEcho