It can connect you to local/remote server, providing several utilities such as SQL editors, import/export, dump/execute SQL scripts and Server Monitor to facilitate the process of data maintenance. If you need to administer all the above database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple database servers within one single application. To backup your database/schema/table (s), control-click it and select Dump SQL File -> Structure + Data or Structure Only from the pop-up menu. Currently, Navicat Essentials is available for MySQL, SQL Server, PostgreSQL, Oracle and SQLite databases. Dump SQL File/Execute SQL File Navicat allows you to backup and restore your database/schema/table (s) using the Dump SQL File and Execute SQL File features. Navicat Essentials is for commercial use. It supports the latest features including Trigger, Function, View, and it also comes with an Import/Export tool which allow user to import and export data from plain text file formats including TXT, CSV and XML.
Support Trend Line for several chart types.Īllow skip preview of changes in data sync.Navicat Premium Essentials is a compact version of Navicat which provides basic and necessary features you will need to perform simple administration on a database. You can now dump the table with mysqldump. First option is not optimal at all but it's easy to implement: CREATE TABLE mytable AS SELECT FROM myview. Write a lot of code to analyse the view and underlying tables and generate the appropriate SQL. Navicat Essentials is available for three platforms - Microsoft Windows, OS X and Linux. Create an actual table, dump it and remove it afterwards.
Or try this query, that will give you a more accurate disk usage number, than looking at disk usage on your hard drive.
If you want to run some sort of integrity test on your database, you can count the rows in each table and compare them. Currently, Navicat Essentials is available for MySQL, SQL Server, PostgreSQL, Oracle and SQLite databases. Stuff like indexes will also take up disk space but not be included in the dump. Navicat Premium Essentials is a compact version of Navicat which provides basic and necessary features you will need to perform simple administration on a database.
0 kommentar(er)
