#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2011
    Posts
    7
    Rep Power
    0

    Help for exporting Triggers and procedures firebird database


    I need to export triggers and procedures created in my testing database to the original working database without making any changes to the existing tables and the data contained in it.Iam using IB expert firebird database manager.Does anyone know how to do this from interface or by any means except doing it manually dropping and creating.Looking forward for your help..

    Thank You.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    From the IBExpert menu use:
    Tools - > Database comparer
    Here you must indicate:
    - the source database (your testing database)
    - the target database (your working database).
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2011
    Posts
    7
    Rep Power
    0
    Thanks costin_mentor,
    But Database comparer is not active in my IB expert interface.
    It's always in disabled state,so i can't take that.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    12
    If you know the exact triggers and procedures that you need to extract in IBExpert, after you're connected to the test database Tools->Extract Metadata and you have to select the triggers and procedures for the extract.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2011
    Posts
    7
    Rep Power
    0
    thanks mIRCata

    and Thanks to all

    It worked fine....

IMN logo majestic logo threadwatch logo seochat tools logo