Book a Demo

Author Topic: "Use Database Timestamp" not available for EAP ?  (Read 5031 times)

pocketom

  • EA User
  • **
  • Posts: 97
  • Karma: +0/-0
    • View Profile
"Use Database Timestamp" not available for EAP ?
« on: March 30, 2010, 08:31:28 pm »
I need to activate the option:

'Use Database Timestamp' - select this checkbox to use the database server's timestamp instead of each user's local timestamp; this improves security.


Note:
 
The Use Database Timestamp option is not available for projects stored in .EAP Files.


Why can't I activate it? There is no way to store projects in another format than .eap ? We would need timestamp (or better rowversion) to be added to our generated DDL files.


 

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: "Use Database Timestamp" not available for EAP
« Reply #1 on: March 30, 2010, 09:47:15 pm »
Tom,

You can store EA models in a number different databases including MySQL, SQLServer, Oracle,...

Geert

pocketom

  • EA User
  • **
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: "Use Database Timestamp" not available for EAP
« Reply #2 on: March 30, 2010, 11:24:50 pm »
Ah ok, I understand. This is only usefule when you wan't to use Auditing, so the audit tables will be created with a timestamp.

What I want to do is something different, it has nothing to do with auditing (I searched the Help Topics for 'timestamp' and found only this topic). What I want is that during the DDL generation, the timestamp (or better rowversion) attribute is generated for Create Table statements. Where can I set this in my datamodel?

Here is the background information: http://msdn.microsoft.com/en-us/library/ms182776%28SQL.90%29.aspx

pocketom

  • EA User
  • **
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: "Use Database Timestamp" not available for EAP
« Reply #3 on: April 06, 2010, 11:57:36 pm »
Nobody any ideas? I tried to add it to tagged values, but this doesn't help because the DDL generation script cannot be altered by the EA user (see http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1269608018)

We want that to be added by default to our DDL files for every table because we want to ensure that no developer can forget it.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: "Use Database Timestamp" not available for EAP
« Reply #4 on: April 07, 2010, 08:03:41 am »
Submit a Feature Request using the link below.

pocketom

  • EA User
  • **
  • Posts: 97
  • Karma: +0/-0
    • View Profile
Re: "Use Database Timestamp" not available for EAP
« Reply #5 on: April 07, 2010, 06:30:06 pm »
Good idea, done. :-)

Meanwhile we need to add it manually to the generated DDL tables.