Exporting Complete Database

The firm I work for is currently using Informix IDS 7.31 (which I have no experience on because we've never had to touch it), however, we are moving to a product which uses MS SQL Server 2005. I have been asked by the company who are installing the new app for our data in either MS SQL database format, or flat/text file format. I am not concerned with data conversion, or maintaining any kind of table relationship, the comapny doing the conversion will deal with that, but I need to get the data/tables out of Informix into something that they will use. Does anyone here know how to do this? I have a little SQL knowledge, but not enough to figure this one out Thanks

DAVID INGLIS said: > The firm I work for is currently using Informix IDS 7.31 (which I have no > experience on because we've never had to touch it), however, we are moving > to > a product which uses MS SQL Server 2005. > > I have been asked by the company who are installing the new app for our > data > in either MS SQL database format, or flat/text file format. > > I am not concerned with data conversion, or maintaining any kind of table > relationship, the comapny doing the conversion will deal with that, but I > need > to get the data/tables out of Informix into something that they will use. > > Does anyone here know how to do this? dbexport. It's in TFM. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Thanks, I guess I'll need to go and find the f'ing manual then won't I.

Excelent !!!!! http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.pe rf.doc/perf83.htm bye The freedom of Linux ... The power of Informix >From: "DAVID INGLIS" <david.inglis@semplefraser.co.uk> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: Re: Exporting Complete Database [8941] >Date: Wed, 18 Apr 2007 03:31:52 -0400 (EDT) > >Thanks, I guess I'll need to go and find the f'ing manual then won't I. > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Sabe más sobre la próxima generación del MSN Messenger. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar

Thanks Juan, that's exactly what I was looking for. This is the fastest response I've ever had on a forum, thanks again

U did not mention OS plateform. Assuming Unix, you can do this as: 1. Login with userid who owns the database 2. Check space available on filesystem where you want flats files to hold data 3. Create a dir on that filesystem 4. Change dir to step 3 5. Kill all user connections to database - CAUTION (If not sure, ask someone) 6. nohup dbexport <database name> -ss & 7. Keep an eye on nohup.out file and see if dbexport is over Once dbexport is over, you will see flat files and a SQL files in step 3 dir. Hope it will help. DAVID INGLIS <david.inglis@semplefraser.co.uk> wrote: The firm I work for is currently using Informix IDS 7.31 (which I have no experience on because we've never had to touch it), however, we are moving to a product which uses MS SQL Server 2005. I have been asked by the company who are installing the new app for our data in either MS SQL database format, or flat/text file format. I am not concerned with data conversion, or maintaining any kind of table relationship, the comapny doing the conversion will deal with that, but I need to get the data/tables out of Informix into something that they will use. Does anyone here know how to do this? I have a little SQL knowledge, but not enough to figure this one out Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.

Hi, Here 's an extract of my documenattion. DBEXPORT will only work if your tables are smaller than 2 GB (Informix 7.x has A 2GB limit concerning diskfiles) If you have tables bigger than 2Gb, you can use dbschema to get the schema and Unload to file using a select with a where clause to split the data. Good luck. Jacques Lapeire (isa is th ename of my database in the examples) DBEXPORT (DB blocked during dbexport) To be sure nobody is working, first stop Informix with "onmode -ky" and restart with "oninit". (in the correct environment !!!!) (TAPE) dbexport -c -ss -t /dev/rmt/0 -b 16 -s 20000000 -f /var/tmp/isa_schema.sql isa Informix 7.x tapesize limited to 2 097 151 !!!!!! mkdir /export/home/dbexp (DISK) dbexport -c -ss -o /export/home/dbexp isa (isa is the DB , NOT the instance !!) Creates a directory isa.exp, with 1 file xxx.unl for every table, and 1 specific file isa.sql (also creates dbexport.out in actual directory) This file isa.sql is used to create the tables and can be modified to place the tables into other dbspaces, or to change the extents of a table Example : create table "xxxxxx" { } in "dbspace-name" extent size 8 next size 8 dbschema -d isa -ss isa.sql UNLOAD TO <file> DELIMITER '|' SELECT * FROM <table> -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of DAVID INGLIS Sent: woensdag 18 april 2007 9:25 To: ids@iiug.org Subject: Exporting Complete Database [8938] The firm I work for is currently using Informix IDS 7.31 (which I have no experience on because we've never had to touch it), however, we are moving to a product which uses MS SQL Server 2005. I have been asked by the company who are installing the new app for our data in either MS SQL database format, or flat/text file format. I am not concerned with data conversion, or maintaining any kind of table relationship, the comapny doing the conversion will deal with that, but I need to get the data/tables out of Informix into something that they will use. Does anyone here know how to do this? I have a little SQL knowledge, but not enough to figure this one out Thanks ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Sorry, it's NT4.

No problem !!!! FYI: www.iiug.org www.oninit.com www.serverstudio.com bye The freedom of Linux ... The power of Informix >From: "DAVID INGLIS" <david.inglis@semplefraser.co.uk> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: Re: Exporting Complete Database [8943] >Date: Wed, 18 Apr 2007 03:36:43 -0400 (EDT) > >Thanks Juan, that's exactly what I was looking for. > >This is the fastest response I've ever had on a forum, thanks again > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Sé uno de los primeros a testar el Windows Live Messenger beta. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar

Moving from Informix to MS SQl Server, that's like moving backwards, isn't it? > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of DAVID INGLIS > Sent: 18 April 2007 09:25 > To: ids@iiug.org > Subject: Exporting Complete Database [8938] > > The firm I work for is currently using Informix IDS 7.31 > (which I have no > experience on because we've never had to touch it), however, > we are moving to > a product which uses MS SQL Server 2005. > > I have been asked by the company who are installing the new > app for our data > in either MS SQL database format, or flat/text file format. > > I am not concerned with data conversion, or maintaining any > kind of table > relationship, the comapny doing the conversion will deal with > that, but I need > to get the data/tables out of Informix into something that > they will use. > > Does anyone here know how to do this? I have a little SQL > knowledge, but not > enough to figure this one out > > Thanks > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >

THanks Jacques, I think my DB is about 1.5Gb, so I should be ok As for a backwards step, without getting into too much detail, in terms of products, no, it's an incredible step forwards for us. The product we currently use, which in turn uses Informix, is appalling. The product which uses SQL Server, which we are migrating to, is incredible, in comparison to our current one, so we're more than happy.

DAVID INGLIS said: > The product we > currently use, which in turn uses Informix, is appalling. Elite? -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

I was just being facetious ;-) SQL Server is actually not a bad product at all and has improved in leaps and bounds since SQL Server 7, BUT, I still prefer any DB that runs on Linux, because it is just so much faster and stable/reliable. Pity MS won't port SQL Server to Linux (myabe they will now that they work together with Novell). > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of DAVID INGLIS > Sent: 18 April 2007 09:47 > To: ids@iiug.org > Subject: Re: RE: Exporting Complete Database [8951] > > THanks Jacques, I think my DB is about 1.5Gb, so I should be ok > > As for a backwards step, without getting into too much > detail, in terms of > products, no, it's an incredible step forwards for us. The product we > currently use, which in turn uses Informix, is appalling. The > product which > uses SQL Server, which we are migrating to, is incredible, in > comparison to > our current one, so we're more than happy. > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Elite? :) I'm not going to comment, other than to say we don't currently use Elite. As for SQL Server not being a bad product, I have absolutely no experience in either product. The company we bought our current product from (which was installed before I'd ever worked in I.T.), wrote into the contract we took out with them that we were not to touch the back end, so no-one in the firm has ever had a need to touch Informix. We are also not an SQL house, until now, so that's just as alien. Fingers crossed the new product will need as little backend attention :)

DAVID INGLIS said: > Elite? > > :) I'm not going to comment, other than to say we don't currently use > Elite. Well, if you're going that way, I sincerely hope your experiences are better than mine were. ;o) -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

