Just as you would expect, it offers ER diagramming capabilities for entities/objects and the ability to filter as needed. Navicat Premium also contains a data modeling component that can be used for reverse-engineering, forward-engineering and generating scripts for database design. And the target database can be on the same server as the source or on another server altogether.īut let’s back up a minute. You can use Navicat to compare and modify database structures and synchronize the data structures and the data itself across disparate environments. If you have multiple instances that need to be the same, it is easy for them to becomes corrupted somehow, missing a table or containing different data. Navicat aids DBAs managing in complex setups. You can use it to create, modify, and manage all of your database objects (e.g., tables, views, etc.) and the Table Designer feature can be used to guide you as you create and modify tables, allowing you to set up relationships, constraints, triggers, and more. ![]() Okay, so what can Navicat do for you as a DBA? Quite a lot, it turns out. And you can use Navicat on the most popular operating systems including Windows, Mac OSX, Linux, and even as an iOS app. I wish they supported IBM DB2, as well, but no DB2 support is available. Furthermore, it can be used for heterogeneous database administration as it supports managing databases in MySQL, MariaDB, Microsoft SQL Server, Oracle, PostgreSQL, and SQLite. Navicat offers a very functional and easy-to-use interface for a lot of the most common and regularly occurring DBA tasks and requirements. And I’d like to share my findings with you. As a DBA myself, this piqued my curiosity, so I took some time install and learn Navicat Premium. ![]() ![]() Every year, Database Trends and Applications magazine conducts its Readers’ Choice Awards and this year the winner for best DBA solution was Navicat.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |