Import a .SQL script using OSQL

untuk hasil export script .sql MS SQL Server yang berukuran besar dan tidak dapat diproses import oleh sql management studio, dapat menggunakan osql untuk mengimport nya :

osql -U YourUserName -P YourPassword -S ServerName -d DatabaseName -n-1 -i DriveLetter:SQLFileNameAndPath.sql -o DriveLetter:LogFile.txt

Switches
-U: login ID for the specified server
-P: password for the login ID
-S: server name
-d: database upon which the script will be executed
-n: removes numbering and the prompt symbol (>) from the output file
-i: the .SQL file name (including drive letter)
-o: an output file that details how the script executed (if at all)

(http://metrix.fcny.org/wiki/display/dev/How+to+execute+a+.SQL+script+using+OSQL)

Comments

Leave a Reply