How to export an Informix db to MS SQL Server 2000?

[Doug Baroter]

Hi,

My client has an Informix SE database on Windows Platform (NT). How
do I export such a db to MS SQL Server 2000? I've searched this NG,
someone mentioned about setting up i-connect driver, however, I
couldn't find such as a driver from IBM web site to download.

Thanks.

[Jack A]

Why dont you use DTS available in Sql Server ? Get the ODBC driver for
Informix from Microsoft or some one else. Set up a DTS package using
Informix as the Source and MS Sql Server as the target. Once you set up the
DTS it will migrate all the data for you.

"Doug Baroter" <qwert12345@boxfrog.com> wrote in message
news:fc254714.0308251240.6768915a@posting.google.c om...

> Hi,
>
> My client has an Informix SE database on Windows Platform (NT). How
> do I export such a db to MS SQL Server 2000? I've searched this NG,
> someone mentioned about setting up i-connect driver, however, I
> couldn't find such as a driver from IBM web site to download.
>
> Thanks.

[Doug Baroter]

Searched MS site did not yield anyting meaningful. Do you happen to
know any other company that has reliable ODBC driver to connect to
Informix? I know my system has ODBC driver for Informix from Merant
(version 3.7), I can't tested it now, have you ever used it, any good?
Thanks.

"Jack A" <jacka8@excite.com> wrote in message news:<6f4b8212ac95991e6d6c618bb760a89c@news.terane ws.com>...

> Why dont you use DTS available in Sql Server ? Get the ODBC driver for
> Informix from Microsoft or some one else. Set up a DTS package using
> Informix as the Source and MS Sql Server as the target. Once you set up the
> DTS it will migrate all the data for you.
>
> "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> news:fc254714.0308251240.6768915a@posting.google.c om...

> > Hi,
> >
> > My client has an Informix SE database on Windows Platform (NT). How
> > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > someone mentioned about setting up i-connect driver, however, I
> > couldn't find such as a driver from IBM web site to download.
> >
> > Thanks.

[Murray Wood \(IList\)]

You need some ODBC drivers. They are part of SDK which is free.
Download install SDK and configure IConnect, then configure an ODBC driver.
Use the DTS wizard to migrate the data.

MW

> -----Original Message-----
> From: [email]owner-informix-list@iiug.org[/email]
> [mailto:owner-informix-list@iiug.org]On Behalf Of Doug Baroter
> Sent: Tuesday, 26 August 2003 8:40 a.m.
> To: [email]informix-list@iiug.org[/email]
> Subject: How to export an Informix db to MS SQL Server 2000?
>
>
> Hi,
>
> My client has an Informix SE database on Windows Platform (NT). How
> do I export such a db to MS SQL Server 2000? I've searched this NG,
> someone mentioned about setting up i-connect driver, however, I
> couldn't find such as a driver from IBM web site to download.
>
> Thanks.

sending to informix-list

[Jean Sagi]

You could do DTS,but you will run into troubles if the data to be migrated is big... It will need a lot of logical logs...

If you know how to deal with this issue do it through DTS is easy.

Chucho!

-----Original Message-----
From: "Jack A" <jacka8@excite.com>
To: [email]informix-list@iiug.org[/email]
Date: Mon, 25 Aug 2003 21:05:48 GMT
Subject: Re: How to export an Informix db to MS SQL Server 2000?

Why dont you use DTS available in Sql Server ? Get the ODBC driver for
Informix from Microsoft or some one else. Set up a DTS package using
Informix as the Source and MS Sql Server as the target. Once you set up the
DTS it will migrate all the data for you.

"Doug Baroter" <qwert12345@boxfrog.com> wrote in message
news:fc254714.0308251240.6768915a@posting.google.c om...

> Hi,
>
> My client has an Informix SE database on Windows Platform (NT). How
> do I export such a db to MS SQL Server 2000? I've searched this NG,
> someone mentioned about setting up i-connect driver, however, I
> couldn't find such as a driver from IBM web site to download.
>
> Thanks.

Jean Sagi
[email]jeansagi@myrealbox.com[/email]
[email]jeansagi@netscape.net[/email]


sending to informix-list

[Jack A]

DataDirect has good ODBC drivers. I have used them. Merant ODBC drivers are
also good. I've used them too. Intersolv is another company you can try.
They're in the ODBC business too.

"Doug Baroter" <qwert12345@boxfrog.com> wrote in message
news:fc254714.0308251807.64d0c39f@posting.google.c om...

