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)
Leave a Reply
You must be logged in to post a comment.