How to export the schema and the data of an MSSQL-DB into an .sql script
One way to make a back-up file of your MSSQL Database is by exporting its schema, and optionally its data, into a new .sql script. The script can be automatically generated via the MSSQL Management Studio tool. Here is how:
Read the complete article