How to load database from MS Sql file?

Question

SQL

How to upload a file to ms sql via management studio? Are there commands in sqlcmd?

Answer 1

sqlcmd -S <server> -i C:\<your file here>.sql
if you're using a SQL instance the syntax is:
and in studio open and execute.
or restore a backup