Tenant Databases and DBImport

Hi All, trying to migrate a development system I encountered a problem with tenent databases and dbimport. My idea was to export 50+ user databases with dbexport, create tenant databases with predefined resourcces for each developer and import table structures and data via dbimport. This is impossible, because dbimport intends to create an already existing database. Is there any workaround, any feature of dbimport that does not create the database? Ideas are appreciated. Thanks Peter Ijewski

My dbimport replacement utility, myimport can do that. It is included in the myexport package which you can download from the IIUG Software repository. Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 19, 2014 at 5:13 AM, PETER IJEWSKI <peter@ijewski.de> wrote: > Hi All, > > trying to migrate a development system I encountered a problem with tenent > databases and dbimport. > > My idea was to export 50+ user databases with dbexport, create tenant > databases with predefined resourcces for each developer and import table > structures and data via dbimport. > > This is impossible, because dbimport intends to create an already existing > database. > > Is there any workaround, any feature of dbimport that does not create the > database? > > Ideas are appreciated. > > Thanks > > Peter Ijewski > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158c2008574280500f957fc

If you create an EMPTY multi tenant database then do a db= import with a flag called "-exists" In order to use the new -e= xists flag, the database MUST be empty. Currently this flag is un= documented, Caveat emptor. John F. Miller III ST= SM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix D= ynamic Server (IDS) -----ids-bounces@= iiug.org wrote: ----- >To: ids@iiug.org >From: "PETE= R IJEWSKI" >Sent by: ids-bounces@iiug.org >Date: 08/19/2014 02= :14AM >Subject: Tenant Databases and DBImport [33530] > >= ;Hi All, trying to migrate a development system I encountered a >pr= oblem with tenent databases and dbimport. My idea was to export >5= 0+ user databases with dbexport, create tenant databases with >prede= fined resourcces for each developer and import table structures >and= data via dbimport. This is impossible, because dbimport intends >t= o create an already existing database. Is there any workaround, >a= ny feature of dbimport that does not create the database? Ideas >a= re appreciated. Thanks Peter Ijewski >***************************= ****************************************** >********** Forum Note:= Use "Reply" to post a response in the >discussion forum.

Thank you for your response! Because of inhouse limitations I'm still not able to receive those files. As soon as possible I will try. Peter

Thank you John! This is working. I have not been able to create a tenant database and to import the database in one single script. Gives me error 9662. But exactly the same statements in two separated scripts do the trick. You saved me a lot of work! Peter