Book a Demo

Author Topic: Alter DDL or schema diff  (Read 3558 times)

ms

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Alter DDL or schema diff
« on: June 21, 2007, 09:28:24 am »
I would appreciate very much if some one can help me with this.  What I would like to be able to do is to have EA generate alter DDL statements that I can run on my database as I change the schema in EA so that the database and the EA schemas remain in sync.

I not only want to be able to diff the schema but I also want the alter DDL to be generated by EA.

So, is there a way to do it.

Thanks,

-Mohammad

thomaskilian

  • Guest
Re: Alter DDL or schema diff
« Reply #1 on: June 21, 2007, 09:39:33 am »
This is somewhere in Sparx pipeline. Search for DDL in this forum and you will likely find the right threads.

ms

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Re: Alter DDL or schema diff
« Reply #2 on: June 21, 2007, 10:33:09 am »
Thanks Thomas.  

I did search for Alter DDL and stuff but did not see what I am looking for.  I did find some thing about base lining.  But nothing about generating alter DDL for the diff in the base line and the changed schema.



Thanks again.

thomaskilian

  • Guest
Re: Alter DDL or schema diff
« Reply #3 on: June 21, 2007, 11:24:49 am »
Yeah - search MAY find useful thread, but not always :(

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Alter DDL or schema diff
« Reply #4 on: June 21, 2007, 02:06:59 pm »

ms

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
Re: Alter DDL or schema diff
« Reply #5 on: June 21, 2007, 02:21:15 pm »
Hi Simon,

Thanks for the link.  Atleast they are working on it.  I am sure they will do a good job of it.

Appreciate your finding the link.