Devart Blog

SQL editor

Tidy SQL with dbForge SQL Complete

Posted by on August 1st, 2016

In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering from messy and unformatted code. In addition, we will talk about how to force all team members to adhere generally accepted coding standards with no efforts. (more…)

Synchronization script is too large – what shall I do?

Posted by on May 19th, 2009

In my previous post Schema Comparison Stress Testing I mentioned problems we met testing dbForge Schema Compare for SQL Server on large database. In this post I would like to give you some tips on processing large synchronization scripts.

Problem Description

Suppose you have compared two databases and want to synchronize them.  You tried to generate the synchronization script but it’s about 100 Mb and simply couldn’t be stored in the memory. When you open it in SQL editor for execution, the application fails with ‘Out Of Memory’ error.

Solution

There are two solutions for this problem:

(more…)