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

  1. Foorum: Vertabelo
0
Answered

varchar(max)

IT Admin 11 aastat tagasi • uuendaja vasavib 5 aastat tagasi • 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
Lõpetatud

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

Claire Frankel 5 aastat tagasi • uuendaja Derek Emrie 5 aastat tagasi • 2

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

Vasta
Adam Mościcki 5 aastat tagasi

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
Answered

Change database

Ken Gillett 10 aastat tagasi • uuendaja dominic 5 aastat tagasi • 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,
Vasta
anonymous 10 aastat tagasi
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
Lõpetatud

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 5 aastat tagasi • uuendaja Adam Mościcki 5 aastat tagasi • 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
Lõpetatud

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

Claire Frankel 5 aastat tagasi • uuendaja Adam Mościcki 5 aastat tagasi • 1

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

Cheers,

Claire Frankel

0
Lõpetatud

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 5 aastat tagasi • uuendaja Adam Mościcki 5 aastat tagasi • 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

Vasta
Adam Mościcki 5 aastat tagasi

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

0

i want to make a job portal for student and job seeks but i don't have to much capital if you help me for build a job portal

tahermba87 5 aastat tagasi • 0

I from India I want to make a job portal for student and job seeker but I don't have too much capital if you help me for build a job portal so I will help for job seeker and student and many more people so I kindly request to you please accept my proposal.

0
Ülevaatamisel

Diagram exists outside of workspace

Blake Borinstein 5 aastat tagasi • uuendaja Rafał Strzaliński (Senior Engineer) 5 aastat tagasi • 1

Imported a diagram from generation script and the diagram exists outside of the workspace/white rectangle. I can only view the tables when I select one and use "Find in Diagram" but other than that it does not show up. As soon as I click it takes me back to the blank white space. 

Image 786

+9
Ülevaatamisel

Teradata database engine

Nosheen Iqbal 9 aastat tagasi • uuendaja Susan Mayer 5 aastat tagasi • 2

Do you plan to add Teradata database?



Customer support service by UserEcho