Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    7

    Unanswered: Need a dump of database tables and stored proc

    Hi Guru,

    I've been trying to figure out how to export table structure with out data and stored procs on the database. I don't see any option in dbexport in informix that can do that. Is there anyway I can do this other than dbexport?

    Database: Informix 9.4
    Os: AIX 3.5

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    dbexport is not the right tool, dbschema is the right one:

    dbschema -d databasename outfile.sql:
    you'll get the schema of all the tables of the named database ( including indexes and constraints ), written the file named outfile.sql

    dbschema -d databasename -t tabename outfile.sql:
    you'll get the named table schema ( including indexes and constraints ), written the file named outfile.sql

    No need to be a guru for this :-)

    Eric

  3. #3
    Join Date
    Jul 2011
    Posts
    7
    Hi Eric,

    Thanks for the reply this is a great help for me. Last question, does this cover the stored procedures? Thanks.

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi again,

    supposedly, when using only -d databasename options, procedures and functions are listed. They are not listed if you use -d database name -t tablename.

    Eric

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •