dbForge Team posts

New version of dbForge Source Control for SQL Server released

We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL Server, v2.1, has been just rolled out!

(more…)

MySQL Minitools 9.0 Release

We are very glad to tell you about the release of dbForge Minitools 9.0 for MySQL.

The tools comprising the release got new great features such as script folder comparison for Schema Compare and Data Compare, support for new database objects types, an ability to configure default values in the Data Synchronization wizard, and many more updates and fixes.

(more…)

How to Create Tables using MySQL CREATE TABLE Statement and via GUI Tool for MySQL

There are two main ways of creating tables in MySQL databases:

(more…)

Discover new dbForge Studio for MySQL 9.0 hugely packed with new stuff

We are excited to announce that the new version of our MySQL IDE, dbForge Studio for MySQL, v9.0, has been just rolled out!

(more…)

How to create a many-to-many relationship

Establishing a many-to-many relationship between the tables in a database is usually done for ensuring efficient data processing and data integrity, as well as for database normalization and data analysis tasks.

(more…)

How to view the SQL Server transaction log with SQL Transaction Log Reader Tool

Just like any information system, databases are constantly changing. Quite often you need to roll back some operations. There is undoubtedly an opportunity to restore the database to a specific point in time and you can also undo the latest transactions with both regular and third-party utilities.

(more…)

Migrating data from Oracle to PostgreSQL database

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

(more…)

Adopt flawless Continuous Integration into Bamboo with new dbForge DevOps plugin

We are glad to inform our SQL Server users that we have just extended the compatibility of dbForge DevOps Automation for SQL Server with just-released dbForge DevOps Automation Bamboo Plugin for SQL Server.

(more…)

How to write complex MySQL queries?

Advanced queries aimed to solve complex tasks or multiple tasks constitute an essential part of any database administrator or developer job. MySQL complex queries must be handled with the utmost seriousness since inaccurate MySQL code or poorly performing scripts can cause severe bugs and application failures. 

(more…)

Pivot Tables in PostgreSQL

A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored in random order. By running a query to select data from a database table, you can perform filtering, sorting, grouping, selection and other operations with data.

(more…)