Re: Creating separate schema for indexes

You are right. Creating the indexes by using a full dbschema to start out does take forever. Informix thought this one out for us already. The dbexport / dbimport utilities already load the data, then create indexes. All I do is 1. create work directory and log into it 2. dbexport __dbname__ 3. tar -cvf dbname.tar * 4. ftp dbname.tar to new system, tar -xvf, then dbimport 5. dbimport will allow you to do such things as naming the dbspace, etc. If I missed the target on the answer __please__ let me know. Thanks Bill Raper > > Hi all - > > > > Does anyone have a utility or other solution to > > this problem? > > > > I want to copy a 7.13 Informix database over to a > > 7.20 instance. If I create the new database with > > indexes, this will take forever to load. So, I > > would like to create two schemas; one with all the > > sql to create tables without indexes and another > > with the sql for the indexes. > > > > I used to accomplish this by grepping the output of > > dbschema for 'create index' or 'create unique > > index' and directing the output to a file. This > > doesn't work now because a lot of my 'create index' > > lines are now actually two lines and the grep will > > just get the incomplete first line. > > > > I hope this make sense to someone and doesn't > > appear to be the incoherent ramblings of a rookie > > (even though it is). > > > > Thanks, > > > > Dick Counsell > > >