Open Navicat.
Open the database where the data table is located, and all tables in the database will be displayed.
Click to select the database table to export data, right-click the mouse, and select [Export Wizard] in the pop-up menu.
Related recommendations: "Navicat for mysql graphic tutorial"
Select the SQL script file in [Export Format] (* .sql), and then click [Next].
Set the directory and file name where the exported .sql file is located, and then click [Next].
Select the exported data field range, and then click [Next].
Set additional options and click [Next].
Click [Start].
It shows that it has been successfully completed.
The above is the detailed content of How to export sql sever script file in navicat. For more information, please follow other related articles on the PHP Chinese website!