Unanswered: Need a help(how to replicate a production DB without data into an another DB).
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 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.
normally , in Oracle , we will run this in sqlplus prompt or through shell script.