MS SQL Server timestamp columns being shown as datetime in Visual Paradigm ERD?

Have people noticed MS SQL Server timestamp columns being shown as datetime in Visual Paradigm ERD? Is this an issue for other people ?
Can I please request for Visual Paradigm to support MS SQL Server timestamp data type? (different to datetime data type).

Seems that we should be using a datatype of Rowversion rather than timestamp in sql server table definitions.
i.e. I spotted this article:
http://www.sqlines.com/sql-server/datatypes/timestamp_rowversion

Hi,

Rowversion is available after select SQL Server Version 2008 or higher in Database Configuration.

1 Like

Hi Kit.So,
I tried with a column of type RowVersion and VP turns this into datetime also …
Am I using the wrong DB connection options?

Hi,

The option should be correct. Could you show me the problem about “VP turns this into datetime”?

Hi Kit.So,

(I had thought I had created as data type RowVersion in SSMS )

Even still … VP is turning timestamp into datetime …

cheers, Allan.

Hi,

We identified the problem about reverse database didn’t handle the deprecated “timestamp”.
A patch will be available soon.

1 Like

I would like to let you know the rowversion column being reversed to model as timestamp problem has been fixed. Please update the software to latest patch build (20191020av or later) to get the problem fixed. Details about update to latest patch can be found at

  • Please make sure you have pressed the “Update to latest patch” button on the left hand side of the dialog right after launching the update program

Feel free to contact me if you require any further information.

1 Like