SQLTeam.com | Weblogs | Forums

Execution of large size sql file

Hi,
Have an sql query to update a huge number of records in a table. The problem causing is the .sql file get stuck
when opened in sql browser. Saw a commandline solution to execute the sql file, would like to know if there
is any alternative like sql command to execute the large size .sql file?

try using command line - sqlcmd

What on Earth is in the .SQL file? Is it a whole bunch of INSERT/SELECT commands? If not, what is it?

commandline is working.but when it comes to staging server,we dont have access there.Hence,looking for an option to run from the sqlbrowser

yes, a large size file with a huge number of sql statement

Is it run on schedule or will it be run once only. Why is it so big and what does it do

hi

one idea is to SPLIT the large into smaller size files
and run each one of them INDIVIDUALLY ..

Example .. Huge File Size 100 MB ... split into 10 Files of 10 MB ( 1 2 3 4 5 6 7 8 9 10 )
run each one individually .. first 1 .. once 1 is over 2 .. once 2 is over 3 .. till 10

++++++++++++++++++++++++++++++++++++++++++++
Please google search .. LOTS of file splitters available

Online file Splitter

of if you want to download and install

Please be specific. What kind of SQL Statements? Very specfically, are they INSERT/SELECT statements or what?

And there's no need to download file splitters, etc, etc. It can be done pretty easily in PowerShell but we need to know what the file contains because just splitting the file into pieces might not be what is necessary.

Further to this - how is this file generated? Do you have access to the method for generating the file - or to the group providing the data?

It would be a whole lot easier if you received the data only - and not any SQL statements. Then - you could use any number of utilities to load the data to a staging table and update/insert as needed.

this is very telling ^^^