Database Designer is a Inbuilt Tool which comes bundled with Vertica., So it cannot be downloaded independently. Vertica does not support Windows OS.So Database Designer cannot be run from Windows. However, With Vertica 7, this is possible with some workaround ( running Database designer through Windows). But first you need to install vsql client on Windows, If it is installed then Vertica 7 provides API support ( SQL commands to run Database designer commands ) from vsql terminal itself.
More About Database Designer Basically Database designer is a unix based utility, It is built on Unix utility called 'Dialogue' Dialogue is GUI kind of utility which makes using database very easy. It is not so flexible as other programming forms, but it is capable of making plain dialogue boxes, buttons, lists, calendar, decision making , etc.
Yes, that answered most of my questions, thanks a lot! But i didn't get how to use database designer. Should I run it on server machine? I ask it, because I don't have access to the server, just connection string.
You can also use DBD from Vertica Management console. Its a web based app for monitoring and administering Vertica and provides access to DBD from browser.
Three ways you can run database designer 1. Typinig "admintools" on your server will open admintools and then you can navigate to database designer 2. Using management console (most of the admintools features are included in management console 3. Using Vertica Admintools SQL API ( New SQL commands to execute any command in admintools internally)
More input on 2nd option can be found here, These SQL commands can be run through your SQL IDE on windows.
Comments
Database Designer is a Inbuilt Tool which comes bundled with Vertica., So it cannot be downloaded independently.
Vertica does not support Windows OS.So Database Designer cannot be run from Windows.
However, With Vertica 7, this is possible with some workaround ( running Database designer through Windows).
But first you need to install vsql client on Windows, If it is installed then Vertica 7 provides API support ( SQL commands to run Database designer commands ) from vsql terminal itself.
More About Database Designer
Basically Database designer is a unix based utility, It is built on Unix utility called 'Dialogue'
Dialogue is GUI kind of utility which makes using database very easy.
It is not so flexible as other programming forms, but it is capable of making plain dialogue boxes, buttons, lists, calendar, decision making , etc.
Hope this helps.
But i didn't get how to use database designer. Should I run it on server machine?
I ask it, because I don't have access to the server, just connection string.
Three ways you can run database designer
1. Typinig "admintools" on your server will open admintools and then you can navigate to database designer
2. Using management console (most of the admintools features are included in management console
3. Using Vertica Admintools SQL API ( New SQL commands to execute any command in admintools internally)
More input on 2nd option can be found here,
These SQL commands can be run through your SQL IDE on windows.
Hope this helps
https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunct...
Hope this helps