Recent entries
Author: Yuri Rusakov Created: 11/17/2008 1:12 PM
Here I will place my remarks on interesting data migration issues and propose solutions.

By Yuri Rusakov on 11/18/2008 1:13 PM

Conversion of output REF CURSOR parameter in an Oracle stored procedure depends on the way this procedure is used by caller code. There are two distinct ways to use REF CURSOR parameter, and they very seldom are both applied to the same procedure.

Read More »

By Yuri Rusakov on 11/17/2008 1:49 PM

We should modify all DML statements that work with emulated temporary table. It is necessary because we need to use s_id and s_lt columns to provide session isolation.

Read More »

By Yuri Rusakov on 11/17/2008 1:38 PM

Here is the promised solution for emulating GTTs functionality in SQL Server.
We convert each source GTT to a common SQL Server table with two additional columns: s_id, which will store current session id, and s_lt, which will contain the login time of the session.


Read More »

By Yuri Rusakov on 11/17/2008 1:12 PM

Oracle and SQL Server use the same term ‘temporary table’ for different things, and this may create problems when migrating a database between these platforms. 

Read More »