Book a Demo

Author Topic: Identifying modfications  (Read 3309 times)

mandarlimaye

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Identifying modfications
« on: August 04, 2014, 09:05:06 pm »
Hello
I want to synchronize records from legacy system to EA, How to identify the modified and newly created terms in EA so as to add to legacy system.
I tried to search the forum with identify modifications, Detect updated terms etc.
Thanks in advance.

Regards
Mandar  

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Identifying modfications
« Reply #1 on: August 04, 2014, 09:16:50 pm »
You could use Audit (see the help). Or Baseline comparison.

q.

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: Identifying modfications
« Reply #2 on: August 05, 2014, 07:39:23 pm »
A quick-glance way to identify changes in an EA repository is to check ModifiedDate in the t_object and t_diagram tables. This doesn't give you a complete picture by any means, but it's handy in some situations.

Code: [Select]
select ea_guid as classguid, Object_Type as classtype, *
            from t_object where ModifedDate > '20140801'
select ea_guid as classguid, *
            from t_diagram where ModifedDate > '20140801'

/Uffe
My theories are always correct, just apply them to the right reality.