×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Transferring data to SQL Server 2000

Transferring data to SQL Server 2000

Transferring data to SQL Server 2000

(OP)
I have an Informix 9.3 database and need to output some of the data in xml. As this does not appear possible via Informix I want to automatically transfer the data from Informix to SQL Server where I can then output it to xml.

Any ideas to do this?

Thanks

RE: Transferring data to SQL Server 2000

Tom:

In the early 90's using Window's 3.1 I used a third-part product called datajunction to move between Oracle, Informix, Sybase, and several other products.  

I haven't dealt with them in years, but you might want to check them out.  http://www.datajunction.com

Regards,

Ed
Schaefer

RE: Transferring data to SQL Server 2000

In SQL server there is a Data Transformation service, In essence it is a export and import utility. You can even schedule it to run regularly.

Install the Informix CLI client and you should have an ODBC driver for Informix.

Now in the SQL Server DTS (enterprise manager), You can create a package that "SELECT"s from the Informix server and the puts it in the SQL server.

RE: Transferring data to SQL Server 2000

(OP)
Is it possible to call the DTS? The reason I ask this is that the scenario I have means that the data in SQL Server does not need to be up-to-date as it will not be used for reporting, but when someone clicks on a button within a web page I would like to call the DTS so that it copied the data from Informix to SQL Server.

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close