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 6 year бұрын updated by Mariusz Zakrzewski 6 year бұрын 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
Аяқталған

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

nigersultana10 6 year бұрын жаңартылды 6 year бұрын 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
Аяқталған

how can i sql execute queary

Yash Sharma 6 year бұрын updated by Rafał Strzaliński (Senior Engineer) 6 year бұрын 1
0
Answered

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

le_univers 6 year бұрын updated by Rafał Strzaliński (Senior Engineer) 6 year бұрын 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
Аяқталған

External Connection?

mbilliodeaux+vertabelo 6 year бұрын жаңартылды 6 year бұрын 4

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

  • MySQL WorkBench or 
  • PGAdmin?

Thanks in advance

Answer
Adam Mościcki 6 year бұрын

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
Аяқталған

Allow multiple imports to one model

Kent Graziano 9 year бұрын updated by Adam Mościcki 6 year бұрын 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
Answered

Wrong sign up option

Matthew Powell 9 year бұрын updated by Marco Sepp 6 year бұрын 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
Аяқталған

how to execute a query

Jaydeep Bhalala 6 year бұрын updated by Mariusz Zakrzewski 6 year бұрын 2
0
Аяқталған

Postgresql 10 Partitioning

Raymond Roelands 6 year бұрын updated by Mariusz Zakrzewski 6 year бұрын 2

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

0
Answered

import sql

Jeff Byers 9 year бұрын updated by anonymous 6 year бұрын 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]