Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    10

    Unhappy Unanswered: Dump Sybase IQ database without data

    I have problem dump Sybase IQ database with out data (schema) and load it in to a new IQ database

    Can some one help regarding this

    Thanks you
    Lakshan

  2. #2
    Join Date
    May 2007
    Posts
    10

    Red face Dump Sybase IQ database without data

    Hope no one aware of this question where I mention previously

    Ok, but any way I try this with power designer through reengineering the database and try to extract the DDL script out of it, but I cant run and insert all the tables under Sybase IQ database which I create (my own created database), from one extended I cannot insert the DDL scripts, the DBSQL program seems getting hang so I have to restart the database to reconnect back. But what I feel is that the problem with the database sizing, if I create the another new database and try to inserts the DDL script where I cannot execute point, it successfully inserting.

    Please some one tell me how to make a Sybase IQ database where I can insert any number of tables with the sizing problem

    Here is the sql script where I use to create the database

    CREATE DATABASE '/home/sybase_iq/avameddb/avamediq.db'
    TRANSACTION LOG ON '/home/sybase_iq/avameddb/avamediq.log'
    PAGE SIZE 4096
    JAVA ON
    JCONNECT ON
    CASE RESPECT
    PASSWORD CASE RESPECT
    IQ PATH '/home/sybase_iq/avameddb/IQ_MAIN_00'
    IQ PAGE SIZE 65536
    MESSAGE PATH '/home/sybase_iq/avameddb/avamediq.iqmsg'
    TEMPORARY PATH '/home/sybase_iq/avameddb/IQ_TEMP_00'


    Thanks you
    Lakshan

Posting Permissions

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