Oninit cdi / Archive
Talk to an expert →

DataTransfer to SQL Server

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

Mattias Johansson — — source: Informix-list mailing list archive (1991-1998)

Hello! How can I transfer data from Informix database to SQLServer 7.0? (ODBC,OLEDB Provider) / Mattias Johansson -- -------------------------------------------------------------- Teleoptimering AB J'rnv'gsgatan 2, 645 31 Str'ngn's Phone: +46 152 124 76 Cell:+46 (0)709 54 49 06 fax:+46 8 544 90 560 e-mail: mattias.johansson@teleopti.se Internet: www.teleopti.se

↪ replying to Mattias Johansson
Tung Nguyen — — source: Informix-list mailing list archive (1991-1998)

Use the Data Transfer Service (DTS) in MSSQL 7. 1. Start up the MSSQL Enterprise Manager 2. Select Tools/Data Transfer Services/Import Data and follow the instructions (you need to create an ODBC data source for the Informix DB) Hope this help Cheers Tung Mattias Johansson wrote in message ... >Hello! > >How can I transfer data from Informix database >to SQLServer 7.0? (ODBC,OLEDB Provider) > >/ Mattias Johansson > > >-- >-------------------------------------------------------------- > >Teleoptimering AB > >J'rnv'gsgatan 2, 645 31 Str'ngn's > >Phone: +46 152 124 76 > >Cell:+46 (0)709 54 49 06 fax:+46 8 544 90 560 > >e-mail: mattias.johansson@teleopti.se Internet: www.teleopti.se > > > > > >

↪ replying to Mattias Johansson
Watawinona — — source: Informix-list mailing list archive (1991-1998)

why downgrade to an inferior product like SQL Server 7.0 - it is like a car with fuzzy dice (fuzzy GUIs) hanging on the rear-view mirror. The fuzzy dice might be photogenic, but they do not make up for the loss of horse-power under the hood. And if you get into an o-o swamp, the fuzzy dice will not keep the vehicle afloat, you really need an amphibious vehicle like Informix9. And if you stop into a warehouse, you really need something like an Informix7 or 8 instead of SQL Server 7.0. Nona >Subject: DataTransfer to SQL Server >From: "Mattias Johansson" mattias.johansson@teleopti.se >Date: 22.03.00 13:29 W. Europe Standard Time >Message-id: <B03C4.1292$Lh9.198353920@newsb.telia.net> > >Hello! > >How can I transfer data from Informix database >to SQLServer 7.0? (ODBC,OLEDB Provider) > >/ Mattias Johansson > > >-- >-------------------------------------------------------------- > >Teleoptimering AB > >Järnvägsgatan 2, 645 31 Strängnäs > >Phone: +46 152 124 76 > >Cell:+46 (0)709 54 49 06 fax:+46 8 544 90 560 > >e-mail: mattias.johansson@teleopti.se Internet: www.teleopti.se > > > > > > > > > > > >