Page 1 of 1

dumping large amounts of data from sql server to a text file

Posted: Tue 01 Feb 2005 16:44
by alchemy9
what is the best way to extact a lot of data from sql server to a text file,
(10's of millions of rows),

the sql query will be along the lines of select * from atable

Posted: Wed 02 Feb 2005 08:55
by Ikar
Use TMSTable or TMSQuery with FetchAll := False and Unidirectional := True.
Also you can use ReadOnly := True (it may give a little impact on performance)