SQL Server database table Architecture and Data are saved as SQL files

Mysql database users may often export database files as SQL files, but can SQL Server export SQL files? The answer is yes. Let's take a look at the following steps.

Mysql database users may often export database files as SQL files, but can SQL Server export SQL files? The answer is yes. Let's take a look at the following steps.

1. Click database> task> Generate script in your mssql database"

2. Then we will see the next step in the "Generate and release scripts" window.

3. Select the database object for script writing and select the first one for all export. If you want to export some data, check the second one.

4. Click the "advanced" button that appears.

5. Finally, the "Data Type of the script to be written" corresponds to "Architecture and Data", and the export is successful.

Reminder

I use SQLServer2008 here. Other versions should be similar.