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 — A-Sharabiani
– A-Sharabiani, Commented Dec 27, 2017 at 16:37

codeandcloud · Accepted Answer · 2014-05-23 03:42:45Z

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, 2014 at 3:42

codeandcloud

55.5k47 gold badges169 silver badges259 bronze badges

answered Jul 10, 2013 at 8:28

zey

6,14315 gold badges65 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edu · Accepted Answer · 2017-01-03 10:04:03Z

1

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"

answered Jan 3, 2017 at 10:04

Edu

2,7335 gold badges35 silver badges37 bronze badges

Comments

rigoo44 · Accepted Answer · 2019-01-11 21:49:32Z

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, 2019 at 21:49

rigoo44

1051 silver badge11 bronze badges

Collectives™ on Stack Overflow

Out of memory exception when running data-only script

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related