Devart Academy - Managing Multiple Database Systems With an All-in-One Solution

Managing Multiple Database Systems With an All-In-One Solution

This course focuses on dbForge Edge, a solution that helps manage multiple databases across different systems, including Microsoft SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL. It's perfect for those who don't have time to assemble a consistent and feature-rich toolset for every system. Instead, dbForge Edge allows you to get started right away and see results from day one.

3 modules
5 lessons
24 mins

Getting acquainted with dbForge Edge

dbForge Edge is a multidatabase solution that will help you work with diverse database systems and cloud services, including SQL Server, MySQL, MariaDB, Oracle, PostgreSQL, Amazon Redshift, Azure SQL, and much more.

Installing dbForge Edge on Ubuntu using Wine

You can install and run dbForge Edge on Ubuntu using Wine, a compatibility layer capable of running Windows applications on other operating systems. Here is a detailed video tutorial that will show you how to get it up and running.

Installing dbForge Edge on Linux via CrossOver

Watch the video to see how dbForge Edge can be installed and launched on a variety of Linux distributions, including Ubuntu, Debian, and Fedora. To do that, you will need CrossOver by CodeWeavers, a viable alternative to Wine.

Installing dbForge Edge on macOS via CrossOver

If you are a Mac user, you can start working with dbForge Edge just as effortlessly. The same compatibility layer of CrossOver will help you install and run the bundle in a familiar macOS environment in the easiest possible way.

Database development and design

dbForge Edge will help you streamline your routine SQL development and database design. The key features to make it happen include coding assistance, visual query building, object editors, and source control integration.

How-to tutorials

dbForge Edge comprises four comprehensive IDEs called Studios, each focused on a specific database system: Microsoft SQL Server, MySQL/MariaDB, Oracle Database, and PostgreSQL. Although the Studios have a few differences in their respective feature sets, they are consistently designed, and you will have no trouble switching from one to another. In this section, you can explore the features of individual Studios.

The Start Page of dbForge Studio

The Start Page of dbForge Studio

Get acquainted with the Start Page, the first thing you see upon opening the Studio. It consists of tabs that provide quick access to the Studio's key features: SQL Editor, Source Control, Schema & Data Compare, Data Pump, and much more.

Connecting to a SQL Server Database

Connecting to a SQL Server database

To start working with SQL Server databases, the first thing you need to do is establish a connection to the required server. Learn how you can do it in dbForge Studio using a convenient dialog with a rich selection of settings.

Setting SQL Server Connection Categories

Setting SQL Server connection categories

It's not an uncommon case when you need to work with multiple connections and tabs simultaneously—and you need to instantly identify the connection that each tab belongs to. Learn how to make it easier for you with connection categories.

Connecting to SQL Server on Amazon RDS

Connecting to SQL Server on Amazon RDS

You can create a SQL Server database instance on Amazon Relational Database Service (RDS) and easily connect to it with dbForge Studio for SQL Server. It will take you less than two minutes to learn how it's done.

How to Convert Columns to Rows

How to convert columns to rows

UNPIVOT is a relational operator that can become your optimal solution for transposing columns into rows in SQL Server. Watch the video to see it in action alongside other features of the Studio's integrated Query Profiler.

How to Create a Many-to-Many Relationship

How to create a many-to-many relationship

A many-to-many relationship exists when multiple records in one table are linked to different records in another table. Here is a concise and informative guide that will help you handle these relationships with dbForge Studio for SQL Server.

How to Migrate a SQL Server Database

How to migrate a SQL Server database

Watch this video to discover the simplest way of migrating SQL Server databases between different environments. Learn how to use scripts folders along with database comparison and synchronization for an effective migration process.

How to Migrate a Database Using a Snapshot

How to migrate a database using a snapshot

Get acquainted with an easy and straightforward method of migrating a SQL Server database to another environment by generating a database snapshot and restoring the database using the Studio's Schema Compare functionality.

How to Copy SQL Server Schemas and Data

How to copy SQL Server schemas and data

Learn how to copy a database schema along with the stored data by generating a dump file with the Studio's Generate Scripts Wizard. To restore both the schema and data, you only need to run the said file against the target empty database.

How to Migrate a Database Between Servers

How to migrate a database between servers

Another convenient way of migrating a SQL Server database to a different server is to use the Copy Database functionality of dbForge Studio. It's very easy to use and offers a handful of flexible settings—watch the video to see it in action.

How to Migrate Data Between Databases

How to migrate data between databases

Need to migrate data from one SQL Server database to another? Here are three easy steps to do it in dbForge Studio. One, create an empty target database. Two, deploy the source schema to the said target database. Three, sync your data.