> Searched MS site did not yield anyting meaningful. Do you happen to
> know any other company that has reliable ODBC driver to connect to
> Informix? I know my system has ODBC driver for Informix from Merant
> (version 3.7), I can't tested it now, have you ever used it, any good?
> Thanks.
>
> "Jack A" <jacka8@excite.com> wrote in message

news:<6f4b8212ac95991e6d6c618bb760a89c@news.terane ws.com>...

> > Why dont you use DTS available in Sql Server ? Get the ODBC driver for
> > Informix from Microsoft or some one else. Set up a DTS package using
> > Informix as the Source and MS Sql Server as the target. Once you set up

the

> > DTS it will migrate all the data for you.
> >
> > "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> > news:fc254714.0308251240.6768915a@posting.google.c om...

> > > Hi,
> > >
> > > My client has an Informix SE database on Windows Platform (NT). How
> > > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > > someone mentioned about setting up i-connect driver, however, I
> > > couldn't find such as a driver from IBM web site to download.
> > >
> > > Thanks.

[Jack A]

Just curious. What does the "chucho!" at the end of your post mean ?

"Jean Sagi" <jeansagi@myrealbox.com> wrote in message
news:bifkgl$k3q$1@terabinaries.xmission.com...

>
>
> You could do DTS,but you will run into troubles if the data to be migrated

is big... It will need a lot of logical logs...

>
> If you know how to deal with this issue do it through DTS is easy.
>
> Chucho!
>
> -----Original Message-----
> From: "Jack A" <jacka8@excite.com>
> To: [email]informix-list@iiug.org[/email]
> Date: Mon, 25 Aug 2003 21:05:48 GMT
> Subject: Re: How to export an Informix db to MS SQL Server 2000?
>
> Why dont you use DTS available in Sql Server ? Get the ODBC driver for
> Informix from Microsoft or some one else. Set up a DTS package using
> Informix as the Source and MS Sql Server as the target. Once you set up

the

> DTS it will migrate all the data for you.
>
> "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> news:fc254714.0308251240.6768915a@posting.google.c om...

> > Hi,
> >
> > My client has an Informix SE database on Windows Platform (NT). How
> > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > someone mentioned about setting up i-connect driver, however, I
> > couldn't find such as a driver from IBM web site to download.
> >
> > Thanks.

>
>
>
>
> Jean Sagi
> [email]jeansagi@myrealbox.com[/email]
> [email]jeansagi@netscape.net[/email]
>
>
> sending to informix-list

[RPhillips@ce-a.com]

I use the intersolv ODBC driver to facilitate a DTS package of our informix
DB for inclusion into our datawarehouse in SQL. It works fairly well
exporting 7Gigs in just over an hour.

-----Original Message-----
From: Jack A [mailto:jacka8@excite.com]
Sent: Tuesday, August 26, 2003 8:45 AM
To: [email]informix-list@iiug.org[/email]
Subject: Re: How to export an Informix db to MS SQL Server 2000?


DataDirect has good ODBC drivers. I have used them. Merant ODBC drivers are
also good. I've used them too. Intersolv is another company you can try.
They're in the ODBC business too.

"Doug Baroter" <qwert12345@boxfrog.com> wrote in message
news:fc254714.0308251807.64d0c39f@posting.google.c om...

> Searched MS site did not yield anyting meaningful. Do you happen to
> know any other company that has reliable ODBC driver to connect to
> Informix? I know my system has ODBC driver for Informix from Merant
> (version 3.7), I can't tested it now, have you ever used it, any good?
> Thanks.
>
> "Jack A" <jacka8@excite.com> wrote in message

news:<6f4b8212ac95991e6d6c618bb760a89c@news.terane ws.com>...

> > Why dont you use DTS available in Sql Server ? Get the ODBC driver for
> > Informix from Microsoft or some one else. Set up a DTS package using
> > Informix as the Source and MS Sql Server as the target. Once you set up

the

> > DTS it will migrate all the data for you.
> >
> > "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> > news:fc254714.0308251240.6768915a@posting.google.c om...

> > > Hi,
> > >
> > > My client has an Informix SE database on Windows Platform (NT). How
> > > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > > someone mentioned about setting up i-connect driver, however, I
> > > couldn't find such as a driver from IBM web site to download.
> > >
> > > Thanks.

sending to informix-list

[Doug Baroter]

