Contents Index Design overview Using compatible sort orders and character sets

SQL Remote User's Guide
  Principles of SQL Remote Design
    Design overview

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. This section provides a brief description only.

To create an Enterprise-compatible Adaptive Server Anywhere database ( Sybase Central )

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.

  4. Make the database case sensitive    You can do this with the dbinit -c option.

The following command creates a case-sensitive database named test.db in the current directory, using the current dbo user, ignoring trailing blanks, and removing historical system views:

dbinit -b -c -k test.db

Contents Index Design overview Using compatible sort orders and character sets