I have heard about Elite Enterprise (I assume that's what you're aiming at), and have heard some of the issues. However, I have heard that their new product, 3E, is fantastic.

DAVID INGLIS said: > However, I have heard that their new product, 3E, is fantastic. Allegedly. ;o) -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Although back on topic, how long does a dbexport take, based on the db being about 1.5Gb, on NT4, with a slightly dated Pentium 3 1Ghz with 1Gb RAM? Roughly speaking, are we talking an hour, a day etc? Thanks

DAVID INGLIS said: > Although back on topic, how long does a dbexport take, based on the db > being > about 1.5Gb, on NT4, with a slightly dated Pentium 3 1Ghz with 1Gb RAM? > Roughly speaking, are we talking an hour, a day etc? My vague recollection for smaller databases on that sort of kit is that it would take around an hour. But I'd set aside a day for it. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Hi David, We had 7.31 a few years ago and as I remember the utility within informix of dbexport worked for us. I do recall certain limitations on table size or extend but am unsure what those are at this time. I think Flannery's Informix Handbook covered that version and utility. Good luck John Caron USBC-MA Worc. 508-770-8957 Cell 508-509-6574 "DAVID INGLIS" <david.inglis@sem plefraser.co.uk> To Sent by: ids@iiug.org ids-bounces@iiug. cc org Subject Exporting Complete Database [8938] 04/18/2007 03:24 AM Please respond to ids@iiug.org The firm I work for is currently using Informix IDS 7.31 (which I have no experience on because we've never had to touch it), however, we are moving to a product which uses MS SQL Server 2005. I have been asked by the company who are installing the new app for our data in either MS SQL database format, or flat/text file format. I am not concerned with data conversion, or maintaining any kind of table relationship, the comapny doing the conversion will deal with that, but I need to get the data/tables out of Informix into something that they will use. Does anyone here know how to do this? I have a little SQL knowledge, but not enough to figure this one out Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

If my memory serves me correctly, I think that SQL Server Enterprise Manager will import data from any ODBC data source. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > DAVID INGLIS > Sent: Wednesday, April 18, 2007 3:25 AM > To: ids@iiug.org > Subject: Exporting Complete Database [8938] > > > The firm I work for is currently using Informix IDS 7.31 (which I have no > experience on because we've never had to touch it), however, we > are moving to > a product which uses MS SQL Server 2005. > > I have been asked by the company who are installing the new app > for our data > in either MS SQL database format, or flat/text file format. > > I am not concerned with data conversion, or maintaining any kind of table > relationship, the comapny doing the conversion will deal with > that, but I need > to get the data/tables out of Informix into something that they will use. > > Does anyone here know how to do this? I have a little SQL > knowledge, but not > enough to figure this one out > > Thanks > > > ****************************************************************** > ************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Sorry I should have said, I'm not using SQL Server 2005 Enterprise, it's just the standard one, and it's the 64Bit version, not that that should make any difference.

SQL Server 2005 Integration Service (SSIS aka DTS) will be able to connect to Informix using Informix CDSK. You will have to set up the etc/hosts and services file. You can test the CDSK connection though setnet32. Kannan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Hoffman Sent: Wednesday, April 18, 2007 8:16 AM To: ids@iiug.org Subject: RE: Exporting Complete Database [8961] If my memory serves me correctly, I think that SQL Server Enterprise Manager will import data from any ODBC data source. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > DAVID INGLIS > Sent: Wednesday, April 18, 2007 3:25 AM > To: ids@iiug.org > Subject: Exporting Complete Database [8938] > > > The firm I work for is currently using Informix IDS 7.31 (which I have no > experience on because we've never had to touch it), however, we > are moving to > a product which uses MS SQL Server 2005. > > I have been asked by the company who are installing the new app > for our data > in either MS SQL database format, or flat/text file format. > > I am not concerned with data conversion, or maintaining any kind of table > relationship, the comapny doing the conversion will deal with > that, but I need > to get the data/tables out of Informix into something that they will use. > > Does anyone here know how to do this? I have a little SQL > knowledge, but not > enough to figure this one out > > Thanks > > > ****************************************************************** > ************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.