How to Detach and Attach a Database

How to detach and attach a database

dbForge Studio provides you with handy tools that will help you detach and attach your SQL Server databases when migrating them from one server instance to another. Check this video guide to learn how to do it.

How to Backup and Restore a Database

How to backup and restore a database

The importance of keeping your data safe with regular backups is indisputable. dbForge Studio will help you back up and restore SQL Server databases without coding—and conveniently automate this process from the command line.

How to Restore a Session in dbForge Studio

How to restore a session in dbForge Studio

You can configure dbForge Studio to auto-restore unsaved tabs and database files. This is how you will make sure that your work will not be lost in case the application crashes or you accidentally close the tab without saving.

How to Generate Database Documentation

How to generate database documentation

Learn how to generate comprehensive documentation for SQL Server databases, comprising a structure overview with inter-object and inter-database dependencies. The Studio's integrated Documenter will help you with that.

How to Export & Import SQL Server Data

How to export & import SQL Server data

Get acquainted with the most flexible way of exporting and importing SQL Server data with 14 most popular formats at hand, including HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.

How to Create a SQL Server Data Report

How to create a SQL Server data report

Learn how to design customizable query-based data reports within minutes using the smart Data Report Wizard of dbForge Studio. As a bonus, see how you can schedule regular delivery of your reports from the command line.

Installing MySQL on Windows

Here is your step-by-step guide to downloading and installing MySQL on your Windows machine. See how to download the required version, choose the optimal setup type, and tune up additional configurations in the installation wizard.

The Start Page of dbForge Studio for MySQL

The Start Page of dbForge Studio for MySQL

The Start Page is the first thing you see upon opening dbForge Studio. It consists of tabs that provide quick access to the Studio's key features: SQL Editor, Schema & Data Compare, MySQL Debugger, Query Profiler, Data Pump, and much more.

Connecting to a MySQL Database

Connecting to a MySQL database

To start working with MySQL (or MariaDB), the first thing you need to do is establish a connection to the required server. See how you can do it in dbForge Studio using a convenient dialog with a multitude of settings.

Connecting to MySQL on Amazon RDS

Connecting to MySQL on Amazon RDS

You can create a MySQL database instance on Amazon Relational Database Service (RDS) and easily connect to it with dbForge Studio for MySQL. It will take you less than two minutes to learn how it's done.

Setting MySQL Connection Categories

Setting MySQL connection categories

Sometimes you need to work with several database connections and manage multiple tabs simultaneously—and you need to instantly identify the connection that each tab belongs to. This is where the Studio's connection categories will be helpful.

How to Create a MySQL Database

How to create a MySQL database

It will take just a few moments to create a new MySQL database and specify a character set and a collation for it. And it will take less than a minute to learn how it's done in dbForge Studio for MySQL—just watch the video.

How to Create a MySQL Table

How to create a MySQL table

Creating new tables in dbForge Studio for MySQL is just as easy. You can do it by writing a CREATE TABLE statement or using the Studio's smart GUI that makes your experience easy and coding-free. Check this video to see how it's done.

MySQL Primary Key: What It Is and How to Use It

A comprehensive guide to MySQL primary keys

This guide covers the concept of a primary key, demonstrates how to define primary keys for both new and existing tables, and provides quite a few handy tips on managing primary keys in dbForge Studio for MySQL.

A Comprehensive Guide to MySQL Foreign Keys

A comprehensive guide to MySQL foreign keys

This video is an in-depth exploration of foreign keys in MySQL, which begins with the basics and continues with extensive advice on creating and managing foreign keys in the easiest and most versatile way—with dbForge Studio for MySQL.

Many-to-Many Relationships in MySQL: A Comprehensive Tutorial

Many-to-many relationships in MySQL

A many-to-many relationship exists when multiple records in one table are linked to different records in another table. Here is a concise and informative guide that will help you handle these relationships with dbForge Studio for MySQL.

A Beginner's Guide to MySQL JOINs

A beginner's guide to MySQL JOINs

Learn all about the most popular types of JOINs in MySQL: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and CROSS JOIN. See how to operate MySQL JOINs most effectively using dbForge Studio for MySQL.

How to Work With the MySQL Slow Query Log

How to work with the MySQL slow query log

The MySQL slow query log contains information about queries that take too much time to execute. Find out how to enable the slow query log, check related parameters, and remove log entries in dbForge Studio for MySQL.

How to Debug MySQL Stored Procedures

How to debug MySQL stored procedures

