How to import large Microsoft SQL file
2 min readOct 2, 2020
Have you experience receiving a large Microsoft SQL file that needs to be imported to your Microsoft SQL Server Database? I personally received 4GB!
Then, when trying to open in popular editor like Notepad++ or Visual Code it throws the error saying File is too big to be opened by Notepad++ or Unable to open?
Follow along to resolve this problem
Use the following command, by replacing what’s on the quote with your scenario
sqlcmd -S ‘your server name’ -U ‘user name of server’ -P ‘password of server’ -d ‘db name’-i ‘script.sql’ -a 32767
where your server name will be:
where script.sql will be:
where db name will be:
The complete command will look like below
NOTE: Remove the quotes on the value parameters
