Add databases to the cloud that are smaller than 100MB and do not have dbspaces.
The database must be version 10 or later.
The user ID and password for a database user:
For version 12 and earlier databases, the user must have DBA authority.
For version 16 and later databases, the user must have the equivalent of the SYS_AUTH_DBA_ROLE compatibility role.
The user ID is stored in the cloud and is used later to connect to the database to perform administrative tasks. The password is discarded once the database has been added to the cloud.
The cloud user must have the AddDatabase cloud privilege.
Conform to the database requirements.
Context and remarks
If a database is larger than 100 MB or has dbspaces, then use the Cloud Add Database utility (dbcloudadd) instead.
A database is always upgraded when it is added to the cloud. By default, the database is upgraded to a version 16 database. When upgrading to a version 16 database, the default in the Cloud Console is to set the system procedures to execute with the privileges of the invoker.
In the Cloud Console, navigate to the Databases panel.
Click Add and follow the instructions.
When specifying a name for the database in the cloud, ensure that it is a unique name among all tenant databases in the cloud and that it conforms to the tenant database name restrictions.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company - SAP SQL Anywhere, on-demand edition 1.0|