Meet the Studio's built-in MySQL Debugger, a powerful tool that allows observing the runtime behavior of your stored procedures and locate logic errors. Watch the video guide and learn how to use it most precisely and effectively.

How to Create Queries Visually Using Query Builder

How to create queries visually

Coding is not the only way to construct MySQL queries. Learn how it can be done using the Studio's integrated Query Builder. With its help, you can draw queries of any complexity on diagrams without writing a single line of code.

How to Import & Export MySQL Data

How to import & export MySQL data

Get acquainted with the most flexible way of importing and exporting MySQL data with 14 most popular formats at hand, including HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.

How to Generate Test Data and Populate Your Databases With It

How to generate test data for MySQL tables

Learn how to get the most out of the Studio's integrated Data Generator, an advanced tool that helps populate MySQL database tables with thousands of rows of realistic, compliant, and column-intelligent test data.

How to Reverse-Engineer MySQL Objects

How to reverse-engineer MySQL objects

In the context of databases, reverse engineering is the process of creating entity-relationship diagrams from existing database schemas. In this video, you'll see the process of reverse-engineering MySQL database objects using dbForge Studio.

How to Create MySQL Databases With Database Projects

How to work with database projects

A database project is a collection of logically organized SQL scripts and query files that are used to create or update a database. Learn how to use database projects and make your database design easy and intuitive with dbForge Studio for MySQL.

How to Version-Control MySQL Databases

How to version-control MySQL databases

Learn how to version-control MySQL database schemas and static table data, commit and revert changes, view and resolve conflicts, as well as track all changes in your databases using the Studio's integrated feature called Source Control.

How to Backup and Restore a MySQL Database

How to backup and restore a MySQL database

The importance of keeping your data safe with regular backups is indisputable. dbForge Studio will help you back up and restore MySQL databases without coding—and conveniently automate this process from the command line.

How to Synchronize Data Between Two MySQL Databases

How to sync data between two databases

If you need to find differences in the data of two MySQL databases, you can use the convenient wizard of dbForge Studio with a hanfdul of flexible settings at your service. Additionally, you can sync data from a source to a target with a few clicks.

How to Compare and Sync MySQL Schemas

How to compare and sync MySQL schemas

Similarly, you can compare MySQL and MariaDB database schemas, scrutinize the differences, and synchronize them in a matter of moments. Watch the video and learn how to do it with minimum effort in dbForge Studio.

How to Migrate MySQL Databases

How to migrate MySQL databases

Watch this video to discover the simplest way of migrating entire databases between different environments across MySQL, MariaDB, Amazon Aurora, and Amazon Relational Database Service (a.k.a. Amazon RDS).

How to Create a New User in MySQL

How to create a new user

Take a look at the step-by-step process of creating new database users and granting them specific privileges using the versatile Security Manager of dbForge Studio for MySQL.

How to Manage User Privileges in MySQL

How to manage user privileges

In the same Security Manager, you can review existing MySQL users, manage their roles, and assign global or object privileges. Just like in the previous case, you won't need any coding to do all that—you'll use a convenient GUI instead.

How to Check Running Queries and Processes in MySQL

How to check running queries and processes

Learn how to inspect running processes and queries in MySQL, view current users logged in to a MySQL instance, and terminate their sessions—all with the help of the Studio's built-in MySQL Session Manager.

How to Perform MySQL Table Maintenance

How to perform MySQL table maintenance

You can easily perform routine table maintenance tasks using dbForge Studio for MySQL. Check this video and learn how to analyze MySQL tables, check them for errors, optimize your data, and repair corrupted tables in no time.

How to Copy MySQL Database Schemas

How to copy MySQL database schemas

Looking for an easy way to copy MySQL and MariaDB database schemas and table data? Well, you can do it using the Studio's Backup and Restore functionality. Watch this video to see how it's done.

How to Create a MySQL Data Report

How to create a MySQL data report

Learn how to design customizable query-based data reports within minutes using the Studio's smart Data Report Wizard. Additionally, see how to schedule regular delivery of your reports from the command line.

How to Create a Pivot Table in MySQL

How to create a pivot table in MySQL

Pivot tables are an excellent way of aggregating your data for subsequent analysis. Watch this video to get acquainted with the process of designing and customizing pivot tables in dbForge Studio for MySQL.

How to Generate Documentation for a MySQL Database

How to generate MySQL database documentation

Learn how to generate comprehensive database documentation, comprising a database structure overview with inter-object and inter-database dependencies. The Studio's integrated Documenter will help you with that.

Installing Oracle 12c on Windows

Here is your step-by-step guide to downloading and installing Oracle 12c on your Windows machine. Have a look at its key features, learn how to get the server up and running, and see how to connect to it with dbForge Studio for Oracle.

