Sample Header Ad - 728x90

Informix - dbaccess vs dbexport to export tables to text files

0 votes
1 answer
1614 views
Currently, we are using the **dbaccess** utility to export all tables in the Informix database to text files. These are used to "mirror" the database multiple Windows machines running MSSQL Server on a nightly basis. I was looking into the **dbexport** utility to see if it would be a viable solution. The text export takes almost 2 hours and I'm looking to shrink that time down if possible. However, I'm not familiar with these Informix utilities and we do not have a test environment for this... so I'm wondering what exactly is the output from dbexport? Is there an option to export each individual table to a text file with dbexport? Thank you.
Asked by RightCoaster (3 rep)
Mar 14, 2019, 02:18 AM
Last activity: Mar 15, 2019, 02:21 AM