In this article, we will talk about how to create a user in Oracle. You will learn how to add new database users, figure out which supplemental aspects this job involves: from the initial us… Read More

There are a lot of relational database management systems on the market today, and choosing the proper one might be quite a challenge. The perfect RDBMS must be fast, effective, and it also… Read More

Time is the most precious resource nowadays. It’s the age of speed, quality, and effectiveness. That’s why all the professionals around the world appreciate products and tools th… Read More

In this article, we are going to export a table from SQL Server to a .csv file using four different tools. Besides, you will learn how to export SQL query results with and without headers to… Read More

More good news coming our way! dbForge SQL Complete, your favorite add-in for SSMS and Visual Studio—packing a punch with its SQL code completion, formatting, and refactoring capabilit… Read More

The article presents a detailed step-by-step walkthrough on how to move a database scripts folder to Azure Files storage and keep it up-to-date with the help of dbForge Studio for SQL Server… Read More

All relational database management systems, including PostgreSQL, provide specialized means and techniques to get the necessary information quickly and accurately. These means include indexe… Read More

The article is dedicated to the SQL Server DELETE statement. Here you will find detailed information about how to use the query in order to remove one or several rows from one or several tab… Read More

When developers start working on any applications (for both web or desktop versions), they spend a long time worrying about the backend database, its tables, and their relationships, stored… Read More

We have just released a maintenance update of dbForge SQL Complete, an add-in for SSMS and Visual Studio that can accelerate your daily SQL coding by up to 4 times with a handful of code com… Read More

The article provides a detailed guide on MySQL Command Line Client and shares useful tips on how to download, install, and get started with it. Read the tutorial to find out the best MySQL c… Read More

The new version of Devart dotConnect for Oracle contains improvement of Entity Framework Core: the support of new data types Uri, IPAddress, PhysicalAddress, and expanded abil… Read More

The new version of Devart dotConnect for MySQL contains significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress,&n&hell…Read More

The new version of dotConnect for PostgreSQL offers support for load balancing. It allows specifying multiple hosts with their ports in the Host parameter of the connection string. The serve… Read More

The festive season has come to an end, but Devart is still receiving presents. We have great news that we would like to share. dbForge Studio for MySQL gained nine awards from G2. The collec… Read More

Have you ever faced the necessity to load data from multiple CSV files into multiple database tables? Not so uncommon, right? In this article, we share a step-by-step tutorial on how to perf… Read More

What’s the big deal with SSIS Execute Process Task? Among the many SSIS components, Data Flow and SQL tasks are enough for simple tasks. Using SSIS to compare two tables is o… Read More

We are excited to announce that dbForge Studio for Oracle won two G2 badges, which further prove how valuable it is to our users. And indeed, the G2 reviewers say that dbForge Studio is so c… Read More

The Devart team worked hard and now we are glad to introduce new features and improvements to one of our remarkable product lines – dbForge tools for Oracle, namely dbForge Data Compar… Read More

Meet the latest update of dbForge Studio for Oracle! It packs quite a punch that we believe you will find interesting: updated connectivity, a few new options in the Schema Compare functiona… Read More

We are happy to announce that the dbForge product line has received multiple remarkable awards. dbForge Studio for SQL Server and SQL Complete have won two badges each: both G2 and SoftwareS… Read More

We are pleased to inform you about the release of all our ODBC drivers for cloud data sources and databases. With Devart ODBC drivers, you can access various&nb&hell…Read More

The topic of cross-compiling projects in Lazarus on Linux systems has been repeatedly raised by our users. Therefore, in this article, we want to examine in detail the features of cross-comp… Read More

In this article, we are going to talk about the SQL INSERT statement and how to use it in order to insert new rows with data into an existing table. Here, you will find the basic syntax for… Read More

SQL Server is a dominant database management system (DBMS) used by various organizations throughout the world. This article presents a detailed overview of its multiple versions, editions, a… Read More

In the article, we are going to provide a step-by-step guide on how to connect to SQL Server and execute SQL queries using the sqlcmd utility, SQL Server Management Studio, and dbForge Studi… Read More

MySQL is an extremely popular open-source RDMS, and it’s widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version… Read More

Concurrency conflicts arise due to concurrent access to a shared resource. This article explores ways to handle concurrency conflicts using ASP.NET Core and Oracle. To connect to Oracle, dot… Read More

In the article, we are going to examine how to optimize SQL queries and improve query performance by using SQL query optimization tips and techniques, such as execution plans, indexes, wildc… Read More

