Newsletters
Migration of Oracle sequences to SQL Server 2005/ 2008
When migrating Oracle tables to SQL Server, the problem of sequence conversion is one of the most common. Indeed, SQL Server does not have any object even distantly resembling an Oracle sequence, and some tradeoffs are inevitable when you make decisions about the mechanisms to implement its behavior in the target system.
In Oracle, a sequence [...]
Some Notes on Sybase ASA to SQL Server 2005 Conversion
In spite of the fact that Sybase Adaptive Server Anywhere and Sybase Adaptive Server Enterprise have many common features, the conversion of Sybase ASA to SQL Server 2005 can cause more problems than the conversion of Sybase ASE database to SQL Server. It depends on differences in SQL dialects, which SQL Sybase ASE and Sybase [...]
How to convert Oracle hierarchical query to SQL Server
Hierarchical query is a one of the most powerful feature supplied by Oracle to retrieve complex hierarchical data from a database. Oracle extended syntax of the SELECT statement allows user to construct compact queries using a set of the keywords, pseudocolumns, operators and functions. The results of the queries are ready to be used [...]
Emulation of Sybase ROLLBACK TRIGGER command in SQL Server 2005
ROLLBACK TRIGGER is one of those Sybase Adaptive Server Enterprise commands which do not have direct equivalent in SQL Server. SQL Server Migration Assistant does not support automatic conversion of this command, and the reason is impossibility to suggest one simple solution that is local for the module and good for all cases. Below I [...]