Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    24

    Unanswered: Need a help(how to replicate a production DB without data into an another DB).

    Hi

    I am an Oracle DBA , new to Informix. i have an assignment to be completed within 15 days. My request is :

    There is one IDS9.2 production server running in HP -UX platform.
    tasks are :

    1. Installing Informix Dynamic server in HP-UNIX.
    2.Creating database structure based on production database.
    3.replicating the production database structure in the new database without data( only DDL is needed).

    I need any one of your help in this.
    Appreciate your help.


    thanks

    Sundar

  2. #2
    Join Date
    Jan 2005
    Posts
    30
    Run dbschema on production system.
    dbschema -d <database name> -ss <output dll file>

    The 'output dll file' will be your complete DDL of production databse.

    Use the output DDL file on other machine to create the database.
    __
    SC

  3. #3
    Join Date
    Jan 2005
    Posts
    24

    thanks a lot

    Hi
    Thanks a lot for your kind reply.
    Sorry to trouble you, just tell me few things .
    once i generate that DDL , how to run that script.
    I saw somewhere that DB-Access and isql tools.
    whether can i use that tool to run this script or , can i use the same 'dbschema' commad in the target database.
    Apppreciate your kind help.


    thanks

    Sundar

    Note :
    normally , in Oracle , we will run this in sqlplus prompt or through shell script.

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    After generating the DDL, run dbaccess and create a new database, then run the ddl all the tables & indexes will be created.

  5. #5
    Join Date
    Jan 2005
    Posts
    24

    Thanks a lot

    Hi

    Thanks a lot for your kind reply and help.


    sundar

Posting Permissions

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