Migrating UTF8 data from Oracle to SQL Server using SSMA for Oracle

Before we could begin our Data Migration, you’ll need to clearly understand what is UTF8 is the 8-bit encoding of Unicode? It is a variable-width encoding and a strict superset of ASCII. This means that each and every character in the ASCII character set is available in UTF-8 with the same code point values. One…

9

Data migration of large Sybase tables may cause TEMPDB errors

Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: “Can’t allocate space for object ‘temp worktable’ in database ‘tempdb’ because ‘system’ segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to…

0

‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456, Severity: 14, State: 8) error messages to be written to the SQL Server ERRORLOG when used from an application using SQL authentication.   Steps to reproduce the problem: After migrating an Oracle sequence to SQL Server 2008R2, where the SQL Server target…

2

SSMA 5.0 for Access and the DAO requirement

My name is Angshuman Nayak and I am a part of SQL Developer support in Microsoft and work mostly around connectivity and data access technologies. As one of my activities I am helping customers and partners to move from various data bases like Oracle, Sybase, MySQL and Access to SQL Server. Today I am going…

2

Unable to retrieve next sequence value from a migrated Oracle sequence

Background: SSMA 4.2 emulates an Oracle sequence as a table containing an IDENTITY column. Each sequence gets its own table, prefaced by the literal “$SSMA_seq_”.    Thus, an Oracle sequence named SUPPLIER_SEQ would be migrated to a table in the target SQL Server database named “$SSMA_seq_SUPPLIER_SEQ”, defined as     CREATE TABLE [dbo].[$SSMA_seq_SUPPLIER_SEQ](             [id]…

4

SSMA : Migrate User Defined Data Types from Sybase to SQL Server

SSMA2008 for Sybase doesn’t inherently migrate user defined data type to SQL Server. This applies to the latest build on SSMA for Sybase v4.2.2277. A future version might have the feature to convert them implicitly but as of now we don’t do it.      a) If a Table in Sybase is using a user defined datatype…

2

SSMA error ‘External variable cannot be converted’

Today I am blogging about an error that I frequent come across while working on SSMA cases . I tried to search more information about this error in the net but it never returns any useful result. So thought of blogging it. While migrating data from access database to SQL server we sometimes come across…

0