Ron Moore
rmoore at comtechpst.com
Tue Feb 4 14:12:00 CST 2003
Stephen, I probably should not have mentioned Informix! (see my other posts) Without a viable ODBC driver for our legacy system, my source data will be txt and/or xls files. I chose A2K, since I'm already familiar with those. The learning curve seemed too high for DTS scripts/BCP and 'massaging' the data in SQL. My real concern at this point is, does using A2K with an ODBC connection doom me to this kind of slow response? If so I may have to 'bite the bullet' and use DTS/BCP, etc. Thanks, Ron -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Stephen Hait Sent: Tuesday, February 04, 2003 2:57 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!: > I'm migrating/converting data from an Informix DB to a SQLServer2K > app using A2K as the middleware. The final append query selects > records from a buffer table and inserts them into a SQL table > through an ODBC connection. The push of the largest table takes > almost 5 HOURS! :-(((( The Windows Task Manager shows A2K and the > specific DB 'toggling' between 'Running' and 'Not Responding', but > the process does finish. > Do I have to live with this lack of speed? This is for a pilot > which will be built from 'scratch' MANY times before it goes to > production. If you're transferring data from Informix to SQL2K, couldn't you use the DTS tools in SQL2K to transform this directly from Informix? Why do you need A2K involved in this? Another way might be to export the data from Informix to a text file that you could import into SQL2K with BCP. Is that an option? Stephen _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com