Well, I don't think it is the right tool for such tables. It runs out of memory because for performance reasons it loads the entire table into memory then flushes it to disk. I would say that it is a good and fast tool for tables having 200K rows or less.
Why don't you use BCP OUT or DTS packages which are designed for data import/export and can handle virtually any volume. Here is the link to page that describes how to schedule SQL Server DTS package using 24x7 http://www.softtreetech.com/24x7/archive/40.htm : I am running version 3.4.24 and I have problems with
: databaseexport from a MSSQL7. I want to export some
: tables into .csv or .txt format but the 24x7 Scheduler
: crashes every time. ("Without memory")
: It works fine with smaller tables but when I try to
: export a table with over 2 miljons of rows then the
: 24x7 will crash. No messages in log
|
