4sskick/SQL import large file.md

Last active August 18, 2025 06:29

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/4sskick/72fb887830fe0e6debabcf54aadbf624.js"></script>
Save 4sskick/72fb887830fe0e6debabcf54aadbf624 to your computer and use it in GitHub Desktop.

import large file SQL

Raw

I have SQL file with size 16GB, but can't import directly using SQL server management tools. So sqlcmd is the saviour!! simply just run the command with following format

sqlcmd -S ‘your server name’ -U ‘user name of server’ -P ‘password of server’ -d ‘db name’-i ‘script.sql’ -a 32767

in may case would be

sqlcmd -S ID0199-PC -d RSPIData -i ‘script.sql’ -a 32767

I am not set the U and P becauseI use the windoes auth

but another option using another strategy like this one, https://dba.stackexchange.com/a/54460 p.s: I am not tested that one btw

4sskick/SQL import large file.md

Select an option

No results found

Select an option

No results found