4sskick · July 9, 2024 07:21
diff --git a/SQL import large file b/SQL import large file
 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
	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