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

0
Answered

Need to remove users

Eugene Vais 8 years ago updated by Adam Mościcki 6 years ago 3

Hello,I have 3 users that I need to completely remove from the account. While I am able to lock them, I am not able to remove them. The Delete button is not enabled since some documents are shared with them. Please help with this.

Answer

Hi,


That ticket is private now. Here is an instruction:


Please do the following steps:
1. Please log in
2. Open https://my.vertabelo.com/company-account/documents - this is a page showing all documents in the team.
3. Select user that you want to delete in the top left select field.
4. For each document where he is an owner please remove it or take access of it.
5. Remove user.


Hope it helps.

0
Completed

Is there any way to automatically Normalized database architecture to denormalized database architecture ?

Ashok Pradhan 6 years ago updated by Adam Mościcki 6 years ago 2

Please suggest me.

Answer
Adam Mościcki 6 years ago

Hello,


Right now, Vertabelo doesn't provide any (de)normalization utilities.


Best regards,

Adam Mościcki

+4

Add Materialized View option

marcOcram 9 years ago updated by Marcin Szuppe 6 years ago 1

Hello,


I'm currently using PostgreSQL 9.4 as my DBMS and I would like to use the concept of materialized views (>= PostgreSQL 9.3). As there's no option to convert a view into a materialized view which I can fire as an after create statement, my only way to add a materialized view is to copy the created sql code, drop the view as an after create statement and create the exact same view as a materialized view.


So I'm suggesting a new view in form of a materialized view or some option to make a view materialized. This would be very helpful (at least for me).

0
Answered

Where can I designate "NOT NULL" for Postgres?

Matthew Weber 6 years ago updated by Rafał Strzaliński (Senior Engineer) 6 years ago 1

How can I define a field as NOT NULL within the UI? In particular I am using Postgres

0
Answered

support sqlite3

Eyad Khalel 6 years ago updated by Adam Mościcki 6 years ago 1

does your IDE (vertabelo) support the last version of sqlite ? at least sqlite 3?

Answer
Adam Mościcki 6 years ago

Hello,


Are you interested in any specific feature?

We support 3.x version of SQLite, so the last version should work too. 

Best regards,

Adam Mościcki


0
Completed

Export into html file

Tran Van Thuc 6 years ago updated by Rafał Strzaliński (Senior Engineer) 6 years ago 1
0
Under review

comment commander une licence ?

isabelle 6 years ago updated by anonymous 6 years ago 1

Bonjour Nous sommes des revendeurs Informatiques pour 1 client j'ai besoin de commander

une licence Annuel Verbato? comment faire ?

+6
Fixed

Exclude Firefox from HTML5 error message

Sander in 't Hout 7 years ago updated by anonymous 6 years ago 2

When I try to open a database design, the HTML5 app tells me it only supports Chrome and Safari due to limitation on other browsers.


I tested it on Firefox by changing the user-agent the string Chrome uses and it actually works great. I think the error message should be removed.

0
Under review

Import of table and column descriptions from SQL not working

Mohit Vashisht 6 years ago updated by anonymous 6 years ago 1

I need to migrate over existing model with 150 tables from another tool to vertabelo along with descriptions through SQL export-import? Right now tables are getting imported but no table descriptions or column descriptions are imported. How to do that?

0
Answered

Details on versioning, with "differences" between versions

Sergio Sardo 6 years ago updated by Adam Mościcki 6 years ago 1

Is there a way to have the differences between two saved versions of a DB ?
In the edit story I can click on "preview", but I see only the entire database.
I'd like to find out the difference between the current version and one saved a few days ago

Thanks

Answer
Adam Mościcki 6 years ago

Hello,


There is no way to preview differences between versions. As a workaround, you can generate migration script. Details: https://www.vertabelo.com/documentation/managing-models/migration-scripts

Hope this helps.

Adam Mościcki