How to Create New Oracle Database in 4 Different Ways

This article will describe the steps to create a database in Oracle: from the first preparation activities to using the Oracle CREATE DATABASE syntax. Here, you will find four ways to create a database in Oracle step by step. Two of them will be based on the command line: using the CREATE DATABASE command, as well as generating the CREATE DATABASE script from an existing DB. The other two will describe how to use such GUI utilities as DBCA, and Oracle SQL Developer. This tutorial is relevant for Oracle versions 12c, 11g, 10g, and higher.

Read the rest of this entry »

Relationships in SQL – Complete Guide With Examples

In this article, we are about to take a close look at the SQL Server relations, including one-to-one, many-to-many, and many-to-one relations, and get into details of creating those with the help of dbForge Studio for SQL Server.

Read the rest of this entry »

Different Ways to Back up MySQL Databases and Tables

The article provides an overview of the backup types available in MySQL and describes how-to examples of using the mysqldump command-line utility to take a backup of the database, tables, data, or schema and to restore the MySQL database.

Read the rest of this entry »

Review SQL Complete on GetApp!

Enjoying dbForge SQL Complete? Why not share your opinion in a review?

This would take just a few minutes of your time yet would be very important to us.

Read the rest of this entry »

Update Entity Developer and Related ADO.NET Providers to Prevent Errors with Opening Models

Important information for all Entity Developer users on Windows 10 and Windows 11, both as a separate product and included into other products: dotConnect providers with ORM support and LinqConnect.

Read the rest of this entry »

Update Your dbForge Tools to Prevent Diagram Control Errors

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.

Read the rest of this entry »

Software Development Life Cycle Tutorial with Examples

SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices. 

Read the rest of this entry »

dbForge Product Line Is Ready for Windows 11

Following our recent announcement that dbForge tools for SQL Server were updated and tested for seamless work on Windows 11, we hurry to make the same statement regarding our tools for MySQL, Oracle, and PostgreSQL databases. Now the entire dbForge product line is ready to accompany your database development and administration on the latest Windows OS.

Read the rest of this entry »

Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool

Studio for PostgreSQL 2020 v2.3

This article will be useful for those who have already installed PostgreSQL on their personal computer. In case you still haven’t, this blog post will come in handy. Now, we will focus on some of the most popular ways of accessing the PostgreSQL database on Windows. We will describe the PostgreSQL connection options using psql, pgAdmin, and fast and convenient dbForge Studio for PostgreSQL by Devart. Moreover, here you will find the instructions on connecting to local and remote PostgreSQL servers.

Read the rest of this entry »

Delphi DAC for Firebird 4: Using the new INT128, DECFLOAT, and large NUMERIC types

Delphi DAC for Firebird 4

This article describes how to work with Firebird 4 in Delphi data access components. The latest version of IBDAC and UniDAC supports Firebird 4 and the new data types: INT128, DECFLOAT, and NUMERIC.

Read the rest of this entry »