dbForge Team posts

MySQL primary key: CREATE and ALTER TABLE statements

Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for Data Quality and proper relational database design. In this tutorial, we provide background information on Primary Keys and their function as well as give code examples to illustrate the theory.

(more…)

Top 10 Reasons Why Users Choose dbForge Studio for MySQL

The overwhelming popularity of MySQL means that people need convenient tools to work with it. Software providers compete to produce the best MySQL client. However, the goal is not to develop a ton of options and thrust them all into one solution. It is to make a complete product that would match any user’s needs and suit both the basic operations and the most sophisticated and challenging tasks.

(more…)

New Git client is implemented in dbForge Source Control v2.2

We are thrilled to announce that a new version of  Source Control – our advanced SSMS add-in for SQL Server database change management – has been released. The most notable feature of this release is the support for a new Git client – Git for Windows.

(more…)

Data export from Amazon RDS MySQL instance

The necessity to export data from Amazon RDS to the on-premises MySQL database may be spawned by various reasons such as a user request, an upgrade to a system, data consolidation, need for back up, etc. The fact that data are usually required yesterday and export tasks need to be repeated again and again only compounds the difficulty. This article presents a walkthrough on how to export data quickly and easily with the help of dbForge Studio for MySQL.

(more…)

Import MySQL data to Amazon RDS

Importing and exporting data are common tasks involved with administering databases. Migrating data between on-premises and cloud databases can be frustrating especially if the jobs need to be repeated again and again. In this article, we provide a comprehensive step-by-step guide to getting data in Amazon RDS with the help of dbForge Studio for MySQL.

(more…)

Connectivity to Oracle 20c is supported in dbForge for Oracle tools

We are glad to inform our Oracle users, that the new versions of dbForge for Oracle tools have been just released.

(more…)

How to convert MySQL data to PostgreSQL

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

(more…)

How to import and export CSV files into a PostgreSQL database

CSV files provide a great way to collect and store data, and they are often used as a reliable way to move table data between servers. In this article, we’ll look at two ways of importing and exporting PostgreSQL tables from and to CSV files – using the built-in import and export functionality of dbForge Studio for PostgreSQL and using the COPY command.

(more…)

Meet new Standard edition of SQL Tools

We are delighted to announce the release of the brand new Standard Edition of our SQL Server mega tool pack, dbForge SQL Tools.

(more…)

Take full advantage of SQL Server 2019 with SQL Complete v6.5

The dbForge team is delighted to announce a fresh release of our advanced solution for SQL database development – SQL Complete. The new version 6.5 is packed with improvements and the major one is full support for SQL Server 2019.

(more…)