Index
A B C D E G I J L M O P R S T U
A
- accessing
- client applications, 1-12
B
- BCP
- generating
- SQL*Loader scripts, 4-7
- bitwise operations, 4-18
C
- calling
- cross-database procedures, 4-18
- case-sensitivity
- schema objects, 1-13
- cast operations
- support for, 4-9
- character strings
- implicit date conversion, 1-13
- client applications
- accessing, 1-12
- comparing
- Oracle Transparent Gateway, 1-4
- complex case statements, 4-20
- configuration, 1-5
- configuration file, 1-6
- creating
- repository, 1-6
- cross-database procedure calls, 4-18
- customizing
- storage options, 1-14
- cyclic procedures
- avoiding, 4-11
D
- data loading
- constraints, 1-7
- controlling files, 1-10
- data types
- mapping, 1-8
- modifying, 1-7
- modifying DATATIME, 4-8
- modifying TIMESTAMP, 4-8
- data types, modifying VARCHAR, 4-8
- databases
- Microsoft SQL Server, 4-4
- date conversion
- for character strings, 1-13
- DDL commands, 4-18
- DLL statements
- stored procedures, 4-18
- double brackets
- using, 4-9
- downloading, 1-3
- dynasets, 4-14
E
- editing
- schema objects, 4-9
- table defaults, 1-14
- error messages, 1-11, 3-10
- creating Oracle Model, 1-9
- foreign keys, 1-12
- hostdef, 1-12
- loading source database, 1-9
- logging, 1-16
- Microsoft Access ODBC driver, 3-4
- more information, 1-4
- Sybase ODBC translator, 4-4
- exporter
- for Microsoft Access, 3-2
G
- global variables, 4-21
- @@SERVERNAME, 4-23
- @@SPID, 4-23
- @@TRANSTATE, 4-24
I
- IDENTITY columns, 4-22
- incomplete
- source database, 1-10
- incomplete repository, 1-9
- installation, 1-5
- installing
- Migration Workbench, 1-6
J
- Java Runtime Environment
- default location, 1-7
L
- logging
- error messages, 1-16
M
- memo columns
- tables, 3-12
- Microsoft Access 2000
- migrating, 3-2
- Microsoft SQL Server 6.0
- support for, 4-2
- migrating
- multiple databases, 1-14
- modifying
- Microsoft Access, 3-11
- multi-character field delimiters, 1-14
- multiple databases, 1-14
O
- object names, 1-5
- duplicates, 1-8
- ODBC
- comparing to outer joints, 4-20
- offline data loading, 4-5
- SQL*Loader, 3-11
- operations
- bitwise, 4-18
- Oracle Transparent Gateway
- comparing, 1-4
- Oracle7 databases, 4-2
- Oracle8
- support, 1-2
- ordering, 1-3
- outer joints
- comparing, 4-20
- converting, 4-19
- migrating, 4-19
P
- parsing
- DUMP commands, 4-10
- EXEC statements, 4-9
- expression handling, 4-10
- LOAD commands, 4-10
- stored procedures, 4-18
- SYSOBJECTS, 4-9
- performance tests, 4-7
- platforms, 1-2
- privileges, 4-3
- pseudo columns, 4-24
- purchasing, 1-3
R
- re-creating
- repository, 1-6
- REF CURSOR
- weak, 1-5
- relations
- within Microsoft Access 95, 3-8
- renaming
- schema objects, 1-13
- replica databases, 3-9
- repository
- creating, 1-6
- incomplete, 1-9
- re-creating, 1-6
- reserved words, 1-8
- result sets, 4-14
- roles, 4-3
- rules
- getDate functions, 4-25
- handling, 4-25
S
- schema objects
- case sensitivity, 1-13
- editing, 4-9
- migrating, 1-13
- renaming, 1-13
- scripts
- Microsoft Access, 3-11
- SQL*Loader, 4-5, 4-7
- source database
- incomplete, 1-10
- SQL statements
- LIKE clause, 4-10
- SQL*Loader
- loading data, 1-10, 1-11
- SQL*Loader scripts, 4-5
- BCP, 4-7
- stored procedures
- DLL statements, 4-18
- migrating, 4-17
- multiple result sets, 4-12
- parsing, 4-18
- support, 1-15
- for Oracle8, 1-2
- for Unix, 1-2
- help, 1-15
T
- table defaults
- editing, 1-14
- tables
- customizing options, 1-14
- memo columns in Microsoft Access, 3-12
- Microsoft SQL Server, 4-4
- testing
- performance, 4-7
- tnsnames.ora file, 1-6
- Oracle home instances, 1-7
U
- Unix
- support, 1-2
- user-defined types
- handling, 4-4
- using
- LIKE clause, 4-10