Use Navicat Premium to export SQLServer data to the SQL format, navicatsqlserver
In fact, it is very easy to export MSSQL database data to. SQL format files. Microsoft SQL Server 2008 already has this function. For details, refer to this article. Today, I want to use a powerful database management tool to remotely export SQL scripts. The operation is very simple.
Navicat Premium
- Navicat for SQL Server 32-bit
- Navicat for SQL Server 64-bit
Use Navicat Premium to remotely connect to your SQL Server database. After the connection is successful, you will see all the SQL Server databases. Select the name of the database you want to export, right-click and choose data transmission ";
Click the "advanced" menu and set it as follows;
After the configuration is complete, select start backup. A progress will be displayed, and the backup will be closed after completion;
After the backup is successful, you can find the exported database file suffixed with. SQL in the target path.