User's Manual

Design overview
This chapter describes general publication design issues that you must
address when designing a SQL Remote installation. It also describes how
SQL Remote replicates data.
Design at the
consolidated database
Like all SQL Remote administrative tasks, design is carried out by a
database administrator or system administrator at the consolidated database.
The Adaptive Server Enterprise System Administrator or database
administrator should perform all SQL Remote configuration tasks.
Ensuring compatible databases
You should ensure that all databases participating in a SQL Remote
installation are compatible in terms of sort orders, character sets, and
database option settings.
If your installation includes both Adaptive Server Enterprise and Adaptive
Server Anywhere databases, you should ensure your Adaptive Server
Anywhere databases are created in an Adaptive Server
Enterprise-compatible fashion.
☞ For a full description of how to create Enterprise-compatible Adaptive
Server Anywhere databases, see “Creating a Transact-SQL-compatible
database” [ASA SQL User’s Guide, page 483]. This section provides a brief
description only.
❖ To create an Enterprise-compatible Adaptive Server Anywhere
database ( Sybase Central )
1. The Create Database wizard provides a button that sets each of the
available choices to emulate Adaptive Server Enterprise. This is the
simplest way to create a Transact-SQL-compatible database.
❖ To create an Enterprise-compatible Adaptive Server Anywhere
database ( Command line )
1. Ensure trailing blanks are ignored You can do this using the dbinit -b
option.
2. Ensure the dbo user ID is set If you have a database that already has a
user ID named dbo, then you can transfer the ownership of the Adaptive
Server Anywhere Transact-SQL system views to another user ID. You
can do this using the dbinit -g option.
3. Remove historical system views You can do this with the dbinit -k
option.
74