Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transferring data to SQL Server 2000

Status
Not open for further replies.
TomBarrand

TomBarrand

Programmer
Aug 9, 2000
162
GB
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
 
Sort by date Sort by votes
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.
Regards,

Ed
Schaefer
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tuccero
  • Locked
  • Question
onstat -g ses returns "Changing data structure forced command termination"
Replies
1
Views
158
tuccero
tuccero
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
118
jamescpp
jamescpp
welcome07
  • Locked
  • Question
What should Be Sequence of Installing IDS in DEV Server.
Replies
0
Views
93
welcome07
welcome07
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
138
arunkumar.ceg
arunkumar.ceg
cwbloucks
  • Locked
  • Question
Informix SQL Update using an inner join
Replies
0
Views
155
cwbloucks
cwbloucks

Part and Inventory Search

Sponsor

Back
Top