Migrating data between heterogeneous repositories - that is to say, where the source and target databases are of different database management systems from different providers - presents several challenges. In some cases, it is possible to connect to both databases simultaneously. However, there are times that it is simply not possible. When presented with such a dilemma, database practitioners have no choice but to populate tables from a dump file. Navicat can be of great help in that process. The Import Wizard allows you to import data to tables/collections from a variety of sources, including CSV, TXT, XML, DBF and more. Moreover, you can save your settings as a profile for future use or setting automation tasks. In today's blog, we'll use the Navicat Import Wizard to migrate data from the PostgreSQL "dvdrental" database to a MySQL 8 instance using the FREE Navicat Premium Lite 17.
Navicat's database administration and development tools have long been designed with collaboration in mind. Now, thanks to the recent launch of Navicat On-Prem Server, collaboration takes center stage, allowing us to share connection settings, queries, aggregation pipelines, snippets, model workspaces, Business Intelligence (BI) workspaces and virtual group information with team members across the globe - and all in real-time. While the last several blogs described how to share database objects using Navicat On-Prem Server, today's entry will focus on how to accomplish the same thing using Navicat Premium 17.
One of the standout features of PostgreSQL is its extensive support for user-defined functions and data types. This allows developers to create custom conversion, operator, and aggregate functions. Aggregates offer a powerful way to perform complex calculations and transformations on data, going beyond the standard SQL aggregate functions like SUM, AVG, and COUNT. Both Navicat for PostgreSQL and Navicat Premium make it easy to write custom functions and aggregates that integrate seamlessly with the database, thanks to their specialized graphical user interface (GUI). All we need to do is provide a few details and Navicat produces the pgSQL statement for us! In today's blog, we'll be creating an aggregate to work with the DVD Rental database that concatenates movie titles by category.
Several recent blogs have been dedicated to Navicat's latest collaboration tool: Navicat On-Prem Server. It's an on-premise solution for hosting a cloud environment that allows you to synchronize your connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information across all your devices. In today's blog, we'll learn how to develop queries directly in On-Prem Server, and then share them with our team in real-time.
Adding Projects, Members, and Connections
In a recent blog, we learned about Navicat's latest collaboration tool: Navicat On-Prem Server. It's an on-premise solution for hosting a cloud environment where you can securely store Navicat objects internally at your location. Today's blog will cover how to work with projects in Navicat On-Prem Server. Topics covered will include how to create a project, adding members, and how to configure a connection to your database instance(s).
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
