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.