informix ---> sqlserver

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

Brian TEMPLETON — Wed, 07 Apr 1999 12:02:18 +1000 — source: Informix-list mailing list archive (1991-1998)

Hi, =20 I need to pull data from a sqlserver db on an NT Server, to update into an = Informix db (7.23 HPUX 10.20) on a nightly basis, this will be across our = wan. - Is this possible using perl/dbd, as I would like to run this task from = the HP side automatically ? Or will I have to initiate an unload from sqlserver on the NT box, then = move the data and upload ? TIA - Brian =20

↪ replying to Brian TEMPLETON

Imran Hussain — Fri, 09 Apr 1999 15:41:38 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi Brian, If you are using MS SQL 7.0, then you can use DTS. If it is 6.x then try WinSQL at http://www.imranweb.com/freesoft. Get the professional version. Thanks Brian TEMPLETON wrote: > Hi, > =20 > I need to pull data from a sqlserver db on an NT Server, to update into an = > Informix db (7.23 HPUX 10.20) on a nightly basis, this will be across our = > wan. > > - Is this possible using perl/dbd, as I would like to run this task from = > the HP side automatically ? > > Or will I have to initiate an unload from sqlserver on the NT box, then = > move the data and upload ? > > TIA > > - Brian > > =20 -- =========================================== Imran Hussain MCP, MCSD imranh@imranweb.com FOR FREE Software http://www.imranweb.com/freesoft ===========================================