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 {[(<`., '|"? * & / ">)]}
source
share