GETSTART.PDF

(513 KB) Pobierz
getstart.book
InterBase 6
Getting Started
Borland
®
SOFTWARE CORPORATION
100 Enterprise Way, Scotts Valley, CA 95066 http://www.borland.com
302388044.004.png 302388044.005.png
Borland Software Corporation may have patents and/or pending patent applications covering subject matter in
this document. The furnishing of this document does not convey any license to these patents.
Copyright 2001 BorlandSoftware Corporation. All rights reserved. All InterBase and Borland products are
trademarks or registered trademarks of BorlandSoftware Corporation. Other brand and product names are
trademarks or registered trademarks of their respective holders.
1INT0060WW21000 21006
D4
302388044.006.png
TABLE OF CONTENTS
Table of Contents
CHAPTER 1
System Requirements
Disk space requirements
.......................
5
Windows system requirements
....................
6
UNIX system requirements
......................
6
Linux
..............................
6
Solaris
..............................
6
Requirements for other platforms
..................
6
CHAPTER 2
Installation
Installing InterBase on Windows
..................
7
Installing InterBase on Windows
...............
8
Configuring InterBase
.....................
8
Logging on
...........................
8
Uninstalling InterBase on Windows
.............
9
Installation on UNIX
..........................
9
Preparing to install on UNIX
.................
10
Installing on Solaris
......................
10
Installing on Linux
.......................
13
Running multiple versions on UNIX
.............
16
Uninstalling InterBase on UNIX
...............
16
Installing and accessing InterBase documentation
.......
17
Full-text searching
.......................
17
Links
...............................
18
Installing Acrobat Reader With Search
...........
18
CHAPTER 3
Migrating to InterBase 6
Migration process
..........................
19
Migration Issues
...........................
20
InterBase 6 SQL dialects
...................
20
Servers, databases, and ODS 10
...............
20
Clients and databases
.....................
21
iii
302388044.007.png
Keywords used as identifiers
.................
21
Understanding SQL dialects
..................
22
Setting SQL dialects
.........................
23
Setting
isql
client dialect
....................
23
Setting the gpre client dialect
.................
24
Setting the gfix client dialect
.................
25
New features
.............................
25
Features available in all dialects
...............
25
Features available only in dialect 3 databases
.......
New keywords
.........................
27
Delimited identifiers
......................
28
DATE
,
TIME
, and
TIMESTAMP
datatypes
...........
29
DECIMAL
and
NUMERIC
datatypes
..............
37
Compiled objects
........................
38
Generators
...........................
39
Miscellaneous issues
......................
39
Migrating servers and databases
..................
40
“In-place” server migration
..................
40
Migrating to a new server
...................
42
About InterBase 6, dialect 1 databases
...........
43
Migrating databases to dialect 3
..................
43
Overview
............................
43
Method one: in-place migration
...............
44
Method two: migrating to a new database
.........
49
Migrating clients
...........................
51
IBReplicator migration issues
...................
53
Migrating data from other DBMS products
............
53
iv
INTERBASE 6
26
302388044.001.png
1
System Requirements
Chapter 1
InterBase Server runs on a variety of platforms, including Microsoft Windows NT 4.0,
/Linux
operating systems.
The InterBase server software makes efficient use of system resources on the server node;
the server process uses little more than 1.9MB of memory. Typically, each client
connection to the server adds approximately 115KB of memory. This varies based on the
nature of the client applications and the database design, so this figure is only a baseline
for comparison.
The InterBase client also runs on any of these operating systems. In addition, InterBase
provides the InterClient Java client interface using the JDBC standard for database
connectivity. Client applications written in Java can run on any client platform that
supports Java, even if InterBase does not explicitly list it among its supported platforms.
Examples include
M
acintosh and Internet appliances with embedded Java capabilities.
Disk space requirements
InterBase requires 35 MB for a full install that includes InterBase Server and Client, Adobe
During operation, InterBase’s sorting routine requires additional disk space as scratch
space. The amount of space depends on the volume and type of data the server is
requested to sort.
5
CHAPTER
Windows 2000, Windows 98/ME, and several UNIX
Acrobat Reader, and the full document set. 17MB for InterBase Server and Client alone.
302388044.002.png
 
302388044.003.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin