Tag archive for ‘Sybase’

Troubleshooting the SSMA Data Migration Performance

Posted by admin on Feb 26, 2009 • (0)

SQL Server Migration Assistant (SSMA) can be used for database migration, for example, from Oracle to SQL Server. When transferring data from large tables, you can face performance problems  during the data migration process. This article describes how to make the SSMA data migration faster and proposes actions that can improve the performance.
Allocating Target and [...]

Some Notes on Sybase ASA to SQL Server 2005 Conversion

Posted by admin on Dec 2, 2008 • (3)

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 [...]

Emulation of Sybase ROLLBACK TRIGGER command in SQL Server 2005

Posted by admin on Nov 3, 2008 • (2)

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 [...]

1