Navicat Premium is a database management tool that is a management tool for multi-connection repositories. can be converted to Navicat for MySQL, Navicat for Oracle, Navicat for PostgreSQL, Navicat for SQLite, Navicat for SQL Server, and Navicat for MariaDB the database has a saved batch job to Navicat Premium, what are the options for Navicat premium batch job conversion?
Right-click in the list of Plan objects and select batch job conversion from the pop-up menu.
On Vista or above, users can select all or one of the batch jobs from the Select All button.
Navicat Premium Batch Jobs
Delete the original batch job
If you want to delete the original batch job in Navicat, you can choose to tick this option. If the original batch job has been deleted, the plan will not run again unless it is set again in Navicat Premium or the original application.
Overwrite an existing batch job
If you want to overwrite an existing batch job with Navicat Premium, you can choose to tick this option.
Add when a batch job exists
If you want Navicat Premium to add detailed data to an existing batch job, you can choose to tick this option and enter the name of an existing batch job. Click the Start button to start the import process.
Dump the SQL file or run the SQL file
Navicat use the dump SQL file and run SQL Files feature to restore the database, schema, or table.
Back up the database, schema, or table, right-click and select Dump SQL file--structure and data or structure from the pop-up menu.
To restore the database or schema or table or run the SQL file, right-click and choose Run SQL file from the pop-up menu.
Tip: You can drag a. sql file to a list of table objects or to a table or schema in the connection tree, and Navicat will pop up the Run SQL File window. The Navicat batch job conversion feature is only available for Navicat Premium.
These are the Navicat Premium batch job conversion methods, if you want to learn more about the tutorial, you can focus on the "Navicat tutorial ."
The above is reproduced content, original: http://www.formysql.com/jiqiao/jihua-zhuanhuan.html
Navicat Premium batch job conversion what are the methods