Author Topic: Patch model to latest DB version (Read 3493 times)

kateh · « **on:** January 24, 2008, 01:38:05 am »

I am fairly new to EA - I have only used it in a basic way so far. I have some SQL scripts which have been written by our developers to patch my DB up to the latest version - is there any way these scripts can be run against an EA model to add the new columns/tables?
Thanks

Martin Terreni · « **Reply #1 on:** January 24, 2008, 07:44:33 am »

I couldn't imagine way not. just don't change EA columns order or delete them.

kateh · « **Reply #2 on:** January 24, 2008, 08:06:08 am »

Sorry - I've obviously not explained myself clearly. I know that I can create the DB, apply the update scripts then reverse engineer it. I was wondering if I could apply the patch script directly within EA.
Thanks

Martin Terreni · « **Reply #3 on:** January 25, 2008, 04:56:11 am »

Hoooo, thats a totally different question

I don't think so. you would have to create a transformation reflecting it maybe...

kateh · « **Reply #4 on:** January 25, 2008, 05:58:57 am »

Ok - thanks anyway. Looks like I'll have to do the reverse engineering.

Sparx Systems Forum

News: