How to run large sql scripts

I have used SQL management studio and it takes too much time for heavy sql script. Therefore i moved to sqlcmd, here the quick example.


sqlcmd -S yoursavername -d yourdatabase -i sqlfileandlocation -U username -P password

There is no build provider registered for the extension '.asp'

I simply put <buildProviders> <add extension=".asp" type="System.Web.Compilation.PageBuildProvider"/></buildProviders> to web config file. Working perfectly.