We are thrilled to announce the release of dbForge SQL Tools 6.1—a pack of essential database tools that significantly extend Microsoft SSMS and help boost developer producti… Read More

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, and SQLite. New versions of Devart providers support Entity Fra… Read More

We are thrilled to roll out the new version of dbForge Studio for SQL Server—our multi-featured IDE for database development, management, and administration. The release brings a numbe… Read More

Devart is glad to announce the release of Excel Add-ins 2.6 with support for Microsoft Excel 2021, renamed and updated Excel Add-in for G Suite, and more cloud objects supported in other add… Read More

SQL databases have been in use for many decades—and surely they will be in use for many years into the future. In this guide, we will cover the major differences between… Read More

We are glad to announce the release of new ODBC Drivers. Our ODBC drivers provide direct access to these services through HTTPS from different analytics, BI, ETL, reporting, database managem… Read More

We are glad to announce the release of UniDAC 9.1 and PgDAC 7.1 with the support for PostgreSQL 14. Now you can work with PostgreSQL 14 and PostgreSQL stored procedures with OUT parameters… Read More

The article provides a brief feature overview of the phpMyAdmin software and dbForge Studio for MySQL. In the article, you can find a feature comparison of both tools and see why dbForge Stu… Read More

The definition of a view in PostgreSQL—and in other SQL database management systems, for that matter—is rather simple: a view is a virtual table that does not form part of the ph… Read More

Hardly had the winter started when dbForge Studio for SQL Server received yet another award. According to Crozdesk users, the IDE has everything you might need to set up your SQL development… Read More

If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB and MyISAM, two well-known types of MySQL storage e… Read More

The article provides a detailed overview of the T-SQL IF EXISTS and NOT EXISTS statements. It also explains why EXISTS should be chosen over IN and NOT EXISTS over NOT IN when comparing data… Read More

In the article, we are going to examine how to create a new user account and grant/revoke permissions and roles on a database object, as well as how to check SQL Server user permissions on t… Read More

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL… Read More

Here comes the maintenance update of dbForge SQL Complete, your favorite SSMS and Visual Studio add-in for context-sensitive code autocompletion, formatting, and refactoring. Our team aspire… Read More

In the article, you will find a detailed guide on how to automatically monitor a SQL Server database for schema changes and automatically create a report and log file. The examples of script… Read More

If you are in search of the optimal way to export data from SQL Server to Excel spreadsheets, look no further. Just check this article. Here we tried to gather together different methods&mda&hell…Read More

Devart is glad to announce support for the latest PostgreSQL version — PostgreSQL 14 — in dotConnect for PostgreSQL 7.22. Now you can connect to PostgreSQL 14, work with stored p… Read More

The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete it in the SQL Server database. Prior to developing a data… Read More

If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition of an existing table. In this article, we will be… Read More

Fall is the time to reap the rewards! The Devart team has been hard on bringing you the best-in-class ODBC connectors. We are delighted to announce that our ODBC drivers were highly recogniz… Read More

