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.

Read the rest of this entry »

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.

Read the rest of this entry »

Database DevOps Tools for Continuous Integration

Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including high speed of product development, good code quality, enhanced communication between team members, and increased reliability of the process.

Read the rest of this entry »

SSL and SSH Support for Direct Oracle Connections in Excel Add-ins 2.5

Devart is glad to announce the release of Excel Add-ins 2.5 with support for secure SSL and SSH connections to Oracle in the Direct mode. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSL/TLS and SSH protocols in the Direct connection mode.

Read the rest of this entry »

How to export and import JSON data via dbForge Data Pump for SQL Server

In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled the newly-created database with test data on employees.

Read the rest of this entry »

How to generate test data with the help of the SQL Data Generator Tool?

In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be very useful when we want to run some tests. The most convenient way is the population of SQL tables with random data with the help of visual data generation tools.

Read the rest of this entry »

SQL Database Design Basics with Example

It is a common practice that a DB architect has to design a relational database tailored to a particular solution.

Read the rest of this entry »

SSH Support in SSIS Components 1.14 and dotConnect for Oracle 9.12

Devart is glad to announce support of SSH connections in the Direct mode in dotConnect for Oracle 9.12 and SSIS Data Flow Components 1.14. Now you can connect both to on-premises Oracle and Oracle Database Cloud — a Database as a Service (DBaaS) solution from Oracle — via secure SSH protocol in the Direct connection mode.

Read the rest of this entry »

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.

Read the rest of this entry »

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.

Read the rest of this entry »