SQLTools 1.4.1 Available for: windows mac linux unix java The user can also view or extract reports for offline viewing using a web browser.

Navicat provides a Report Viewer that allows trial testing of queries and a SQL pad for query development as well as a visual query builder. It enables exporting in many formats, allows automating these processes and does the same for importing data. It can extract SQL from a database backup or just dump the data to a file. Backups and data transfers are another concern and Navicat allows the user to schedule them across multiple servers. Navicat's review of server status and process list are in real time and includes auto-refresh for tracking and troubleshooting. SSH tunneling and SSL connections support ensures security for administrators. It allows access to multiple connections and their configuration in the style of Windows cascading. Features include Unicode support, wizards for importing and exporting, batch job scheduling, data transfer and synchronization, and Visual report and query builders.Īdministrators need control, performance measurement and recover components that Navicat does quite well. Please accept as answer and upvote if the above information is helpful for the benefit of the community.Navicat is a database management tool that lets users manage multiple databases on remote servers as well as local. You can go to the next section on how to configure the firewall.įor more information about using SQL Server 2017 Linux virtual machines, see Overview of SQL Server 2017 virtual machines on Azure.

Note: If you selected the inbound port MS SQL (1433) in the settings during provisioning, these changes have been already made for you. The rule allows traffic on the port on which SQL Server listens (default of 1433). The above image is referenced for managed SQL DB though, assuming it will be same for the SQL server instance on azure VM.įirstly, if you need to remotely connect to SQL Server on the Azure VM, you must configure an inbound rule on the network security group. As per this article, I see Navicat console, kind of establishes a connection with SQL instance somewhat similar to SQL management studio.

I see Navicat is a Graphical database management and development software and you intend to allow remote access to the SQL instance on azure Vm to facilitate administrative tasks. Thank you for reaching out to the Microsoft Q&A platform.

Navicat for linux ubuntu