1/16

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Tools and Products that Support Migration

• Migration Overview
• Oracle Database 12c Release 1 Features for Migration Support
  • SQL Translation Framework
  • Support for MySQL Applications
  • Identity Columns
  • Implicit Statement Results
    • JDBC Support for Implicit Results
    • OCI Support for Implicit Results
    • ODBC Support for Implicit Results
  • Enhanced SQL to PL/SQL Bind Handling
  • Native SQL Support for Query Row Limits and Row Offsets
  • JDBC Driver Support for Application Migration
  • ODBC Driver Support for Application Migration
• Other Oracle Products that Enable Migration
  • OEM Tuning and Performance Packs
  • Oracle GoldenGate
  • Oracle Database Gateways
  • Oracle SQL Developer
• Migration Support for Other Database Vendors

2 SQL Translation Framework Overview and Architecture

• When to Use SQL Translation Framework
• What is SQL Translation Framework
• Architecture of SQL Translation Framework
• How to Use SQL Translation Framework

3 SQL Translation Framework Configuration

• Installing and Configuring SQL Translation Framework with Oracle SQL Developer
  • Overview of Oracle SQL Developer Migration Support
  • Setting Up Oracle SQL Developer 3.2 for Windows
    • Setting Up Oracle SQL Developer 3.2 Startup
    • Starting Oracle SQL Developer
  • Creating a Connection to Oracle Database
  • Testing SQL Translation
  • Creating a Translation Profile and Installing SQL Translator
    • Installing SQL Translator
    • Creating a Translation Profile
  • Using the SQL Translator Profile
• Installing and Configuring SQL Translation Framework from Command Line
  • Installing Oracle Sybase Translator
  • Setting up a SQL Translation Profile
  • Setting Up a Database Service to Use the SQL Translation Profile
    • Setting Up a Database Service in Oracle Real Application Clusters
  • Testing Sybase SQL Translation Using the SQL Translation Profile
• Granting Necessary Permissions for Installing the SQL Translator

4 SQL Translation of JDBC and ODBC Applications

• SQL Translation of JDBC Applications
  • SQL Translation Profile
  • Error Message Translation
  • Converting JDBC Standard Parameter Markers
  • Executing the Translated Oracle Dialect Query
  • Error Translation
  • SQL Translation Using a JDBC Driver
• SQL Translation of ODBC Applications
  • SQL Translation profile
  • Error Message Translation
  • Translating Error Messages

5 Application Migration Using SQL Translation Framework Example

• Migrating a Sybase JDBC Application
  • Application Overview
  • Setting Up Migration
  • Capturing Migration
  • Converting Migration
  • Generating a Migration
    • Creating a Target Oracle User
  • Moving the Data
• Generating Migration Reports

6 MySQL Client Library Driver for Oracle

• Introduction to MySQL Client Library Driver for Oracle
• Installation and First Use of MySQL Client Library Driver for Oracle
• Overview of Migration with MySQL Client Library Driver for Oracle
• Using MySQL Client Library Driver for Oracle
  • Relinking the Application with the liboramysql Driver
  • Connecting to Oracle Database
  • Supported Platforms
  • Error Handling
  • Globalization
  • Expected Differences

7 API Reference for Oracle MySQL Client Library Driver

• Mapping Data Types
  • Mapping Oracle Data Types to MySQL Data Types
  • Data Type Conversions for MySQL Program Variable Data Types
    • MYSQL_TYPE_BLOB
    • MYSQL_TYPE_DATE
    • MYSQL_TYPE_DATETIME
    • MYSQL_TYPE_DOUBLE
    • MYSQL_TYPE_FLOAT
    • MYSQL_TYPE_LONG
    • MYSQL_TYPE_LONG_BLOB
    • MYSQL_TYPE_LONGLONG
    • MYSQL_TYPE_MEDIUM_BLOB
    • MYSQL_TYPE_NEWDECIMAL
    • MYSQL_TYPE_SHORT
    • MYSQL_TYPE_STRING
    • MYSQL_TYPE_TIME
    • MYSQL_TYPE_TIMESTAMP
    • MYSQL_TYPE_TINY
    • MYSQL_TYPE_TINY_BLOB
    • MYSQL_TYPE_VAR_STRING
  • Data Type Conversions for MySQL External Data Types (LOB Data Type Descriptors)
  • Data Type Conversions for Datetime and Interval Data Types
