Wednesday, 2 May 2018

Run Large(eg: 10gb) script file in MS SQL database


Import/Run large(eg: 10gb) script file in MS SQL database using below command:

1. Open command prompt with Administrator mode
2.  sqlcmd -S ServerName -U UserID -P Password -d DataBaseName -i C:\Users\gprao\Downloads\ProjectTrac\ProjectTrac.sql