Navicat Blog

Managing Databases Remotely Using Navicat - Part II Apr 22, 2020 by Robert Gravelle

Part II: Navicat Cloud and Team Collaboration

As the Covid-19 pandemic wears on, organizations that can support working from home have continued to remain productive while maintaining physical distancing. In last blog we learned how to access sensitive work data by establishing a secure connection to a remote database via Navicat Premium 15. Today's follow-up will introduce Navicat Cloud, an add-on feature inside Navicat Development and Administration products for collaborating with team members from across town to around the globe.

Managing Databases Remotely Using Navicat Apr 7, 2020 by Robert Gravelle

Part 1: Connecting to a Remote Database Instance

Remote work has been on the rise for some time now. Today, for those organizations still operating during the Covid-19 pandemic, it has become a necessity. Luckily, popular database systems (DBMS) have long supported remote connections. Likewise, Navicat's database development and administration products are also well equipped to access databases remotely. In today's blog we'll learn how to establish a secure connection to a remote database instance using Navicat Premium 15.

Database Structure Synchronization using Navicat 15 Mar 11, 2020 by Robert Gravelle

Perform an Internet search for "database synchronization" and you're likely to receive a lot of information on synchronizing database data. Meanwhile, instructions on synchronizing database schema structure is less prevalent. There is an inherent risk of destroying existing data that comes with altering the database structure. For that reason, you have to be extra careful when doing so.

Navicat can be a tremendous ally in synchronizing database structures. In today's blog, we'll learn how to use Navicat Premium 15's Structure Synchronization wizard to update one database's schema structure to match that of another.

The NULL Value and its Purpose in Relational Database Systems Mar 3, 2020 by Robert Gravelle

In databases, the NULL value is one that has a very particular meaning. Thus, it is important to understand that a NULL value is different than a zero value or a field that contains spaces. In today's blog, we'll explore what the NULL value means and how to work with NULLs in Navicat Premium.

Choosing Between VARCHAR and TEXT in MySQL Feb 19, 2020 by Robert Gravelle

One of the changes in MySQL version 5.0.3 included an increase to the maximum length of VARCHAR fields from 255 to 65,535 characters. That made the VARCHAR type more similar to TEXT than ever before. For those of us who design database tables, choosing between VARCHAR and TEXT now became more challenging as a result. In today's blog, we'll outline the key differences between the two and layout the factors to consider when deciding which data type to go with.

Navicat Blogs
Feed Entries
Blog Archives