Open Sql Script with big size

Question

I have an SQL script file which it has big size " 1.4 GB " when I try to open it in SQL SERVER Management Studio it fails and give me message

The System can't find the file specified

when I try to open it with notepad++

file is too big to be opened by notepad++

so does it there anyway to open this script ?

You want to run it only or open it to see and work on it in SSMS? — Whencesoever, Aug 10 '16 at 07:05
You can open it in WordPad... WordPad can open files of up to dozens of GB. Won't be a pleasure though with that size. — Adwaenyth, Aug 10 '16 at 07:08
@Adwaenyth I'm trying to open it with wordpad right now i don't know how much time does it need I have been waiting about 1 min — Mahmoud Zakal, Aug 10 '16 at 07:14
User sqlcmd tool for execute the file [Check these posts.](http://stackoverflow.com/questions/222442/sql-server-running-large-script-files) — neer, Aug 10 '16 at 07:17

score 0 · Answer 1 · answered Aug 10 '16 at 07:28

0

Run this command in Command prompt by providing the required details. This command would execute the SQL file without opening the file.

sqlcmd -S <ServerName> -U <LoginUser> -P <Password> -d <DatabaseName> -i <Inputfilenamewithpath> -o <Outputfilenamewithpath>

answered Aug 10 '16 at 07:28

StackUser

what if I want to change the used database in script because when create the script the `use XXXDb` command for that DB will be in the first line – Mahmoud Zakal Aug 10 '16 at 07:43
Regenerate your SQL script without using "USE" statement Or else you should edit the Use XXXDb with your desired DBname by opening the SQL script. – StackUser Aug 10 '16 at 07:48
here's the problem that I can't find a tool can open that file to edit it otherwise i have to read and edit it programmatically – Mahmoud Zakal Aug 10 '16 at 07:51
You said you cannot open that file then how do you say that file has Use statement.... – StackUser Aug 10 '16 at 07:53
because when I create an Sqlscript in management studio the use statement will be in the first line – Mahmoud Zakal Aug 10 '16 at 08:08
Regenerate your script by disabling the option "Script USE DATABASE" to False. You can find this option in Advanced button. – StackUser Aug 10 '16 at 08:55

1 Answers1