• Error Handling
• Available MySQL APIs
  • my_init()
  • mysql_affected_rows()
  • mysql_autocommit()
  • mysql_change_user()
  • mysql_character_set_name()
  • mysql_close()
  • mysql_commit()
  • mysql_connect()
  • mysql_create_db()
  • mysql_data_seek()
  • mysql_debug()
  • mysql_debug_info()
  • mysql_drop_db()
  • mysql_dump_debug_info()
  • mysql_eof()
  • mysql_errno()
  • mysql_error()
  • mysql_escape_string()
  • mysql_fetch_field()
  • mysql_fetch_field_direct()
  • mysql_fetch_fields()
  • mysql_fetch_lengths()
  • mysql_fetch_row()
  • mysql_field_count()
  • mysql_field_seek()
  • mysql_field_tell()
  • mysql_free_result()
  • mysql_get_character_set_info()
  • mysql_get_client_info()
  • mysql_get_client_version()
  • mysql_get_host_info()
  • mysql_get_proto_info()
  • mysql_get_server_info()
  • mysql_get_server_version()
  • mysql_get_ssl_cipher()
  • mysql_hex_string()
  • mysql_info()
  • mysql_init()
  • mysql_insert_id()
  • mysql_kill()
  • mysql_library_end()
  • mysql_library_init()
  • mysql_list_dbs()
  • mysql_list_fields()
  • mysql_list_processes()
  • mysql_list_tables()
  • mysql_more_results()
  • mysql_next_result()
  • mysql_num_fields()
  • mysql_num_rows()
  • mysql_options()
  • mysql_ping()
  • mysql_query()
  • mysql_read_query_result()
  • mysql_real_connect()
  • mysql_real_escape_string()
  • mysql_real_query()
  • mysql_refresh()
  • mysql_reload()
  • mysql_rollback()
  • mysql_row_seek()
  • mysql_row_tell()
  • mysql_select_db()
  • mysql_send_query()
  • mysql_server_end()
  • mysql_server_init()
  • mysql_set_character_set()
  • mysql_set_local_infile_default()
  • mysql_set_local_infile_handler()
  • mysql_set_server_option()
  • mysql_shutdown()
  • mysql_sqlstate()
  • mysql_ssl_set()
  • mysql_stat()
  • mysql_stmt_affected_rows()
  • mysql_stmt_attr_get()
  • mysql_stmt_attr_set()
  • mysql_stmt_bind_param()
  • mysql_stmt_bind_result()
  • mysql_stmt_close()
  • mysql_stmt_data_seek()
  • mysql_stmt_errno()
  • mysql_stmt_error()
  • mysql_stmt_execute()
  • mysql_stmt_fetch()
  • mysql_stmt_fetch_column()
  • mysql_stmt_field_count()
  • mysql_stmt_free_result()
  • mysql_stmt_init()
  • mysql_stmt_insert_id()
  • mysql_stmt_next_result()
  • mysql_stmt_num_rows()
  • mysql_stmt_param_count()
  • mysql_stmt_param_metadata()
  • mysql_stmt_prepare()
  • mysql_stmt_reset()
  • mysql_stmt_result_metadata()
  • mysql_stmt_row_seek()
  • mysql_stmt_row_tell()
  • mysql_stmt_send_long_data()
  • mysql_stmt_sqlstate()
  • mysql_stmt_store_result()
  • mysql_store_result()
  • mysql_thread_end()
  • mysql_thread_id()
  • mysql_thread_init()
  • mysql_thread_safe()
  • mysql_use_result()
  • mysql_warning_count()

8 API Reference for SQL Translation of JDBC Applications

• Translation Properties
  • sqlTranslationProfile
  • sqlErrorTranslationFile
• OracleTranslatingConnection Interface
  • SqlTranslationVersion
  • createStatement()
  • prepareCall()
  • prepareStatement()
  • getSQLTranslationVersions()
• Error Translation Configuration File

Glossary

Index