MSSQL backup & restore using script.sql

MSSQL has the function called backup & restore, which is useful. It works fine between different versions.

But, if you need to restore from script.sql, you can do it on command line.

sqlcmd -S <server> -i C:\<your file here>.sql -o

Full explanation : Link 

and Sometimes connection string can be tricky.

You can get full help from here.