unable to execute 600 mB file in sql server 2008 R2

Question

Post reply

unable to execute 600 mB file in sql server 2008 R2

supriya.gandhi 40521

SSC Rookie

Points: 34
More actions
December 9, 2013 at 2:16 am

#281004

Hi,
There exists a sql file (.sql) containing some create statements and bunch of inserts , details unknown and the size is 660 MB and needs to be run against a particular database in sql server 2008 R2. On tryingto open this file / attempts to rn this from sqlcmd /osql it gives scripting error as the error or insufficient resources as the options.
Any help to work on this file execution will be helpful.
/Supriya

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

share the complete error which is being generated while executing this file

supriya.gandhi 40521 SSC Rookie Points: 34 More actions · Answer 2

sqlcmd:Scriptting error

This is what I get on the cmd line

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 3

in our environment also , we faced the same issue. The solution we found is, we have split the files into multiple files and executed those in the same order. We preferred each file size <= 8 MB in size

Lowell SSC Guru Points: 323518 More actions · Answer 4

I've always moved CREATE statements to a single file, and INSERT statements are not insert statements at all, but actually files exported via BCP;

then i write the appropriate BCP/BULK INSERT scripts to bring the files in; the performance difference is multiple orders of magnitude faster than hundreds of megs of INSERT INTO statements; i can easily import a gigabyte of data in several minutes, and without the chances of running out of memory for the parsing of the statements.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!