Find and delete incomplete open transactions in SQL Server – Part 2

In the first part of the series of our articles on this subject, we presented the general algorithm for deleting open transactions that are not completed from a SQL Server database and considered the process of creating a table to record incomplete transactions. Now, let’s look at the process of creating a CRUD stored procedure to find and delete active transactions in SQL Server.

Read the rest of this entry »

Entity Developer 6.7 with Console App, .NET Core Support Improvements and More

Devart is glad to announce the release of Entity Developer 6.7 – a visual ORM designer for a wide variety of ORMs. The new version comes with a console application added for convenient development process automation and improves support for .NET Core development and third-party providers.

Read the rest of this entry »

Migrating data from Oracle to PostgreSQL database

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

Read the rest of this entry »

Adopt flawless Continuous Integration into Bamboo with new dbForge DevOps plugin

We are glad to inform our SQL Server users that we have just extended the compatibility of dbForge DevOps Automation for SQL Server with just-released dbForge DevOps Automation Bamboo Plugin for SQL Server.

Read the rest of this entry »

How to write complex MySQL queries?

Advanced queries aimed to solve complex tasks or multiple tasks constitute an essential part of any database administrator or developer job. MySQL complex queries must be handled with the utmost seriousness since inaccurate MySQL code or poorly performing scripts can cause severe bugs and application failures. 

Read the rest of this entry »

Overall view of Devart SQL tools for Database CI

Devart offers the following tools that are involved in Continuous Integration both directly and indirectly.

Read the rest of this entry »

How to create custom SQL Server replication for read-only databases

Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose of separating analytical and operative tasks. The first cause high load on databases and in order to reduce it, the replica of the primary database is created to perform analytical read-only queries. 

Read the rest of this entry »

Find and delete incomplete open transactions in SQL Server – Part 1

Frequently enough, MS SQL Server transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine database development. The most striking example is when one uses SQL Server Management Studio to run a script that starts an explicit transaction with the BEGIN TRANSACTION statement, but then the batch is canceled in the middle of a transaction without issuing a COMMIT or ROLLBACK statement to complete the transaction and the transaction is left open.

Read the rest of this entry »

Pivot Tables in PostgreSQL

A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored in random order. By running a query to select data from a database table, you can perform filtering, sorting, grouping, selection and other operations with data.

Read the rest of this entry »

Data migration from MySQL to Oracle server

Data migration is a tiresome task requiring a great deal of manual activity. In this article, we will examine how to migrate MySQL data to the Oracle server, using Data Export feature built-in dbForge for MySQL products. In the given worked example, we will move data from the actor table and the query result from the sakila database that exist on MySQL server to the SCOTT schema on Oracle server.

Read the rest of this entry »