I have a command file that was generated from a legacy system, the total size of the command file is 2gb, I have timmed out with the following error: Error: cannot allocate memory for command buffer.
My command looked like this:
osql -E -S ServerName -d Databae -i C:\myfile.txt
I suspect that it is due to the file as it is 2gb, any advise?
the file has the following sql commands:
INSERT INTO "TableName" ('Value', 'Value2', 'subvalue3;subvalue4;subvalue5', 'Value6');
INSERT INTO "TableName" ('Value', 'Value12', 'subvalue13;subvalue14;subvalue15', 'Value16');
INSERT INTO "TableName" ('Value', 'Value22', 'subvalue23;subvalue24;subvalue25', 'Value26');
....up to 2gb