The article covers the key performance metrics available in MySQL that can help users improve and optimize query performance in MySQL databases. In addition, there is a brief overview of som… Read More

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 five ways to create… Read More

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… Read More

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, da… Read More

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. After all, your recommendation can h… Read More

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 Linq… Read More

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post. Recently, Microsoft released a cumulative Windows update (inclu… Read More

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.&n&hell…Read More

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.&n&hell…Read More

We are glad to announce that EntityDAC is now available for the new RAD Studio 11 Alexandria and supports the ARM (Apple Silicon M1). EntityDAC is an ORM tool for Delphi and C++ Builder that… Read More

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… Read More

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… Read More

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… Read More

We are happy to announce that the new version of dbForge SQL Complete has been released. We have been working on the implementation of the new features and fixing the faults in the existing… Read More

Devart is glad to announce the release of SSIS Data Flow Components 2.0 with support for 27 new data sources. We have supported Snowflake cloud data warehouse and a number of cloud applicati… Read More

In this article, we will show how you can take more control over the data in your database by using a custom hash function Python generator in the dbForge Data Generator tool. We will provid… Read More

The new version of Devart dotConnect for PostgreSQL includes significantly improved support for Entity Framework Core. It both supports the new data types and extends LINQ query translation… Read More

The new release of Entity Developer 6.12 mainly focuses on Entity Framework Core support improvements, that are based on the feedback of our users. We will continue to work on these features… Read More

The new version of Devart dotConnect for SQLite contains significant improvements of Entity Framework Core support, improving Entity Framework Core Code-First Migrations a lot and adding sup… Read More

Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as much as we can, tailoring this tool to our spe… Read More

Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as much as we can, tailoring this tool to our spe… Read More

Code autocompletion can be a popular and useful technique for developers productivity who strive to write clear, accurate, and reliable code with little time effort. As a rule, code completi… Read More

More good news coming our way! It is inspiring to see that all the hard work we put into our products pays off as happy users and good reviews bring us more and more recognition on independe… Read More

As we all know, Microsoft is preparing for a huge event that everyone has been looking forward to—the release of the next-gen desktop operating system, Windows 11. We at Devart have ch… Read More

In the article, we are going to discuss data types including string, numeric, date and time, spatial, and JSON supported by MySQL. Also, we’ll provide examples of their usage and see h… Read More

In this article, we are going to describe different ways to create a PostgreSQL database from scratch. Here, you will find a tutorial for setting up a database using the CREATE DATABASE comm… Read More

We are delighted to announce the availability of SecureBridge for the recently released RAD Studio 11 Alexandria. The new version of our product also supports the ARM architecture (Apple Sil… Read More

Following the recent release of RAD Studio 11 Alexandria, we are ready to share the availability of Devart dbExpress drivers for the new RAD Studio with support for Firebird 4 and the ARM pl… Read More

In this article, we will focus on starting a PostgreSQL server on your PC. Here, you will find a simple step-by-step PostgreSQL tutorial for Windows seasoned with comprehensive illustrations… Read More

September has been around for mere two weeks, yet we have already added 3 new shiny badges to the wall of dbForge awards. Why not add a couple more, then? Our flagship database solutions for… Read More

After only a few days since the release of RAD Studio 11 Alexandria, we are ready to share the availability of Delphi Data Access Components for the new RAD Studio with support for Firebird… Read More

Every database developer inevitably faces the necessity to perform changes to the data, modify and reorganize them. For these tasks, Oracle will serve excellently.  Oracle database offe… Read More

The accolades for our dbForge Studios just keep coming!  Today we are immensely proud to announce that we received an array of major awards from the Crozdesk platform. About dbForge Stu… Read More

Another award, another milestone for dbForge Studio for SQL Server! We are thrilled to announce that our flagship solution received the “Quality Choice” and the “Trusted Ve… Read More

In the article, you will learn about SIGNED and UNSIGNED integer data types in MySQL. The article provides information about integer types with the ZEROFILL, AUTO_INCREMENT, and display_widt… Read More

The importance of rapid but at the same time, efficient software development can not be overestimated. It is the standard of high professionalism that is an absolute must for every successfu… Read More

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicat… Read More

It should come as no surprise that user reviews on independent reviewing platforms are extremely important to us. It is your review that can make all the difference to a person looking for a… Read More

Renaming is not an uncommon operation when it comes to database tables. You might want to assign a more meaningful name to a table. You might need to introduce changes that will make multipl… Read More

dbForge team is excited to release the new version of Data Compare for PostgreSQL v3.4 with enhanced connectivity capabilities. dbForge Data Compare for PostgreSQL is a powerful, fast, and e… Read More

We are glad to announce the updated version of dbForge Query Builder for MySQL. The tool offers users a great solution to build, generate, and handle MySQL queries from simple to complex in… Read More

We are glad to announce that a new version of dbForge Query Builder for SQL Server is now available for download. In this release, we extended the tool’s functionality with the Data Re… Read More

It is a pleasure to announce that G2 awards dbForge Studio for MySQL with the ‘Leader Summer 2021’ and ‘Momentum Leader Summer 2021’ badges in the DB Backup category… Read More

To stay productive and write accurate and error-free code, developers tend to use SQL code completion tools. They help them not only enhance code productivity significantly and write code fa… Read More

The article explores a bunch of popular methods to rename a MySQL table and provides handy worked examples that could be of utility to both beginning and experienced users. In one of our pre… Read More

In the article, we are going to discuss different methods to copy databases between SQL Server instances. In addition, we explore the benefits and drawbacks of each method so that you can ch… Read More

We are delighted to announce that Devart has been ranked #1 by the readers of the Database Trends and Applications magazine — the leading media specializing in information management… Read More

It didn’t take long since the dbForge Studio product line received its latest award — and now we’ve got a new one to tell you about. Our all-in-one development IDEs for the… Read More

The article presents a comprehensive walkthrough of existing methods to create a table in PostgreSQL. PostgreSQL is one of the most efficient and advanced open-source relational database man… Read More

There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is highly reliable and efficient, so it is no wonder that it h… Read More