Omnis Datafile to PostgreSQL
Alex Clay
aclay at mac.com
Fri Dec 10 10:08:17 EST 2010
Your best bet will be to export the data from the datafile into separate files, one per table. Then use the COPY feature in postgresql to import the data.
http://www.postgresql.org/docs/9.0/interactive/sql-copy.html
Alex
On Dec 10, 2010, at 10:02 AM, Nick Renders wrote:
> Hi List,
>
> I was wondering if anyone had some tips about exporting data from an Omnis Datafile into a PostgreSQL database?
>
> I used drag&drop in the Omnis Studio SQL browser for most tables, but there is one table with over 3 million records.
> After 3 days, the transfer was still only at 20%. I am hoping there is a faster way.
>
>
> Regards,
>
> Nick Renders
>
> ARC - your ICT service partner
> H. D. Saviolaan 8
> 1700 Dilbeek
> T: (00 32) (0)2 466 50 00
> F: (00 32) (0)2 466 88 33
> http://www.arcict.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en
mailing list