Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Tenant databases » Extracting a database (dbcloudextract)

Cloud Extract Database utility (dbcloudextract)

Makes a copy of a database in the cloud, removes the cloud configurations from it, and copies the database to the specified directory.

By default, the database continues running in the cloud. Use this utility to extract databases that are larger than 100 MB and/or have dbspaces; otherwise, use the Cloud Console.

Syntax
dbcloudextract -cc "keyword=value;..." -c "keyword=value;.." directory  [ options ]
Option Description
@data

Environment variable or configuration file to read in data from.

To protect passwords or other information in the configuration file, you can use the File Hiding utility (dbfhide) to encrypt the contents of the configuration file.

-c "UID= database-user-ID ;PWD= db-password ;DBN= database-name "

Database connection string:

  • UID

    User ID of a user with DBA authority to connect to the database (required).

  • PWD

    Password to connect to the database (required).

  • DBN

    Name of the tenant database in the cloud (required).

-cc "HOST= cloud-host-name[: port-number];UID= cloud-user-ID ;PWD= cloud-password "

Cloud connection string:

  • Host

    Host name or comma-separated list of host names or IP addresses (required).

  • Port

    TCP/IP port number.

  • UID

    User ID to connect to the cloud (required).

  • PWD

    Password to connect to the cloud (required).

Additional connection parameters can be specified.

If you specify ENCRYPTION=TLS, then:

  • Specify the TRUSTED_CERTIFICATES protocol option when you are connecting from a non-cloud host.

  • Disable the host name check by specifying skip_certificate_name_check=ON.
directory Directory the database is being extracted to (required). This directory is created if it does not already exist.
-drop Drop the tenant database from the cloud upon successful extraction.
-ek database-encryption-key

Encryption key for the database. See the DatabaseKey (DBKEY) connection parameter in the SQL Anywhere documentation.

Prerequisites
  • The database must be running.

  • The cloud user ID must have the ExtractDatabase privilege.

Remarks

The directory where the database is extracted to must be accessible by the dbcloudextract utility.

You can omit the TCP/IP port number for any host that has a cloud server using the default TCP/IP port.

When large databases are extracted, backup progress messages are displayed every 30 seconds, with the first message appearing 30 seconds after the backup request is made. If a small database is being extracted and the backup takes less than 30 seconds, no backup progress messages are displayed.

Example

To extract the tenant database Tenant1 to the directory C:\MyDirectory and drop it from the cloud, run the following command:

dbcloudextract -cc "UID=admin;PWD=admin;HOST=myhost:2638" -c "UID=DBA;PWD=sql;DBN=Tenant1" 
-drop C:\MyDirectory