REST Resource: projects.locations.preferenceSets

Resource: PreferenceSet

The preferences that apply to all assets in a given context.

JSON representation 
{
  "name": string,
  "createTime": string,
  "updateTime": string,
  "displayName": string,
  "description": string,
  "regionPreferences": {
    object (RegionPreferences)
  },
  "virtualMachinePreferences": {
    object (VirtualMachinePreferences)
  },
  "databasePreferences": {
    object (DatabasePreferences)
  }
}
Fields
name

string

Output only. Name of the preference set.
createTime

string (Timestamp format)

Output only. The timestamp when the preference set was created.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".
updateTime

string (Timestamp format)

Output only. The timestamp when the preference set was last updated.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".
displayName

string

User-friendly display name. Maximum length is 63 characters.
description

string

A description of the preference set.
regionPreferences

object (RegionPreferences)

Optional. Region preferences for assets using this preference set. If you are unsure which value to set, the migration service API region is often a good value to start with. If unspecified, VirtualMachinePreferences.RegionPreferences is used.
virtualMachinePreferences

object (VirtualMachinePreferences)

A set of preferences that applies to all virtual machines in the context.
databasePreferences

object (DatabasePreferences)

Optional. A set of preferences that applies to all databases in the context.

DatabasePreferences

DatabasePreferences enables you to create sets of preferences for your migrated databases.

JSON representation 
{
  "mssqlToCloudSqlForSqlServerPreferences": {
    object (SqlServer)
  },
  "mysqlToCloudSqlForMysqlPreferences": {
    object (MySql)
  },
  "postgresqlToCloudSqlForPostgresqlPreferences": {
    object (PostgreSql)
  }
}
Fields
mssqlToCloudSqlForSqlServerPreferences

object (SqlServer)

Optional. Preferences for target SQL Server on Cloud SQL when migrating from source Microsoft SQL server.
mysqlToCloudSqlForMysqlPreferences

object (MySql)

Optional. Preferences for target MySQL on Cloud SQL when migrating from source MySQL.
postgresqlToCloudSqlForPostgresqlPreferences

object (PostgreSql)

Optional. Preferences for target PostgreSQL on Cloud SQL when migrating from source PostgreSQL.

SqlServer

Preferences for SQL Server on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  },
  "multithreading": enum (Multithreading),
  "versionType": enum (VersionType)
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.
multithreading

enum (Multithreading)

Optional. Preferences for multithreading support.
versionType

enum (VersionType)

Optional. Edition of Microsoft SQL version that is used on a Cloud SQL for SQL server instance.

Common

Preferences common to Cloud SQL databases.

JSON representation 
{
  "backup": {
    object (Backup)
  },
  "commitmentPlan": enum (CommitmentPlan),
  "zoneAvailability": enum (CloudSqlZoneAvailability),
  "sizingOptimizationStrategy": enum (SizingOptimizationStrategy),
  "persistentDiskType": enum (PersistentDiskType),
  "edition": enum (CloudSqlEdition)
}
Fields
backup

object (Backup)

Optional. Preferences for database backups.
commitmentPlan

enum (CommitmentPlan)

Optional. Commitment plan to consider when calculating costs.
zoneAvailability

enum (CloudSqlZoneAvailability)

Optional. Preferred zone availability.
sizingOptimizationStrategy

enum (SizingOptimizationStrategy)

Optional. Sizing optimization strategy of the database. Currently supported for Cloud SQL are just two values: SIZING_OPTIMIZATION_STRATEGY_MODERATE and SIZING_OPTIMIZATION_STRATEGY_SAME_AS_SOURCE.

SIZING_OPTIMIZATION_STRATEGY_UNSPECIFIED will behave like SIZING_OPTIMIZATION_STRATEGY_MODERATE.
persistentDiskType

enum (PersistentDiskType)

Optional. Persistent disk type to use. If unspecified, a disk type is recommended based on available usage data. For SQL Server, only SSD is available. For MySQL and PostgreSQL, only STANDARD (HDD) and SSD types are available.
edition

enum (CloudSqlEdition)

Optional. Cloud SQL edition. For SQL Server, only Enterprise is available.

Backup

Preferences for database backups.

JSON representation 
{
  "backupMode": enum (BackupMode)
}
Fields
backupMode

enum (BackupMode)

Optional. Mode of automated backups.

BackupMode

Mode of automated backups.

Enums
BACKUP_MODE_UNSPECIFIED An unspecified database backup mode.
BACKUP_MODE_DISABLED Automatic backups disabled, no additional charges for storage.
BACKUP_MODE_ENABLED Automatic backups enabled, there will be additional charges for storage.

Multithreading

Preferences for multithreading support. See https://cloud.google.com/sql/docs/sqlserver/create-instance#smt-create-instance for more details.

Enums
MULTITHREADING_UNSPECIFIED An unspecified multithreading configuration.
MULTITHREADING_DISABLED No multithreading support.
MULTITHREADING_ENABLED Allow multithreading support.

VersionType

Edition of Microsoft SQL Server version that is used on a Cloud SQL for SQL server instance.

Enums
VERSION_TYPE_UNSPECIFIED Unspecified SQL Server version type.
VERSION_TYPE_AUTO Version will be deduced from the source asset.
VERSION_TYPE_EXPRESS Version will be one of "Express" versions.
VERSION_TYPE_WEB Version will be one of "Web" versions.
VERSION_TYPE_STANDARD Version will be one of "Standard" versions.
VERSION_TYPE_ENTERPRISE Version will be one of "Enterprise" versions.

MySql

Preferences for MySQL on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  }
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.

PostgreSql

Preferences for PostgreSQL on Cloud SQL.

JSON representation 
{
  "common": {
    object (Common)
  }
}
Fields
common

object (Common)

Optional. Preferences to Cloud SQL databases.

Methods

create

 Creates a new preference set in a given project and location.

delete

 Deletes a preference set.

get

 Gets the details of a preference set.

list

 Lists all the preference sets in a given project and location.

patch

 Updates the parameters of a preference set.