Re: Extracting data from a SQL Server database

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<c78h2b$u2s7$1@ID-162943.news.uni-berlin.de>... > "Savio Pinto (s)" <spinto@cap.org> wrote in message > news:c78dfc$k1r$1@terabinaries.xmission.com... > > > > sorry, i was thinking you want to extract data from informix, anyway to > > extract data from sqlserver you can use the same approach, > > 1) create linkserver using odbc source for informix db and write dts > package > > in sqlserver to extract the data from sqlserver and load in the informix > > database > > 2) use bcp utility of sqlserver to extradct data from sqlserver > > Thanks to Savio, Rob, Venkatesh and everyone else who suggested various > options. I like the sound of the Enterprise Gateway: it's '6.5k retail here > so I guess it will come down to how much the client wants to spend on the > project .... > > regards > Neil You might want to take a look at our new product, Super*SQL. It allows you to connect to any database via JDBC and extract data into an ASCII file that can be immediately loaded into another database. The whole process can run in true "batch" mode so you can make it a scheduled process. Super*SQL will sell for $US 20 but if you want to become part of our Phase II Beta testing program you would get a copy for free. For more information visit www.sqlmagic.com.