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

0
Résolu

varchar(max)

IT Admin il y a 11 ans mis à jour par vasavib il y a 6 ans 2
For a SQL Server 2012 model varchar(max) throws error: Type is not supported by chosen database engine. However, when I add a column to an existing table and set the data type to varchar(MAX), all is fine. Am I missing something?

Thanks.
0
Terminé

Logical model: How to establish a one to many relationship between 2 entities?

Claire Frankel il y a 6 ans mis à jour par Derek Emrie il y a 6 ans 2

In a logical model of a data warehouse, how do you draw a one-to-many relationship between 2 entities in vertabelo.???

Solution
Adam Mościcki il y a 6 ans

Hello,

1. Please select "add one to many relationship" in the toolbar.

2. Start dragging from "one" table.

3. Stop dragging on "many" table.

Image explanation:

Result:

Hope this helps,
Adam

0
Résolu

Change database

Ken Gillett il y a 11 ans mis à jour par dominic il y a 6 ans 3
Once a model has been created based on a specified database, how can you then change it to use a different database?

Looks to me like you cannot, which is rather limiting and major headache if you've spent a long time developing it and then find you have to use a different database,
Solution
anonymous il y a 11 ans
You can do it this way:
1. export existing model as XML,
2. create a new model in the DB of your choice with this XML as a starting point. You can upload it in "From Vertabelo XML" tab.

After this operation, remember to recheck all "Additional Properties" of tables, columns etc. you've set (if any), since different DBs have a different set of those additional properties.

I hope this helps.
0
Terminé

Is there a way to copy the entire model and have it open up on another page, so that I can make a "version 2" of the model ?

Claire Frankel il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 1

Is there a way to copy the entire model and have it open up on another page, so that I can make a "version 2" of the model ?

thank you in advance for your response. 

Cheers,

Claire Frankel

0
Terminé

Never mind (how to copy). I found it ! Claire Frankel

Claire Frankel il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 1

Never mind (how to copy an entire model) I found it ! 

Cheers,

Claire Frankel

0
Terminé

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT

Claire Frankel il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 1

How to draw a one-to-many relationship between a DIM and a FACT table so that the PK of the DIM will flow into the FACT ?

claire.frankel@warbyparker.com

Solution
Adam Mościcki il y a 6 ans

Hello Claire,

Please:

1. Choose the 'add reference' tool.

2. Start dragging from a DIM table.

3. Drop mouse on a FACT table.

Hope this helps,

Adam

+11
À l'étude

Teradata database engine

Nosheen Iqbal il y a 9 ans mis à jour par Susan Mayer il y a 6 ans 2

Do you plan to add Teradata database?

0

Functions

Jussi Kinnula il y a 8 ans mis à jour par Susan Mayer il y a 6 ans 0

It would be nice to define functions as separate blocks in the diagram. Now I'm using "Additional SQL scripts" section in relevant tables to define functions, but since functions can consist of many views or tables it would be nice to separate them.

0
Résolu

Vertabelo Reverse Engineering Tool doesn't extract databases

Mariusz M il y a 11 ans mis à jour par kate Winfield il y a 6 ans 9
Why Vertabelo Reverse Engineering Tool extracts tables only from master system database in MSSQL Express?
0
Résolu

does not recognize my email

jeffreyjohnson11 il y a 6 ans mis à jour par Adam Mościcki il y a 6 ans 1

I created an account a year ago for the beginner SQL course. I tried to go back to the course today but Vertabelo is claiming that the email associated with my account does not exist. I have the receipt from my purchase on my email account. How would I go about recovering my account? Thank you.