ansaurus

Question

Answer 1

+9 A:

use the sqlcmd tool to execute the file..

sqlcmd -S myServer\instanceName -i C:\myScript.sql

Gulzar 2008-10-21 16:09:07

Using this method I get the error "Sqlcmd: Error: Scripting error." Is this to do with the size of the file?

tags2k 2008-10-21 16:16:34

first check on the connectivity. maybe you have to pass username and password (-U -P options). can you also try with a smaller file. I have ran huge scripts without any issues.

Gulzar 2008-10-21 16:18:34

If I take out all but 15 INSERT statements, it works. If I put the other 1,410,472 statements back in it fails with that error message.

tags2k 2008-10-21 16:27:01

Are all these statements inside a transaction? maybe it is timing out. try setting the timeout to 0 (infinite) before you run this.

Gulzar 2008-10-21 16:32:26

i am also bit curious to know what text editor are you using for editing that file :)

Gulzar 2008-10-21 16:34:14

I'm not at work just now so I will let you know the result tomorrow, thanks for your help so far. By the way I'm just using Textpad and a bit of patience :)

tags2k 2008-10-21 18:36:42

there is some acivity going on here to discuss large file text editors http://stackoverflow.com/questions/222853/notepad-replacement-for-viewing-very-large-text-files

Gulzar 2008-10-21 18:56:21

no probs. let me know the outcome. looks like you might have to go with Michael Haren's suggestion on splitting up the files.

Gulzar 2008-10-21 18:57:40

Yeah, it made no difference. I'll go with Michael's file splitting solution, but thanks for your help anyway!

tags2k 2008-10-22 10:59:15

I managed to insert 400MB by the sqlcmd. Thanks, great tip!

Andersson 2010-03-19 15:34:56

Answer 2

+1 A:

Running something that large inside a single transaction is not a good idea. Therefore, I'd recommend breaking up the file into smaller, more manageable chunks.

Another option is to look at some of the other ways to import CSV data directly.

Michael Haren 2008-10-21 16:10:28

Answer 3

A:

Why not just use DTS to import the CSV file directly?

Aheho 2008-10-21 18:02:17

A bunch of processing needs to be done on the data first, which I don't want running on the live server. Therefore, I need to be able to process the data into a simple SQL script to minimize the work required by that box.

tags2k 2008-10-22 10:58:35

Answer 4

A:

I Second Gulzar's comment - i just imported a 400mb .sql scripts using sqlcmd without a hitch - worked brilliantly when nothing else would.

The above usage along with Microsoft Database Publishin Wizard works a treat when desperately trying to move something with only script and cmd promptaccess.

Doug 2009-09-25 05:13:57

Answer 5

A:

Thanks Gulzar, I just used your method to restore 600MB sql DB file.

Alex Ferdinansyah 2010-01-12 07:01:57

this answer should be a comment

jcollum 2010-02-16 21:22:15

Answer 6

A:

Thanks, I loaded the 2.2 GB script.

Dhillon 2010-06-25 10:52:19

ansaurus

tags:

views:

answers:

SQL Server - Running large script files

related questions