Home » Softwares » SQL Server Management Studio » How to execute a huge SQL file with Microsoft Sql Server

How to execute a huge SQL file with Microsoft Sql Server

Here is a small article that could be more a note than something else. If you have a lot of SQL statement to execute, let say few gigs of statement, this won’t load into SQL Server Manager. What you can do is to use the sqlcmd command. Open a DOS console and go where you have installed Sql Server Mananger. Mine is:

c:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn

In the console, you need to specify the server and instance you want to execute the file to. Optionnaly, you can write the output to a file.

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

That’s it. Nothing more complicated.

If you like my article, think to buy my annual book, professionally edited by a proofreader. directly from me or on Amazon. I also wrote a TypeScript book called Holistic TypeScript

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.