Use NAVICAT premium to export SQL Server data to SQL format _mssql2008

In fact, to export the MSSQL database data to a. sql format file is simple, Microsoft's SQL Server 2008 already has this feature can be viewed in detail in this article. Today I would like to use a powerful database management tool to remotely export SQL scripts, the operation is extremely simple.

Navicat Premium Download Address

• Navicat for SQL Server 32-bit
• Navicat for SQL Server 64-bit

Connect to your SQL Server database remotely using the NAVICAT Premium tool; When the connection is successful, you will see all the SQL Server databases; Select the name of the database you want to export and right click on "Data Transfer";

Click on the "Advanced" menu, set as follows;

When the setup is complete, choose to start the backup, there will be a progress show, the completion can be closed;

After the backup succeeds, the exported database file with the. sql suffix can be found under the target path.