Importing and exporting data and schema from Informix

SOURCE

To get schema :

dbschema -d db_name db_name.sql -nw

To get table data :

unload to 'export/table_name.unl' select * from table_name;

DESTINATION

Restore schema :

dbaccess new_db

Using the menu, navigate to : Query-language > Choose > Choose file > db_name.sql

Restore data :

load from 'export/table_name.unl' insert into table_name;

That’s all šŸ™‚

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s