Data Access Technologies

(Data Access, XML, SSIS, LINQ, System.Data ...)

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: ‘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...
  • Blog Post: 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...
  • Blog Post: 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”...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (7 items)