Menu

#270 Easy generation of migration scripts

closed-accepted
3
2009-08-19
2007-11-11
Carlos Ruiz
No

Implement an easy way to generate migration scripts.

Regards,

Carlos Ruiz

Discussion

  • Carlos Ruiz

    Carlos Ruiz - 2007-11-11

    Logged In: YES
    user_id=1180760
    Originator: YES

    Implemented in trunk with revision 3702.

    The implementation generates the files:
    migration_script_postgresql.sql
    and
    migration_script_oracle.sql
    in the temp directory of the machine

    When the *new* preference "Log Migration Script" is set in preferences window.

    POSSIBLE PROBLEM: Even failed SQL statements are being logged.
    Developer must review carefully the generated migration script for possible problems before committing.

    Regards,

    Carlos Ruiz

     
  • Carlos Ruiz

    Carlos Ruiz - 2007-11-11
    • status: open --> pending
     
  • karsten-thiemann

    Logged In: YES
    user_id=1319537
    Originator: NO

    Hi Carlos,

    great contribution - I really like it!

    Best regards,
    Karsten

     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 15 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     
  • Carlos Ruiz

    Carlos Ruiz - 2009-02-06

    Added a new exception for DELETE FROM SomeTable WHERE AD_Table_ID=? AND Record_ID=?
    with revision 8369

    http://adempiere.svn.sourceforge.net/adempiere/?rev=8369&view=rev

    Regards,

    Carlos Ruiz

     
  • Carlos Ruiz

    Carlos Ruiz - 2009-02-06
    • status: closed --> pending-accepted
     
  • SourceForge Robot

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 15 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending-accepted --> closed-accepted
     
  • Victor Perez Juarez

     
  • Victor Perez Juarez

    The mac os ADempeire developers have a current issue to locate the migration script, the temporary directory in macos is similar to:
    /var/folders/kk/kkPDIx8ZF-4yrdOmCDaevU+++TM/-Tmp-/migration_script_3975442492523176321_oracle.sql

    it is very hard to locate and change by session.

    My propose is that the script migration would generate in ADEMPIERE_HOME path.

    Red1 reported me the same issue

    What do you think , I should include the patch in trunk?

    kind regards
    Victor Perez
    www.e-evolution.com

     
  • Victor Perez Juarez

    • status: closed-accepted --> open-remind
     
  • Carlos Ruiz

    Carlos Ruiz - 2009-08-19

    1 - this must be a feature request, not reopening something already developed and closed

    2 - the FR already exists, so, please don't duplicate:
    FR [1966362] - Location of properties & migration script files
    https://sourceforge.net/tracker/index.php?func=detail&aid=1966362&group_id=176962&atid=879335

    3 - The patch provided doesn't take account of failure if ADEMPIERE_HOME is not set, or webstart (all of these points were already discussed in the tracker 1966362

    4 - solution must work for direct client, webstart client, nx client, etc - with or without ADEMPIERE_HOME variable set

    5 - it is better to finish testing properly the contribution from Tony, instead of starting again from zero

    Regards,

    Carlos Ruiz

     
  • Carlos Ruiz

    Carlos Ruiz - 2009-08-19
    • status: open-remind --> closed-accepted
     

Log in to post a comment.