コード例 #1
0
 /// <summary>
 /// Creates UpgradeDatabaseHint from database object by using same edition and SLO from upgrade hint.
 /// </summary>
 /// <param name="database">Database object</param>
 /// <returns>Returns UpgradeDatabaseHint</returns>
 private RecommendedDatabaseProperties CreateUpgradeDatabaseHint(Management.Sql.LegacySdk.Models.Database database)
 {
     return(new RecommendedDatabaseProperties()
     {
         Name = database.Name,
         TargetEdition = SloToEdition(database.Properties.UpgradeHint.TargetServiceLevelObjective),
         TargetServiceLevelObjective = database.Properties.UpgradeHint.TargetServiceLevelObjective
     });
 }
コード例 #2
0
        /// <summary>
        /// Construct AzureSqlDatabaseModel from Management.Sql.LegacySdk.Models.Database object
        /// </summary>
        /// <param name="resourceGroup">Resource group</param>
        /// <param name="serverName">Server name</param>
        /// <param name="database">Database object</param>
        public AzureSqlDatabaseModel(string resourceGroup, string serverName, Management.Sql.LegacySdk.Models.Database database)
        {
            Guid id = Guid.Empty;

            ResourceGroupName           = resourceGroup;
            ServerName                  = serverName;
            CollationName               = database.Properties.Collation;
            CreationDate                = database.Properties.CreationDate;
            CurrentServiceObjectiveName = database.Properties.ServiceObjective;
            MaxSizeBytes                = database.Properties.MaxSizeBytes;
            DatabaseName                = database.Name;
            Status              = database.Properties.Status;
            Tags                = TagsConversionHelper.CreateTagDictionary(TagsConversionHelper.CreateTagHashtable(database.Tags), false);
            ElasticPoolName     = database.Properties.ElasticPoolName;
            Location            = database.Location;
            ResourceId          = database.Id;
            CreateMode          = database.Properties.CreateMode;
            EarliestRestoreDate = database.Properties.EarliestRestoreDate;

            Guid.TryParse(database.Properties.CurrentServiceObjectiveId, out id);
            CurrentServiceObjectiveId = id;

            Guid.TryParse(database.Properties.DatabaseId, out id);
            DatabaseId = id;

            Edition = database.Properties.Edition;

            Guid.TryParse(database.Properties.RequestedServiceObjectiveId, out id);
            RequestedServiceObjectiveId = id;

            DatabaseReadScale readScale;

            if (Enum.TryParse <DatabaseReadScale>(database.Properties.ReadScale, true, out readScale))
            {
                ReadScale = readScale;
            }

            ZoneRedundant                    = false;
            AutoPauseDelayInMinutes          = null;
            MinimumCapacity                  = null;
            ReadReplicaCount                 = null;
            HighAvailabilityReplicaCount     = null;
            CurrentBackupStorageRedundancy   = null;
            RequestedBackupStorageRedundancy = null;
            SecondaryType                    = null;
            MaintenanceConfigurationId       = null;
            EnableLedger = false;
        }
コード例 #3
0
        /// <summary>
        /// Construct AzureSqlDatabaseModel from Management.Sql.LegacySdk.Models.Database object
        /// </summary>
        /// <param name="resourceGroup">Resource group</param>
        /// <param name="serverName">Server name</param>
        /// <param name="database">Database object</param>
        public AzureSqlDatabaseModel(string resourceGroup, string serverName, Management.Sql.LegacySdk.Models.Database database)
        {
            Guid              id        = Guid.Empty;
            DatabaseEdition   edition   = DatabaseEdition.None;
            DatabaseReadScale readScale = DatabaseReadScale.Enabled;

            ResourceGroupName           = resourceGroup;
            ServerName                  = serverName;
            CollationName               = database.Properties.Collation;
            CreationDate                = database.Properties.CreationDate;
            CurrentServiceObjectiveName = database.Properties.ServiceObjective;
            MaxSizeBytes                = database.Properties.MaxSizeBytes;
            DatabaseName                = database.Name;
            Status              = database.Properties.Status;
            Tags                = TagsConversionHelper.CreateTagDictionary(TagsConversionHelper.CreateTagHashtable(database.Tags), false);
            ElasticPoolName     = database.Properties.ElasticPoolName;
            Location            = database.Location;
            ResourceId          = database.Id;
            CreateMode          = database.Properties.CreateMode;
            EarliestRestoreDate = database.Properties.EarliestRestoreDate;

            Guid.TryParse(database.Properties.CurrentServiceObjectiveId, out id);
            CurrentServiceObjectiveId = id;

            Guid.TryParse(database.Properties.DatabaseId, out id);
            DatabaseId = id;

            Enum.TryParse <DatabaseEdition>(database.Properties.Edition, true, out edition);
            Edition = edition;

            Guid.TryParse(database.Properties.RequestedServiceObjectiveId, out id);
            RequestedServiceObjectiveId = id;

            Enum.TryParse <DatabaseReadScale>(database.Properties.ReadScale, true, out readScale);
            ReadScale = readScale;

            ZoneRedundant = false;
        }
コード例 #4
0
 /// <summary>
 /// Converts the response from the service to a powershell database object
 /// </summary>
 /// <param name="resourceGroup">The resource group the server is in</param>
 /// <param name="serverName">The name of the Azure Sql Database Server</param>
 /// <param name="database">The service response</param>
 /// <returns>The converted model</returns>
 public static AzureSqlDatabaseModelExpanded CreateExpandedDatabaseModelFromResponse(string resourceGroup, string serverName, Management.Sql.LegacySdk.Models.Database database)
 {
     return(new AzureSqlDatabaseModelExpanded(resourceGroup, serverName, database));
 }
コード例 #5
0
 /// <summary>
 /// Construct AzureSqlDatabaseModelExpanded from Management.Sql.LegacySdk.Models.Database object
 /// </summary>
 /// <param name="resourceGroup">Resource group</param>
 /// <param name="serverName">Server name</param>
 /// <param name="database">Database object</param>
 public AzureSqlDatabaseModelExpanded(string resourceGroup, string serverName, Management.Sql.LegacySdk.Models.Database database) : base(resourceGroup, serverName, database)
 {
     if (database.Properties.ServiceTierAdvisors != null &&
         database.Properties.ServiceTierAdvisors.Count > 0)
     {
         ServiceTierAdvisor = database.Properties.ServiceTierAdvisors[0].Properties;
     }
 }