What database types does Visual Paradigm support?

General Questions/Discussions
1

What database types does Visual Paradigm support?
i.e. various versions of …
Oracle?
MS SQL Server?
MySQL
etc.

I ask this question as I noted that Visual Paradigm ERD changes some data types from MS SQL Server 2017 … e.g. timestamp to datetime … (actually this is the only datatype I have found changed so far).
I’m starting to like this product more and more. Am doing a trial but think I will plan to buy a license !

(This might relate to the JDBC driver I have chosen for reverse engineer).

image
image681×580 36.9 KB

This Database Configuration display kind of answers my original question.

Perhaps my question is only:

Have people noticed MS SQL Server timestamp columns being shown as datetime in Visual Paradigm ERD? Is this an issue for other people ?

2

Hi allanford17,

Actually all versions of our listed DB should be supported (detail behavior could subject to the JDBC driver), and the version options in Database Configuration dialog is only affecting the variation on the datatype. For example, for SQL Server with version 2005 will have both datetime and timestamp as the standard data type, but switch to 2008 then the timestamp will consider as optional type (show in italic font in column specification dialog) since it is just synonym of rowversion. As long as the DB can handle those synonym then user should not experience any problem on it.

Best regards,
Rain Wong

1 Like
3

Hi Rain,

Thankyou for your reply.
I tried with a column of type rowversion but this also gets converted in VP ERD to datetime.

Should I try different DB connection options?
I am using this at present:

image
image676×574 33.5 KB

kind regards, Allan

4

This issue with rowversion datatype has been fixed in a patch now.
All good :slight_smile: