Re: Export/Import Database - Help??
On 27 Oct 1994, Peter Wiley - Poultry wrote:
> Assuming you have Informix >=4.00 release, then
>
> dbexport <your-database-name>
>
> will create a subdirectory calles <dbname>.exp and write the complete SQL
> script necessary to recreate the schema and dumps all the data to ASCII
> files. Works great. dbimport rebuilds the database.
>
> Peter Wiley
>
Yes. it does work, but I don't know about great. There are numerous
downfalls with dbexport and dbimport such as:
In Standard Engine:
------------------
1) path locations of the *.dat and *.idx files are not
written into the sql file.
2) porting to the On-line engine requires numerous
modifications (see below).
In On-Line Engine:
-----------------
1) dbspaces are not written to the sql file.
2) extent sizing " " " " " "
3) locking info " " " " " "
There are several schema programs avail that do give you the missing info
(esp with on-line engine). Please contact me if you need this info.
Regards,
Darin
+----------------------------------------------------------------------------+
| | |
| . . | |
| ... ... | Darin Melin |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | rp29560@email.sps.mot.com Phone:(602)-655-3627 |
| | melin@hermes1.sps.mot.com |
| | VP - Arizona Informix Users Group |
+----------------------------------------------------------------------------+
| 'connectionLESS IS MORE' -- Data Broker |
+----------------------------------------------------------------------------+