How to open large SQL script file and execute in SQL server?

amit sijaria

I’m working in one project where I need to execute large SQL script in SQL server, file size near about 2.5 GB. While I’m trying to open that script file in SSMS it doesn’t allow me to open that file it throws an error File is too large to open.

I have tried to open script file with another editors i.e. notepad, notepad ++ as well but getting same error. We can open large file in Glogg editor with any file size WordPad also allow same, but it will take some time.

Now question is How we can execute large SQL script? It is very sample

Open Common Promat in Admin mode and type following command and Press enter key.

sqlcmd -S \ -U -P -d -i

Example:

sqlcmd -S MyComputer-PC\MSSQLSERVER16 -U sa -P teamwork@1 -i "C:/Users/Amit /Downloads/dbScripts/script.sql"

Output:

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Juan Miller6y ago
I suggest you Long Path Tool will let you easily delete, copy or rename long path files, you can try it for better service.
Salman Beg7y ago
Hi.
To open large file and run in sql server you need to use osql,sqlcmd or ApexSql tool.
For more you can follow these links,
https://knowledgebase.apexsql.com/how-to-execute-large-sql-scripts/

http://www.ayobamiadewole.com/Blog/Running-Large-Sql-Script-in-Microsoft-Sql-Server

Thanks.
Sanwar Ranwa7y ago
Hello Amit

Check these Links

https://knowledgebase.apexsql.com/how-to-execute-large-sql-scripts/

https://www.mssqltips.com/sqlservertip/4155/executing-large-scripts-in-sql-server-management-studio-with-insufficient-memory-failures/