Installing Oracle 19с on Windows

Here is your step-by-step guide to downloading and installing Oracle 19c on your Windows machine. Have a look at its key features, learn how to get the server up and running, and see how to connect to it with dbForge Studio for Oracle.

The Start Page of dbForge Studio for Oracle

Take a look at the Start Page, the first thing you see upon opening the Studio. It consists of tabs that provide quick access to the Studio's key features: SQL Editor, Query Builder, Database Diagrams, Schema & Data Compare, and much more.

Setting Oracle Connection Categories

Setting Oracle connection categories

It's not an uncommon case when you need to work with multiple connections and tabs simultaneously - and you need to instantly identify the connection that each tab belongs to. Learn how to make it easier for you with connection categories.

How to import & export Oracle data

Here comes the most flexible way of importing and exporting Oracle data with 14 most popular formats at hand, including HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.

How to migrate Data Via Import/Export Utility

You can migrate Oracle data via the integrated Import/Export Utility of dbForge Studio. Watch the video and see how to export your data to a dump file from the command line, and then import it into a target Oracle database.

How to Use SQL JOINs in Oracle

Explore the most popular types of JOINs in Oracle: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN. See how to manage Oracle JOINs most effectively using dbForge Studio.

How to compare and sync Oracle data

If you need to find differences in the data of two Oracle databases, you can use the convenient wizard of dbForge Studio with a handful of flexible settings at your service. Additionally, you can sync data from a source to a target with a few clicks.

How to compare and sync Oracle schemas

dbForge Studio has everything to help you compare and analyze differences in Oracle database schemas as well. Just like in the previous case, you can synchronize schemas between the source and the target with a couple of clicks.

How to create an Oracle data report

See how easy it is to design customizable query-based data reports within minutes using the smart Data Report Wizard of dbForge Studio. You will also learn how to schedule regular delivery of your reports from the command line.

How to PIVOT and UNPIVOT Oracle data

Learn all about using the PIVOT and UNPIVOT operators to aggregate your data in pivot tables. As a more user-friendly alternative, you can apply an intuitive GUI-powered pivot table editor delivered by dbForge Studio for Oracle.

How to generate test data for Oracle

See how to populate Oracle database tables with thousands of rows of realistic, compliant, and column-intelligent test data. To do that with minimum effort, you can use the Studio's high-end Data Generator.

How to document Oracle databases

Get acquainted with the Studio's Documenter, a tool that generates comprehensive documentation for Oracle databases, providing you with database structure overviews alongside inter-object and inter-database dependencies.

The Start Page of dbForge Studio for PostgreSQL

When you open the Studio, you are greeted by the Start Page, which provides you with instant access to its main features, grouped into four convenient tabs: SQL Development, Database Sync, Data Pump, and Data Analysis.

Connecting to a PostgreSQL database

dbForge Studio for PostgreSQL makes connection to both local and remote databases extremely easy. If you need to get it done fast, you got it. If you require configuring extended connection settings, it won't be a problem either.

Setting PostgreSQL Connection Categories

Setting PostgreSQL connection categories

It's not an uncommon case when you need to work with multiple connections and tabs simultaneously—and you need to instantly identify the connection that each tab belongs to. Learn how to make it easier for you with connection categories.

How to import & export PostgreSQL data

With dbForge Studio, you can import and export PostgreSQL data with 14 most widely used formats at hand, including HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL, and Google Sheets.

How to use JOINs in PostgreSQL

Watch the ultimate guide to PostgreSQL JOINs—which include INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN, and CROSS JOIN—and learn to build and manage them with dbForge Studio for PostgreSQL.

How to optimize PostgreSQL queries

If you value high database performance, you need to make your queries efficient. This is where the Studio's integrated Query Profiler comes into play. In this video, you'll learn how to inspect the execution plans of your queries and fine-tune them.

How to create a simple PostgreSQL data report

It has never been easier to design query-based data reports within minutes using the smart Data Report Wizard of dbForge Studio for PostgreSQL. You will learn how to customize, preview, and export reports to a number of different formats.

How to create a pivot table in PostgreSQL

If you need to aggregate table data for subsequent analysis, pivot tables will be your best assistants. Watch this video to explore the process of constructing and customizing pivot tables in dbForge Studio for PostgreSQL.

Get more guides

If you are looking to delve even deeper into the specifics of dbForge Edge, we gladly invite you to check the dedicated Resources page. There, you will find an abundance of detailed tutorials and helpful tips on a variety of topics.

Get more tutorials on Devart Blog