//SQL Editor | dbForge Team Blog » SQL editor

Posts Tagged ‘SQL editor’

Synchronization script is too large – what shall I do?

Tuesday, 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…)

Tags: , , , ,
Posted in SQL Server | Comments Off

"));