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.
dbcloudextract -cc "keyword=value;..." -c "keyword=value;.." directory [ options ]
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:
|-cc "HOST= cloud-host-name[: port-number];UID= cloud-user-ID ;PWD= cloud-password "||
Cloud connection string:
Additional connection parameters can be specified.
If you specify ENCRYPTION=TLS, then:
|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.|
Encryption key for the database. See the DatabaseKey (DBKEY) connection parameter in the SQL Anywhere documentation.
The database must be running.
The cloud user ID must have the ExtractDatabase privilege.
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.
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