New in Delphi DAC: Support for the Latest Versions of Lazarus and FPC

Secure Connections in ODAC

We are excited to announce that new versions of Delphi data access components are now generally available. All DAC products received support for the latest versions of Lazarus (2.0.10) and Free Pascal Compiler (3.2.0).

Read the rest of this entry »

Database Reverse Engineering

In our fast-changing world, observations of certain events, operations, and processes determine the development of business and implementation of any solutions or ideas. Such observations are captured in the form of data usually stored and processed in a database.

Read the rest of this entry »

Devart Becomes the Winner of 2020 CV Magazine Technology Innovator Awards

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database development, management, and administration for SQL Server, MySQL, Oracle, and PostgreSQL.

Read the rest of this entry »

How to Export and Import SQL Server Database Data to a SQL Script

We quite often face the task of migrating database directory data. And the database for a recruitment service, which we created in the previous series of articles, is no exception. In this article, we are going to demonstrate how you can export data to a .sql file and then import it to the target database. Is it worth mentioning that you can either migrate the whole database or certain objects depending on your purpose.

Read the rest of this entry »

Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards

Devart products voted winners by DBTA readers

For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products as winners among the world’s top solutions for database development, management, and administration.

Read the rest of this entry »

New features in dbForge Studio for PostgreSQL v2.3

Studio for PostgreSQL 2020 v2.3

We are glad to announce that the new version of dbForge Studio for PostgreSQL has been just released!

Read the rest of this entry »

Searching for invalid objects with SQL Complete

The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and the ways of finding them in the SQL Server database.

Read the rest of this entry »

How to Search for Database Objects and Table Data in SQL Server

Hello and welcome to the fourth part of our series of articles that will help you discover how to design and work with databases. This time we are going to delve into an intricate matter of data and object search in SQL Server, which will be further conducted first with the help of standard scripts and after that, using the dbForge Search tool.

Read the rest of this entry »

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 »