Index
A
B
C
D
E
G
H
I
L
M
N
O
P
Q
R
S
T
U
W
Y
Symbols
- @@SERVERNAME, 38
- @@SPID, 38
- @@TRANSTATE, 40
A
- accessing, client applications, 44
- asterisk (*), 41
B
- bitwise operations, 34
C
- case-sensitivity, schema objects, 6
- client applications, 44
- complex case statements, 36
- compliance, Y2K, 46
- configuration file, 5
- creating, repository, 4
- cross-database procedure calls, 34
- customizing, storage options, 42
D
- data loading, constraints, 18
- data loading, controlling files, 19
- data loading, offline, 23
- data types, mapping, 17
- data types, modifying, 17, 18
- DDL commands, 34
- DLL statements, 34
- documentation, Migration Workbench, 3
- download, documentation, 3
- downloading, 2
- dynasets, 31
E
- Editing, table defaults, 42
- email address, 46
- error messages, 4, 7, 8, 9, 14, 16, 19, 44
- errors, 45
G
- global variables, 37, 38, 40
H
- help, 3
I
- IDENTITY columns, 38
- installing, Migration Workbench, 4
L
- logging, errors, 45
M
- Memo columns, 43
- migrating, multiple databases, 6
- Migration Companion CD-ROM, comparing, 8
- modifying, MS Access, 23
- MS Access 2000, 3
- MS SQL Server 6.0, 4
- MS SQL Server databases, 42
- multi-character field delimiters, 19
- multiple databases, 6
- multiple result sets, 29
N
- name resolving, 41
O
- ODBC, comparing to outer joints, 35
- offline data loading, 20
- Oracle Transparent Gateway (OTG), difference between, 8
- Oracle8, 45
- ordering, 2
- outer joints, 35
P
- parsing, 25, 26, 34
- performance tests, 23
- platforms, 45
- privileges, 41
- pseudo columns, 40
- purchasing, 2
Q
- questions, 46
R
- re-creating, repository, 4
- rename, schema objects, 6
- replica database, 13
- repository, create, 4
- repository, re-creating, 4
- reserved words, 7
- result sets, 31
- roles, 41
- rules, 43
S
- schema objects, 6
- schema objects, case sensitivity, 6
- schema objects, renaming, 6
- SQL*Loader, 23
- SQL*Loader scripts, 20
- SQL*Loader scripts, BCP, 22
- SQL*Loader, loading data, 19
- stored procedure, 34
- stored procedures, 29, 33, 34
- support, 3
T
- table defaults, editing, 42
- tables, customizing options, 42
- testing, performance, 23
- tnsnames.ora file, 5
U
- Unix, 3
- user-defined types, 44
W
- weak REF CURSOR, 31
Y
- Y2K compliance, 46