Out of memory exception when running data-only script

Question

When I run data-only script in SQL Server 2008 R2, it is showing this error:

Cannot execute script
Additional information:
Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

The size of script file is 115MB and it's only data .

When I open this script file, it shows:

Document contains one or more extremely long lines of text.  
These lines cause the editor to respond slowly when you open the file .  
Do you still want to open the file ?

I run schema-only script first and then data-only script .

Is there any way to fix this error ?

Possible duplicate of [Cannot execute script: Insufficient memory to continue the execution of the program](https://stackoverflow.com/questions/17918770/cannot-execute-script-insufficient-memory-to-continue-the-execution-of-the-prog) — A-Sharabiani, Dec 27 '17 at 16:37

score 13 · Accepted Answer · edited May 23 '14 at 03:42

13

I solved it by using sqlcmd utitlity.

sqlcmd -S "Server\InstanceName" -U "instantName" -P "password" -i FilePathForScriptFile

For example :

sqlcmd -S .\SQLEXPRESS -U sa -P 123 -i D:\myScript.sql

edited May 23 '14 at 03:42

naveen

53,448
46
161
251

answered Jul 10 '13 at 08:28

zey

5,939
14
56
110

score 1 · Answer 2 · answered Jan 03 '17 at 10:04

Zey's answer was helpful for me, but for completion:

If you want to use Windows Authentication just omit the user and password.

And don't forget the quotes before and after the path if you have spaces.

sqlcmd -S .\SQLEXPRESS -i "C:\Users\Stack Overflow\Desktop\script.sql"

score 0 · Answer 3 · answered Jan 11 '19 at 21:49

0

If you're logged into the domain with the correct privileges and there's only one instance running, you also do not have to provide the above user/pw/instance command args. I was able to just execute:

sqlcmd -i myfile.sql

answered Jan 11 '19 at 21:49

rigoo44

95
1
8

Out of memory exception when running data-only script

3 Answers3