Re: HELP! Transfering data from Informix on UNIX to SQL Server on NT

Posted in 1997

Mike Mozer — Wed, 25 Jun 1997 07:54:23 GMT — source: Informix-list mailing list archive (1991-1998)

On 25 Jun 1997 05:14:56 GMT, Marcus Leon <mleon@bigfoot.com> wrote: >We are attempting to transfer data from an Informix DB on Digital UNIX >to a MS SQL Server6.5 DB on NT. Can anyone please help with some >suggestions? > Well, when you are able to handle DBF-Files (just for importing them), i can send you "unl2dbf". This program runs under WIN (3.11 or more). The things you have to do: 1. Create schema(s) (dbschema -d database -t table table.sql) 2. Unload table(s) (unload to "table.unl" select * from table) 3. Transfer these files (*.sql and *.unl) to the Win-Machine 4. Start unl2dbf and konvert your tables to dbf 5. Import those tables In unl2dbf you have the chance to change fieldnames and so on! UNL2DBF is _still_ free, Interested? Mail to: mozer@gmx.net Mike Mozer.