What is an easy way to export a database from SQL Server, including all tables and data to file.sql file?

I am using SQL Server [s] 2008 R2 [Express].

I would like to create an .sql installation file for an example database.

In file.sql, I mean the file that will be launched from Microsoft SQL Server Management Studio as a query.

I would like to have one file, including the database itself and all tables and data.

How can I export the entire database to such a file?

PS

This is a very small database.

I am not worried about duplicating the database name on the new server.

The data has Unicode characters and many special characters, including {[(<`., '|"? * & / ">)]}

+3
source share
2 answers

>

, "Script "

script = > " " ( )

.

:

Management Studio, Backup and Recovery!

+7

, ( 1000 ), = lt; = 1000 . .

, , . FK , .

0

All Articles