Products

Restore SQL Server Database Backup Using T-SQL Script and SSMS

The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two main principles of database restore available in Microsoft.

(more…)

Using dbForge Studio for Oracle to Automate Oracle Database Deployment

When raising issues related to increasing performance and improving Oracle database reliability and integrity while developing and deploying databases, the real value lies in automating the process and managing changes securely.

(more…)

How we made more realistic tests with dbForge Data Generator for MySQL

We have been developing our own SaaS CMS platform floowedit since 2007. During all the development and improvement phases we have always faced a problem: having realistic and quantitative test data at hand. In fact, like everyone else, we use dummy data generators and often work with so-called ‘lorem ipsum’.

(more…)

SQL Server Backup Types and Key Concepts

The importance of database backup and restore can be neither underestimated nor ignored. And since your data is subject to modification, the primary task is to ensure its safety and mitigate the risks of data loss.

(more…)

dbForge Studio for MySQL gains more user recognition with 3 prestigious awards

dbForge Studio for MySQL is one of the most famous and valuable Devart products – a comprehensive solution with an intuitive interface for MySQL and MariaDB database developers, administrators, and managers. This product is a user favorite when it comes to creating and executing queries, developing and debugging procedures, and managing database objects.

The recognition comes with 3 brand new awards that we were happy and proud to receive from the leading industry platforms.

(more…)

How to change a column name in MySQL

Learn how to safely rename a column in a MySQL database using a universal multi-featured tool – dbForge Studio for MySQL.

(more…)

Secure Connections to Oracle, Faster Access to Cloud Data, and Other Updates in ODBC Drivers

Oracle 20c, PostgreSQL 13, and SQL Server 2019 were supported in respective ODBC drivers.

(more…)

Entity Framework Core 5 support in Entity Developer and dotConnect Providers

Devart is glad to announce the release of Entity Developer 6.10 and the new versions of dotConnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, and SQLite. New versions of Devart products support Entity Framework Core 5.0 and its new features. Besides, there are certain breaking changes regarding dotConnect assemblies with Entity Framework Core functionality. These changes must be taken into account when you update your projects, working with Entity Framework Core 2.

(more…)

How to perform Git code review

Summary: This article will demonstrate a code review workflow when using Git as a repository and Review Assistant as a code review tool. You will learn how to set up an effective code review process and useful features for code review that our tool provides.

(more…)

Azure Database for MySQL: How to connect and migrate databases with dbForge Studio for MySQL

In this article, you’ll learn how to connect to Azure Database for MySQL and discover three scenarios of database migration from MySQL to Azure using dbForge Studio for MySQL.

(more…)