SQL Remote User's Guide
Principles of SQL Remote Design
Design overview
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 )
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 )
Ensure trailing blanks are ignored You can do this using the dbinit -b
option.
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.
Remove historical system views You can do this with the dbinit -k
option.
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