Recent entries
 
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 Galina Snurnikova on 11/18/2008 12:52 AM

I promised, I continue to describe database comparison tools, which I happened to use. The next tool was Apex SQL Diff 2005.14. The connection is performed quickly. The interesting feature is that the tool can create a database snapshot and compare a database and a snapshot. The other useful feature is that it creates an optional backup of altered database before synchronization and you can return the synchronized database in the previous state. Apex SQL Diff can compare nearly all SQL Server objects.

Read More »

By Galina Snurnikova on 11/18/2008 12:31 AM

In my previous post I wrote about free tools for database comparison. Now I will make a review of some paid products. The next tool I tried was SQLDBCompare 2.4. This program is paid. It costs $129.00 to $599.00. It supports SQL Server 2000 and 2005. You can compare just standard objects by means of this tool (tables, check constraints, primary keys, foreign keys, indexes, views, DML triggers, stored procedures and user-defined functions). The convenient feature is that you can synchronize each database object by copying the object from one database to another. The unpleasant things are error messages on closing and during object synchronization.

Read More »

By Galina Snurnikova on 11/18/2008 12:22 AM

Every DBA encounters a situation when he/she has to compare two databases or schemas. There may be a production and a development database in your system. How to compare them quickly and effectively and make the production database equal to the development one?

Nowadays you can find several tools that will help you to do this. They differ in price, supported objects, variants of synchronization script representation and database platforms supported. Let’s review them.

Read More »

By Yuri Kovtun on 11/17/2008 5:02 PM

 Microsoft provides two different tools, which support upsizing of Access database to SQL Server: Access Upsizing wizard and SQL Server Migration Assistant (SSMA). I believe that SSMA is the best solution for most of the cases.

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 »

 
 
Search