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

0
Fixed

The Oracle SQL generator dont add the comments associate to the tables and columns.

Erika Valerio vor 6 Jahren aktualisiert von Mariusz Zakrzewski vor 6 Jahren 3

A couple of days ago I used the sql generator and the comments were associated without problems. However, today I try to generate the Oracle SQL of my model and it does not add any comments to the objects. My account is free for the moment. I would appreciate your quick response and attention. Greetings.

0
Fertiggestellt

pg_dump and pg_dump all tools backup create zero size backup file from linux putty terminal

nigersultana10 vor 6 Jahren aktualisiert vor 6 Jahren 2

I have install postgres database version 9.6 , 10  on OS Centos 7 64 bit. trying to taken backup with this command

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nigerpg_bkp.sql.

but problem is the backup file size had zero . I have tried many time. Kindly help where i have wrong.

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nig erpg_bkp.sql
-bash-4.2$ cd niger_pgbackup/
-bash-4.2$ ls -ltr
total 0
-rwxrwxrwx 1 postgres postgres 0 Oct 7 23:38 nigerpg_bkp.sql

Regards

Niger

0
Fertiggestellt

how can i sql execute queary

Yash Sharma vor 6 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 6 Jahren 1
0
Beantwortet

Made a foreign key, but this relationship is not shown in SQL preview

le_univers vor 6 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 6 Jahren 1

Apology if this is too basic, but I'm really new to everything and struggling.

So I know how to make a foreign key 

: When there are 2 entities, A and B, you draw a reference from A to B and voila,

the primary keys of A are shown in the B entity boxes as foreign keys, with some names like "A_id".

But when I actually check the SQL preview of B, I don't see any such information as that this data is coming from A.

Am I missing something? How can I make a SQL code like below show up?


PRIMARY KEY (sid, cid), FOREIGN KEY (sid) REFERENCES Students

0
Fertiggestellt

External Connection?

mbilliodeaux+vertabelo vor 6 Jahren aktualisiert vor 6 Jahren 4

Is there a way that I can create and edit tables and records using either:

  • MySQL WorkBench or 
  • PGAdmin?

Thanks in advance

Antwort
Adam Mościcki vor 6 Jahren

Hello,

Vertabelo is a database modeling tool. You can create a database model, generate an SQL script and then apply it with WorkBench or PGAdmin.
We don't have any integration with those tools per se.

Best regards,
Adam Mościcki

+13
Fertiggestellt

Allow multiple imports to one model

Kent Graziano vor 9 Jahren aktualisiert von Adam Mościcki vor 6 Jahren 5
It would be nice to allow us to run the import or reverse engineering utility multiple times for one model. Then we can incrementally build out a design based on other databases.

I tried to import a second DDL file (with additional views) to my model and that over wrote my entire existing model. Not good.

Thankfully I was able to use the restore feature to bring back the previous version from before the import.
0
Beantwortet

Wrong sign up option

Matthew Powell vor 9 Jahren aktualisiert von Marco Sepp vor 6 Jahren 8

I have signed up to vertabelo wrong, I was supposed to sign up through my University and use Vertabelo for education purposes only. However, i've signed up to a basic account and now I'm being asked to upgrade my account. Is there any way I can get my models from this account to a new account for academic purposes?

0
Fertiggestellt

how to execute a query

Jaydeep Bhalala vor 6 Jahren aktualisiert von Mariusz Zakrzewski vor 6 Jahren 2
0
Fertiggestellt

Postgresql 10 Partitioning

Raymond Roelands vor 6 Jahren aktualisiert von Mariusz Zakrzewski vor 6 Jahren 2

Postgresql 10 Partitioning feature and table inheritance should be added to be able to store all models in Vertabelo 

0
Beantwortet

import sql

Jeff Byers vor 9 Jahren aktualisiert von anonymous vor 6 Jahren 5

I get this no matter what sql i upload and try to import



  • WARNING: Tokens were found at line 1, column 1 that do not belong to a registered statement. Check your DDL for completeness.[ USE [ SQL2005_268100_omybs ] GO]