Thanks. I'll try Merant driver first since they're available now, if
it fails or not to satisfactory, then try the ones in the order you
listed.

BTW, could you do a quick run-down on a generic quick, dirty search
component that I developed (for non-trasactional database), this is a
basic version,
[url]http://68.32.61.40/datadata/ddSearch.cfm[/url]
(available most of time)

Thanks.

"Jack A" <jacka8@excite.com> wrote in message news:<878b26ce7870b91c3ea22db0cd507249@news.terane ws.com>...

> DataDirect has good ODBC drivers. I have used them. Merant ODBC drivers are
> also good. I've used them too. Intersolv is another company you can try.
> They're in the ODBC business too.
>
> "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> news:fc254714.0308251807.64d0c39f@posting.google.c om...

> > Searched MS site did not yield anyting meaningful. Do you happen to
> > know any other company that has reliable ODBC driver to connect to
> > Informix? I know my system has ODBC driver for Informix from Merant
> > (version 3.7), I can't tested it now, have you ever used it, any good?
> > Thanks.
> >
> > "Jack A" <jacka8@excite.com> wrote in message

> news:<6f4b8212ac95991e6d6c618bb760a89c@news.terane ws.com>...

> > > Why dont you use DTS available in Sql Server ? Get the ODBC driver for
> > > Informix from Microsoft or some one else. Set up a DTS package using
> > > Informix as the Source and MS Sql Server as the target. Once you set up

> the

> > > DTS it will migrate all the data for you.
> > >
> > > "Doug Baroter" <qwert12345@boxfrog.com> wrote in message
> > > news:fc254714.0308251240.6768915a@posting.google.c om...
> > > > Hi,
> > > >
> > > > My client has an Informix SE database on Windows Platform (NT). How
> > > > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > > > someone mentioned about setting up i-connect driver, however, I
> > > > couldn't find such as a driver from IBM web site to download.
> > > >
> > > > Thanks.

[Doug Baroter]

Thanks for the road map. Well, when you say SDK, who's SDK?
quality-wise, all ODBC driver companys' product(SDK) is about the
same? Secondly, other folks did not mention that IConnect is
necessary, that's the relation between IConnect and an ODBC driver for
Informix?

"Murray Wood \(IList\)" <ifxmaillist@quanta.co.nz> wrote in message news:<biej75$9nu$1@terabinaries.xmission.com>...

> You need some ODBC drivers. They are part of SDK which is free.
> Download install SDK and configure IConnect, then configure an ODBC driver.
> Use the DTS wizard to migrate the data.
>
> MW
>

> > -----Original Message-----
> > From: [email]owner-informix-list@iiug.org[/email]
> > [mailto:owner-informix-list@iiug.org]On Behalf Of Doug Baroter
> > Sent: Tuesday, 26 August 2003 8:40 a.m.
> > To: [email]informix-list@iiug.org[/email]
> > Subject: How to export an Informix db to MS SQL Server 2000?
> >
> >
> > Hi,
> >
> > My client has an Informix SE database on Windows Platform (NT). How
> > do I export such a db to MS SQL Server 2000? I've searched this NG,
> > someone mentioned about setting up i-connect driver, however, I
> > couldn't find such as a driver from IBM web site to download.
> >
> > Thanks.

> sending to informix-list

[Doug Baroter]

Folks,

As it turns out, it's actually something called UniData RDMBS, version
5.2.
Since Informix has bought the company that owned UniData, the package
is shipped by Informix, so, the client thought it's Informix database.

Now, the first thing I'd like to do is to get to know the data schema,
any way to generate an ERD type of thing with it?

Thanks.

Jean Sagi <jeansagi@myrealbox.com> wrote in message news:<bijq33$vnl$1@terabinaries.xmission.com>...

> ;)
>
> Chucho is a nick for Jesus, my real name (That's common in my country :
> Colombia).
>
> It's just like bart is for Bartholomeo.
>
>
> Chucho!
>
> PD:
> ... well some time ago I read in a spanish dictionary that Chucho is a
> dog of very bad fleas! :) :) ...
>
>
>
> Jack A wrote:

> > Just curious. What does the "chucho!" at the end of your post mean ?
> >
> > "Jean Sagi" <jeansagi@myrealbox.com> wrote in message...

>
> --
>
>
> Atte,
>
>
> Jesús Antonio Santos Giraldo
> [email]jeansagi@myrealbox.com[/email]
> [email]jeansagi@netscape.net[/email]
>
>
> sending to informix-list