Your feedback is highly appreciated! Let's make Vertabelo even better.

0
Résolu

how to export the DB model into VISIO 2013?

Chaithanya Naik il y a 10 ans mis à jour par Agnieszka Kozubek-Krycuń (Chief Scientist) il y a 10 ans 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?
+1
Prévu

Update columns in view fails to determin type for CASE expression

Tomasz Traczyk il y a 10 ans mis à jour par Agnieszka Kozubek-Krycuń (Chief Scientist) il y a 10 ans 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.

0
À l'étude

Adding a group to view my large schema

sam Prin il y a 10 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 10 ans 2
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?
0
Résolu

Can I use Vertabelo to learn SQL ? If so, what is the best way to get started ?

Sally C il y a 10 ans mis à jour par anonymous il y a 10 ans 1
Solution
anonymous il y a 10 ans
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.
+1
Corrigé

How do i move a model into my team account ?

Ed Croft il y a 10 ans mis à jour par anonymous il y a 10 ans 7
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
Corrigé

Typo in bonus-page

Valentin Mocanu il y a 10 ans mis à jour par anonymous il y a 10 ans 1
On http://www.vertabelo.com/bonus-points there's a typo at the end: "For new and valueble feature request..."
Solution
anonymous il y a 10 ans
Fixed. Thanks for letting us know about this.
0
Résolu

How to change the text size

Mengzhou Fang il y a 10 ans mis à jour par Agnieszka Kozubek-Krycuń (Chief Scientist) il y a 10 ans 1
When I export an PDF, my printout looks so tiny. I need to make the text size larger. But I can't
0
Pas un bug

SQL Server Model with column name of Order adds quotes

Kindler Chase il y a 10 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 10 ans 6
When adding a table for SQL Server and with a column name of Order, the generated SQL incorrectly adds quotes around the column name:

-- 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
Corrigé

Allow .media and other new top level domains in email address validation

sam Prin il y a 10 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 10 ans 3
I was not able ot use my work email address sam@seed.media to sign up
0
Corrigé

Prepaid Code Purchase Destination

Kevin Huber il y a 10 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 10 ans 7
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!