Azure SQL Database is a fully managed platform as a service (PaaS) database engine that automates backups and other operational tasks and is always running on the latest stable version of SQL Server. For many general-purpose workloads, Azure SQL Database can be a very cost-effective alternative to running the full SQL Server product, so it is a common scenario to move databases from SQL Server to Azure SQL Database.
Why move from Amazon RDS for SQL Server to Azure SQL Database?
Amazon RDS for SQL Server is a popular choice for SQL Server workloads in the cloud. It provides a fully managed relational database service that offers SQL Server 2014, 2016, 2017, and 2019 while offloading database administration tasks like managing backups. However, Azure SQL Database can provide additional benefits not available in Amazon RDS for SQL Server:
Licensing Cost. When you set up an Amazon RDS DB instance for Microsoft SQL Server, the software license is included; it cannot be purchased separately. In Azure you can take advantage of Azure Hybrid Benefit, which allows you to use existing SQL Server licenses with Software Assurance to pay a reduced rate on Azure SQL Database, usually saving over 35%-50% in licensing costs.
Free built-in High Availability and Zone Redundancy. Amazon RDS for SQL Server provides high availability by offering Multi-AZ DB instances, which are implemented using either SQL Server Database Mirroring or SQL Server AlwaysOn Availability Groups to provide zone redundancy. AWS Multi-AZ deployments cost extra, as much as twice the cost of Single-AZ deployments. Azure SQL Database high availability is achieved by using multiple compute nodes which are provided even in the lower price Basic, Standard and General Purpose service tiers. With Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region to provide zone-redundant availability at no extra cost.
Always up to date SQL. When you set up an Amazon RDS DB instance for Microsoft SQL Server, you must specify the version of SQL Server to use. When Amazon RDS supports a new version of a database engine, you can upgrade your DB instances to the new version; however, this is a manual process that requires some downtime, not much different as if it were a regular SQL Server VM. In Azure, SQL is always up to date with the latest updates and patches being automatically applied, eliminating end-of-support hassles.
Elastic Pools. Azure SQL Database elastic pools are a cost-effective solution for managing a group of databases that have varying and unpredictable usage patterns. This is a common problem for software-as-a-service (SaaS) developers, who usually create one database per customer but can end up with overprovisioned resources because of the unpredictability of customer usage patterns. Elastic pools solve this problem by ensuring that databases get the performance resources they need when they need it. They provide a simple resource allocation mechanism within a predictable budget. Amazon RDS for SQL Server lacks an elastic option for these scenarios.
Serverless.Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Serverless is a cost-effective choice for databases with intermittent, unpredictable usage patterns that can afford some delay in compute warm-up after idle usage periods. Amazon RDS for SQL Server does not offer a serverless option.
Large databases. Amazon RDS for SQL Server maximum database size is 16TB. The Hyperscale service tier in Azure SQL Database supports up to 100TB.
Moving databases from these systems into Azure SQL Database can be achieved using various mechanisms; the main options are:
Migration option
Comments
Import/Export Service (BACPAC)
It is the easiest to use and is integrated with SQL Server Management Studio. However, it requires additional storage and downtime because data is exported at the source, possibly copied to another location and then imported at the destination. It can also take a long time to process databases with many objects.
Data Migration Assistant
Migrates schema and data.
Good for medium-sized deployments (i.e., small number of databases).
Azure Database Migration Service
Ideal for migrations at scale (i.e., large databases or many databases).
This article focuses on the Amazon RDS for SQL Server scenario; describes a common problem that you might face when migrating to Azure SQL Database, provides some options to work around it, and a practical guide using three possible migration methods. The topic is divided in two parts: Part 1 covers the use of the Import/Export Service (BACPAC) and the Data Migration Assistant. Part 2 will cover the migration using the Azure Database Migration Service.
The problem with admin
When you create a database in Amazon RDS for SQL Server, the AWS console suggests admin as the name for the system administrator account.
Specifying the Master username when creating a new RDS SQL database
This value can be changed, but many people just accept the default when configuring a new database. This would not present a problem if the database were to be later migrated to SQL Server or to Azure SQL Managed Instance, but it turns out that ‘admin’ is not a valid login name in Azure SQL Database. For example, consider the following T-SQL statement:
CREATE LOGIN [admin] WITH PASSWORD=N'S0meP@ssword!'
This statement would work against SQL Server or Azure SQL Managed Instance, resulting in the creation of a server login called ‘admin’. If the same statement is run against Azure SQL Database, it will result in the following error
Msg 40616, Level 16, State 1, Line 5 'admin' is not a valid login name in this version of SQL Server.
During migration from Amazon RDS for SQL Server to Azure SQL Database, the problem with the ‘admin’ login is that even though the SQL Server logins are defined at the server level and not at the database level, the migration tools will include server logins along with the database. Therefore, they will fail when attempting to create the login in the target server. For example, when using the Import/Export (BACPAC) feature, SQL Server Management Studio will throw the following error during import:
BACPAC Import error caused by presence of 'admin' login
The specific error is highlighted below:
Error SQL72014: .Net SqlClient Data Provider: Msg 40616, Level 16, State 1, Line 1 'admin' is not a valid login name in this version of SQL Server.
Data Migration Assistant would also throw a similar error:
Data Migration Assistant deploy schema error caused by presence of 'admin' login
Solution alternatives
There are a couple of options to work around this problem:
Rename the ‘admin’ login in the source RDS server prior to the migration.
Skip the ‘admin’ login when generating the scripts to be deployed to the destination Azure SQL Database and create an alternate login in the target database (with a name different to ‘admin’).
Rename the ‘admin’ login in the source Amazon RDS for SQL Server
This option sounds obvious, but it is not necessarily a feasible option in all cases. Renaming the login to something other than ‘admin’ prior to exporting from Amazon RDS for SQL Server will ensure that the BACPAC will work when importing it into the target Azure SQL Database.
To implement this option, connect to the source Amazon RDS for SQL Server instance using a query tool such as SQL Server Management Studio, select the master database, and run an ALTER LOGIN T-SQL statement. For example:
ALTER LOGIN [admin] WITH NAME = [rdsadmin];
After renaming the login, SQL Server will re-map the corresponding ‘admin’ database user to the new server login (i.e., the server login will have a new name, but the database user based on that login will continue to be called ‘admin’). Note that if you were connected using the ‘admin’ account in SQL Server Management Studio, the connection to the server will be broken after executing the statement because the ‘admin’ login is no longer valid. You will have to re-connect using the new login name to continue working in SQL Server Management Studio.
After the ‘admin’ login has been renamed at the source, you can use any of the three methods mentioned earlier (Import/Export BACPAC, Data Migration Assistant, Azure Database Migration Service) to migrate the database.
Note
If an application relies on connecting to the database using the ‘admin’ login specifically, it will have to be modified or reconfigured so it can use a different login. If this is not possible (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
In some cases, it might not be possible to rename the ‘admin’ account at the source:
If some application still requires access to the source server using the ‘admin’ login.
If you are not allowed to make any changes to the source system prior or during the migration.
If these restrictions apply to your scenario, you should use the approach described in the next section.
Create an alternate ‘admin’ login in the target Azure SQL Database
If renaming the ‘admin’ login in the source Amazon RDS for SQL Server instance is not possible, an alternative approach could be to avoid creating the ‘admin’ login when migrating the schema; instead, create a login with a different name in the target Azure SQL Database server and then create a database user named ‘admin’ based on that login.
Note
Having a database user named ‘admin’ will ease migration of applications and existing T-SQL code that relies on that specific database username. However, it will still be required for the application to connect using a login different to ‘admin’. If it is not possible to modify or reconfigure the application so it can use a different login. (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
This approach can be implemented with a combination of SQL Server Enterprise Manager and the Data Migration Assistant (DMA) tool:
Use SQL Server Enterprise Manager to manually create a new login in the target Azure SQL Database server.
After the login has been created, use the Data Migration Assistant (DMA) and specify to skip the creation of login/user when migrating the schema.
After you determine which approach you can use, you should choose the migration tool for your scenario. The following table provides a guide on how to choose.
Solution approach
Migration tool options
Rename the ‘admin’ login at the source Amazon RDS for SQL Server
· Import/Export Service (BACPAC)
· Data Migration Assistant
· Azure Database Migration Service
Create an alternate ‘admin’ login in the target Azure SQL Database
· Data Migration Assistant
· Azure Database Migration Service
Using the Import/Export Service (BACPAC)
A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from the database. A BACPAC file can be stored in Azure Blob storage or in local storage in an on-premises computer and later imported back into Azure SQL Database.
Note
Only use this option if you have renamed the ‘admin’ user at the source Amazon RDS for SQL Server instance.
Using the Import/Export Service (BACPAC)
The BACPAC file can be generated using SQL Server Management Studio or the SQLPackage.exe command-line utility. The following step-by-step instructions guide you through the Import/Export process using SQL Server Management Studio.
Export the source database into a BACPAC file
Open SQL Server Management Studio and connect to the Amazon RDS for SQL Server instance as if connecting to a regular SQL Server Database Engine (in the server name, specify the endpoint of the Amazons RDS for SQL Server instance).
In the Object Explorer pane, expand the Databases node, right-click the desired database, point to Tasks, and then select Export Data-tier Application:
Starting the Export Data-tier Application wizard
The Export Data-tier Application dialog box appears.
Export Data-tier Application wizard
Select Next, and then, on the Export Settings page, specify a location to store the BACPAC file.
It can be a local path (Save to local disk), or a container in an Azure Storage account (Save to Microsoft Azure). Note that the Save to Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation completes.
Export Settings
Select Next.
On the Summary page, confirm that the settings are correct, and then select Finish.
Export Summary
When the process finishes, the Results page appears.
Export Results
Confirm that all the steps completed successfully, and then select Close.
Import the BACPAC file into the target database
In SQL Server Management Studio, connect to the target Azure SQL Database specifying the corresponding server name.
In the Object Explorer pane, right-click on the Databases node, and then select Import Data-tier Application.
Starting the Import Data-tier Application wizard
The Import Data-tier Application dialog box appears.
Import Data-tier Application wizard
Select Next, and then, on the Import Settings page, specify the location of the BACPAC file.
The source BACPAC file can be in local disk (Import from local disk), or in a container in an Azure Storage account (Import from Microsoft Azure). Note that the Import from Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation is complete. Import Settings
Select Next, and then on the Database Settings page, specify the basic configuration settings for the new database: - New database name. - Edition: Basic, Standard or Premium for DTU-based purchasing model; General Purpose or Business Critical for vCore-based purchasing model. - Maximum database size (GB). - Service Objective: DTUs or Compute Hardware for the selected edition; for example, S1 for DTU Standard or GP_Gen5_8 for vCore General Purpose.
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
Database Settings
Select Next, and then on Summary page, confirm that the settings are correct.
Import Summary
Select Finish.
When the process is complete, the Results page appears.
Import Results
Select Close, and then refresh and expand the Databases node.
The new database should appear there.
Using the Data Migration Assistant (DMA)
The Data Migration Assistant (DMA) provides two core capabilities:
Analyses the source system and detects potential compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
Migrates schema and data between source and target databases.
Using the Data Migration Assistant (DMA)
Perform an Assessment
The following step-by-step instructions guide through the process of performing an assessment for migrating from Amazon RDS for SQL Server to Azure SQL Database.
Download Data Migration Assistant for free from the Microsoft Download Center., and then install it.
Start DMA, select the New (+) icon, and then select the Assessment project type.
Under Project name, specify a name for the assessment.
Under Assessment type, select Database Engine.
Under Source server type, select AWS RDS for SQL Server.
Under Target server type, select Azure SQL Database, and then select Create.
On the Options page, select Check database compatibility, and then select Next.
Assessment options
In the Connect to a server pane, enter the server name and authentication credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to server
On the Add sources pane, select the databases to assess, and then select Add.
Add sources
The Select sources page shows the list of selected databases.
Start Assessment
Select Start Assessment.
When the process completes, the Review results page appears, showing the results of the assessment.
Verify that the assessment completed successfully (green ticks).
If the assessment returns any errors due to compatibility issues, you will need to address them before attempting to migrate the database.
Assessment results
Create the target database
Unlike the BACPAC import, which creates a new database, DMA migrates schema and data to an existing database. Therefore, you must create a new database before running the migration. There are a variety of tools that can be used to create a new database, including the Azure Portal and PowerShell. A quick guide is available here:
Quickstart: Create a single database - Azure SQL Database
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
Create the replacement admin login
Open SQL Server Management Studio, connect to the server hosting the new Azure SQL Database created in the previous step, and run the following statement against the master database to create a new login instead of ‘admin’ (the sample code below uses ‘newadmin’):
CREATE LOGIN [newadmin] WITH PASSWORD=N'S0meP@ssword!' GO
Migrate Schema
Once the target Azure SQL Database has been created and it has a new replacement admin login, open Data Migration Assistant to proceed with the migration of the schema from the source Amazon RDS for SQL Server to the target Azure SQL Database.
Select the New (+) icon, and then select the Migration project type.
Under Project name, specify a name for the migration.
Under Source server type, select SQL Server.
Under Target server type, select Azure SQL Database.
Under Migration scope, select Schema only., and then select Create.
New Migration project (Schema)
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and the select Connect.
Connect to source server
The right pane shows a list of databases available on the source server.
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Next.
Select source database
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane shows a list of databases available on the target server
Select the destination database, and then select Next.
Select target database
On the Select objects page, scroll down to the bottom of the list, deselect Users / admin, and then select Generate SQL script.
Select objects
The Script & deploy schema page appears, showing the DMA Schema Migration Deployment Script.
Generated script
Select the Generated script text box, and the add the following lines to the top of the script:
/****** Manually add admin database user and link it to new admin login ******/ IF NOT EXISTS (SELECT * FROM sys.sysusers WHERE name = N'admin') CREATE USER [admin] FOR LOGIN [newadmin] WITH DEFAULT_SCHEMA=[dbo] GO
The window should now look like this:
Add the code to create the 'admin' database user
Select Deploy schema.
When the process finishes, verify that all the statements were completed successfully:
Deploy schema results
Migrate Data
After the target Azure SQL Database has been created and the schema has been deployed, you can use Data Migration Assistant to proceed with the migration of the data from the source Amazon RDS for SQL Server to the target Azure SQL Database.
Select the New (+) icon, and then select the Migration project type.
Under Project name, specify a name for the migration.
Under Source server type, select SQL Server.
Under Target server type, select Azure SQL Database.
Under Migration scope, select Data only, and then select Create.
New Migration project (Data)
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to source server
The right pane will show a list of databases available on the source server.
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Connect.
Select source database
Select Next.
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane will show a list of databases available on the target server.
Select the destination database, and then select Next.
Select destination database
The Select tables page will show the list of tables with row counts.
Select tables as appropriate, and then select Start data migration:
Select tables
The Migrate data page shows progress.
When the process is finished, verify that all tables were migrated successfully.
Migration results
The migration is now complete.
Conclusion
We have covered two mechanisms to migrate Amazon RDS for SQL Server databases to Azure SQL Database: using the Import/Export Service (BACPAC) and using the Data Migration Assistant (DMA). These tools are easy to use and work well for small-to-medium deployments. In part 2 we will cover the use of the Azure SQL migration extension for Azure Data Studio in combination with the Azure Database Migration Service, which provides more control over the migration and is better suited for migration at scale.
Updated Dec 08, 2022
Version 1.0
No CommentsBe the first to comment
Share
"}},"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserRegistrationDate\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserRegistrationDate-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeAvatar-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeDescription\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeDescription-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1731977288000"}],"cachedText({\"lastModified\":\"1731977288000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeIcon\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1731977288000"}]},"CachedAsset:pages-1736155800202":{"__typename":"CachedAsset","id":"pages-1736155800202","value":[{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"UserBlogPermissions.Page","type":"COMMUNITY","urlPath":"/c/user-blog-permissions/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"AllEvents","type":"CUSTOM","urlPath":"/Events","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"KhorosSignInPage","type":"USER","urlPath":"/kh-signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"CommunityHub.Page","type":"CUSTOM","urlPath":"/Directory","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730142000000,"localOverride":null,"page":{"id":"AllBlogs.Page","type":"CUSTOM","urlPath":"/blogs","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1736155800202,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Deleted","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"false","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MMM dd yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":"en","possibleValues":["en-US"]}},"deleted":false,"repliesSortOrderSetting":{"__typename":"RepliesUserSortOrderSetting","sortOrder":{"__typename":"InheritableStringSettingWithPossibleValues","key":"config.user_replies_sort_order","value":"DEFAULT"}}},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"Category:category:AzureDatabases":{"__typename":"Category","id":"category:AzureDatabases","entityType":"CATEGORY","displayId":"AzureDatabases","nodeType":"category","depth":3,"title":"Azure Data","shortTitle":"Azure Data","parent":{"__ref":"Category:category:products-services"}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Category:category:communities":{"__typename":"Category","id":"category:communities","displayId":"communities","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Communities","entityType":"CATEGORY","shortTitle":"Communities"},"Category:category:products-services":{"__typename":"Category","id":"category:products-services","displayId":"products-services","nodeType":"category","depth":2,"parent":{"__ref":"Category:category:communities"},"title":"Products","entityType":"CATEGORY","shortTitle":"Products"},"Blog:board:MicrosoftDataMigration":{"__typename":"Blog","id":"board:MicrosoftDataMigration","entityType":"BLOG","displayId":"MicrosoftDataMigration","nodeType":"board","depth":4,"conversationStyle":"BLOG","title":"Microsoft Data Migration Blog","description":"","avatar":null,"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:AzureDatabases"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:communities"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:products-services"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:AzureDatabases"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"shortTitle":"Microsoft Data Migration Blog","repliesSortOrderProperties":{"__typename":"RepliesSortOrderProperties","sortOrder":"REVERSE_PUBLISH_TIME"},"tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":false,"tagType":"FREEFORM_AND_PRESET"},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/cmstNC05WEo0blc\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/cmstNC05WEo0blc","height":512,"width":512,"mimeType":"image/png"},"Rank:rank:4":{"__typename":"Rank","id":"rank:4","position":5,"name":"Microsoft","color":"333333","icon":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/cmstNC05WEo0blc\"}"},"rankStyle":"OUTLINE"},"User:user:1463586":{"__typename":"User","id":"user:1463586","uid":1463586,"login":"luisfsilva","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/dS0xNDYzNTg2LTM5MjY3MWkzMjg3NjgzQjg1OTY1Nzcw"},"rank":{"__ref":"Rank:rank:4"},"email":"","messagesCount":1,"biography":null,"topicsCount":1,"kudosReceivedCount":1,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-07-21T20:23:03.365-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"BlogTopicMessage:message:3673151":{"__typename":"BlogTopicMessage","uid":3673151,"subject":"Migrate databases from Amazon RDS for SQL Server to Azure SQL Database – Part 1","id":"message:3673151","revisionNum":21,"author":{"__ref":"User:user:1463586"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Blog:board:MicrosoftDataMigration"},"conversation":{"__ref":"Conversation:conversation:3673151"},"messagePolicies":{"__typename":"MessagePolicies","canPublishArticleOnEdit":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_edit_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_edit_workflow_action.accessDenied","args":[]}},"canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":null},"shortScheduledTimezone":null},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3673151"},"teaser":"
Learn about the migration path from Amazon RDS for SQL Server to Azure SQL Database and overcoming common problems.
\n
","body":"
Introduction
\n
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that automates backups and other operational tasks and is always running on the latest stable version of SQL Server. For many general-purpose workloads, Azure SQL Database can be a very cost-effective alternative to running the full SQL Server product, so it is a common scenario to move databases from SQL Server to Azure SQL Database.
\n
\n
Why move from Amazon RDS for SQL Server to Azure SQL Database?
\n
Amazon RDS for SQL Server is a popular choice for SQL Server workloads in the cloud. It provides a fully managed relational database service that offers SQL Server 2014, 2016, 2017, and 2019 while offloading database administration tasks like managing backups. However, Azure SQL Database can provide additional benefits not available in Amazon RDS for SQL Server:
\n
\n
Licensing Cost. When you set up an Amazon RDS DB instance for Microsoft SQL Server, the software license is included; it cannot be purchased separately. In Azure you can take advantage of Azure Hybrid Benefit, which allows you to use existing SQL Server licenses with Software Assurance to pay a reduced rate on Azure SQL Database, usually saving over 35%-50% in licensing costs.
\n
Free built-in High Availability and Zone Redundancy. Amazon RDS for SQL Server provides high availability by offering Multi-AZ DB instances, which are implemented using either SQL Server Database Mirroring or SQL Server AlwaysOn Availability Groups to provide zone redundancy. AWS Multi-AZ deployments cost extra, as much as twice the cost of Single-AZ deployments. Azure SQL Database high availability is achieved by using multiple compute nodes which are provided even in the lower price Basic, Standard and General Purpose service tiers. With Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region to provide zone-redundant availability at no extra cost.
\n
Always up to date SQL. When you set up an Amazon RDS DB instance for Microsoft SQL Server, you must specify the version of SQL Server to use. When Amazon RDS supports a new version of a database engine, you can upgrade your DB instances to the new version; however, this is a manual process that requires some downtime, not much different as if it were a regular SQL Server VM. In Azure, SQL is always up to date with the latest updates and patches being automatically applied, eliminating end-of-support hassles.
\n
Elastic Pools. Azure SQL Database elastic pools are a cost-effective solution for managing a group of databases that have varying and unpredictable usage patterns. This is a common problem for software-as-a-service (SaaS) developers, who usually create one database per customer but can end up with overprovisioned resources because of the unpredictability of customer usage patterns. Elastic pools solve this problem by ensuring that databases get the performance resources they need when they need it. They provide a simple resource allocation mechanism within a predictable budget. Amazon RDS for SQL Server lacks an elastic option for these scenarios.
\n
Serverless.Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Serverless is a cost-effective choice for databases with intermittent, unpredictable usage patterns that can afford some delay in compute warm-up after idle usage periods. Amazon RDS for SQL Server does not offer a serverless option.
\n
Large databases. Amazon RDS for SQL Server maximum database size is 16TB. The Hyperscale service tier in Azure SQL Database supports up to 100TB.
Moving databases from these systems into Azure SQL Database can be achieved using various mechanisms; the main options are:
\n
\n
\n\n
\n
\n
Migration option
\n
\n
\n
Comments
\n
\n
\n
\n
\n
Import/Export Service (BACPAC)
\n
\n
\n
It is the easiest to use and is integrated with SQL Server Management Studio. However, it requires additional storage and downtime because data is exported at the source, possibly copied to another location and then imported at the destination. It can also take a long time to process databases with many objects.
\n
\n
\n
\n
\n
Data Migration Assistant
\n
\n
\n
Migrates schema and data.
\n
Good for medium-sized deployments (i.e., small number of databases).
\n
\n
\n
\n
\n
Azure Database Migration Service
\n
\n
\n
Ideal for migrations at scale (i.e., large databases or many databases).
\n
\n
\n\n
\n
\n
This article focuses on the Amazon RDS for SQL Server scenario; describes a common problem that you might face when migrating to Azure SQL Database, provides some options to work around it, and a practical guide using three possible migration methods. The topic is divided in two parts: Part 1 covers the use of the Import/Export Service (BACPAC) and the Data Migration Assistant. Part 2 will cover the migration using the Azure Database Migration Service.
\n
\n
The problem with admin
\n
When you create a database in Amazon RDS for SQL Server, the AWS console suggests admin as the name for the system administrator account.
\n
\n
Specifying the Master username when creating a new RDS SQL database
\n
\n
This value can be changed, but many people just accept the default when configuring a new database. This would not present a problem if the database were to be later migrated to SQL Server or to Azure SQL Managed Instance, but it turns out that ‘admin’ is not a valid login name in Azure SQL Database. For example, consider the following T-SQL statement:
\n
\n
CREATE LOGIN [admin] WITH PASSWORD=N'S0meP@ssword!'
\n
\n
This statement would work against SQL Server or Azure SQL Managed Instance, resulting in the creation of a server login called ‘admin’. If the same statement is run against Azure SQL Database, it will result in the following error
\n
\n
Msg 40616, Level 16, State 1, Line 5 'admin' is not a valid login name in this version of SQL Server.
\n
\n
During migration from Amazon RDS for SQL Server to Azure SQL Database, the problem with the ‘admin’ login is that even though the SQL Server logins are defined at the server level and not at the database level, the migration tools will include server logins along with the database. Therefore, they will fail when attempting to create the login in the target server. For example, when using the Import/Export (BACPAC) feature, SQL Server Management Studio will throw the following error during import:
\n
\n
BACPAC Import error caused by presence of 'admin' login
\n
\n
The specific error is highlighted below:
\n
\n
Error SQL72014: .Net SqlClient Data Provider: Msg 40616, Level 16, State 1, Line 1 'admin' is not a valid login name in this version of SQL Server.
\n
\n
Data Migration Assistant would also throw a similar error:
\n
\n
Data Migration Assistant deploy schema error caused by presence of 'admin' login
\n
\n
Solution alternatives
\n
There are a couple of options to work around this problem:
\n
\n
Rename the ‘admin’ login in the source RDS server prior to the migration.
\n
Skip the ‘admin’ login when generating the scripts to be deployed to the destination Azure SQL Database and create an alternate login in the target database (with a name different to ‘admin’).
\n
\n
\n
Rename the ‘admin’ login in the source Amazon RDS for SQL Server
\n
This option sounds obvious, but it is not necessarily a feasible option in all cases. Renaming the login to something other than ‘admin’ prior to exporting from Amazon RDS for SQL Server will ensure that the BACPAC will work when importing it into the target Azure SQL Database.
\n
\n
To implement this option, connect to the source Amazon RDS for SQL Server instance using a query tool such as SQL Server Management Studio, select the master database, and run an ALTER LOGIN T-SQL statement. For example:
\n
\n
ALTER LOGIN [admin] WITH NAME = [rdsadmin];
\n
\n
After renaming the login, SQL Server will re-map the corresponding ‘admin’ database user to the new server login (i.e., the server login will have a new name, but the database user based on that login will continue to be called ‘admin’). Note that if you were connected using the ‘admin’ account in SQL Server Management Studio, the connection to the server will be broken after executing the statement because the ‘admin’ login is no longer valid. You will have to re-connect using the new login name to continue working in SQL Server Management Studio.
\n
\n
After the ‘admin’ login has been renamed at the source, you can use any of the three methods mentioned earlier (Import/Export BACPAC, Data Migration Assistant, Azure Database Migration Service) to migrate the database.
\n
\n
Note
\n
If an application relies on connecting to the database using the ‘admin’ login specifically, it will have to be modified or reconfigured so it can use a different login. If this is not possible (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
\n
\n
In some cases, it might not be possible to rename the ‘admin’ account at the source:
\n
\n
If some application still requires access to the source server using the ‘admin’ login.
\n
If you are not allowed to make any changes to the source system prior or during the migration.
\n
\n
If these restrictions apply to your scenario, you should use the approach described in the next section.
\n
\n
Create an alternate ‘admin’ login in the target Azure SQL Database
\n
If renaming the ‘admin’ login in the source Amazon RDS for SQL Server instance is not possible, an alternative approach could be to avoid creating the ‘admin’ login when migrating the schema; instead, create a login with a different name in the target Azure SQL Database server and then create a database user named ‘admin’ based on that login.
\n
Note
\n
Having a database user named ‘admin’ will ease migration of applications and existing T-SQL code that relies on that specific database username. However, it will still be required for the application to connect using a login different to ‘admin’. If it is not possible to modify or reconfigure the application so it can use a different login. (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
\n
\n
This approach can be implemented with a combination of SQL Server Enterprise Manager and the Data Migration Assistant (DMA) tool:
\n
\n
Use SQL Server Enterprise Manager to manually create a new login in the target Azure SQL Database server.
\n
After the login has been created, use the Data Migration Assistant (DMA) and specify to skip the creation of login/user when migrating the schema.
\n
\n
\n
After you determine which approach you can use, you should choose the migration tool for your scenario. The following table provides a guide on how to choose.
\n
\n
\n\n
\n
\n
Solution approach
\n
\n
\n
Migration tool options
\n
\n
\n
\n
\n
Rename the ‘admin’ login at the source Amazon RDS for SQL Server
\n
\n
\n
· Import/Export Service (BACPAC)
\n
· Data Migration Assistant
\n
· Azure Database Migration Service
\n
\n
\n
\n
\n
Create an alternate ‘admin’ login in the target Azure SQL Database
\n
\n
\n
· Data Migration Assistant
\n
· Azure Database Migration Service
\n
\n
\n\n
\n
\n
Using the Import/Export Service (BACPAC)
\n
A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from the database. A BACPAC file can be stored in Azure Blob storage or in local storage in an on-premises computer and later imported back into Azure SQL Database.
\n
Note
\n
Only use this option if you have renamed the ‘admin’ user at the source Amazon RDS for SQL Server instance.
\n
\n
Using the Import/Export Service (BACPAC)
\n
\n
The BACPAC file can be generated using SQL Server Management Studio or the SQLPackage.exe command-line utility. The following step-by-step instructions guide you through the Import/Export process using SQL Server Management Studio.
\n
\n
Export the source database into a BACPAC file
\n\n
Open SQL Server Management Studio and connect to the Amazon RDS for SQL Server instance as if connecting to a regular SQL Server Database Engine (in the server name, specify the endpoint of the Amazons RDS for SQL Server instance).
\n
In the Object Explorer pane, expand the Databases node, right-click the desired database, point to Tasks, and then select Export Data-tier Application:
Starting the Export Data-tier Application wizard
The Export Data-tier Application dialog box appears.
Export Data-tier Application wizard
\n
Select Next, and then, on the Export Settings page, specify a location to store the BACPAC file.
It can be a local path (Save to local disk), or a container in an Azure Storage account (Save to Microsoft Azure). Note that the Save to Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation completes.
Export Settings
\n
Select Next.
\n
On the Summary page, confirm that the settings are correct, and then select Finish.
Export Summary
When the process finishes, the Results page appears.
Export Results
\n
Confirm that all the steps completed successfully, and then select Close.
\n\n
\n
Import the BACPAC file into the target database
\n\n
In SQL Server Management Studio, connect to the target Azure SQL Database specifying the corresponding server name.
\n
In the Object Explorer pane, right-click on the Databases node, and then select Import Data-tier Application.
Starting the Import Data-tier Application wizard
The Import Data-tier Application dialog box appears.
Import Data-tier Application wizard
\n
Select Next, and then, on the Import Settings page, specify the location of the BACPAC file.
The source BACPAC file can be in local disk (Import from local disk), or in a container in an Azure Storage account (Import from Microsoft Azure). Note that the Import from Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation is complete. Import Settings
\n
Select Next, and then on the Database Settings page, specify the basic configuration settings for the new database: - New database name. - Edition: Basic, Standard or Premium for DTU-based purchasing model; General Purpose or Business Critical for vCore-based purchasing model. - Maximum database size (GB). - Service Objective: DTUs or Compute Hardware for the selected edition; for example, S1 for DTU Standard or GP_Gen5_8 for vCore General Purpose.
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
Database Settings
\n
Select Next, and then on Summary page, confirm that the settings are correct.
Import Summary
\n
Select Finish.
When the process is complete, the Results page appears.
Import Results
\n
Select Close, and then refresh and expand the Databases node.
The new database should appear there.
\n\n
\n
Using the Data Migration Assistant (DMA)
\n
The Data Migration Assistant (DMA) provides two core capabilities:
\n
\n
Analyses the source system and detects potential compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
\n
Migrates schema and data between source and target databases.
\n
\n
\n
Using the Data Migration Assistant (DMA)
\n
\n
Perform an Assessment
\n
The following step-by-step instructions guide through the process of performing an assessment for migrating from Amazon RDS for SQL Server to Azure SQL Database.
\n\n
Download Data Migration Assistant for free from the Microsoft Download Center., and then install it.
\n
Start DMA, select the New (+) icon, and then select the Assessment project type.
\n
Under Project name, specify a name for the assessment.
\n
Under Assessment type, select Database Engine.
\n
Under Source server type, select AWS RDS for SQL Server.
\n
Under Target server type, select Azure SQL Database, and then select Create.
\n
On the Options page, select Check database compatibility, and then select Next.
Assessment options
\n
In the Connect to a server pane, enter the server name and authentication credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to server
\n
On the Add sources pane, select the databases to assess, and then select Add.
Add sources
The Select sources page shows the list of selected databases.
Start Assessment
\n
Select Start Assessment.
When the process completes, the Review results page appears, showing the results of the assessment.
\n
Verify that the assessment completed successfully (green ticks).
If the assessment returns any errors due to compatibility issues, you will need to address them before attempting to migrate the database.
Assessment results
\n\n
\n
Create the target database
\n
Unlike the BACPAC import, which creates a new database, DMA migrates schema and data to an existing database. Therefore, you must create a new database before running the migration. There are a variety of tools that can be used to create a new database, including the Azure Portal and PowerShell. A quick guide is available here:
\n
\n
Quickstart: Create a single database - Azure SQL Database
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
\n
\n
Create the replacement admin login
\n\n
Open SQL Server Management Studio, connect to the server hosting the new Azure SQL Database created in the previous step, and run the following statement against the master database to create a new login instead of ‘admin’ (the sample code below uses ‘newadmin’):
\n
CREATE LOGIN [newadmin] WITH PASSWORD=N'S0meP@ssword!' GO
\n
\n\n
\n
Migrate Schema
\n
Once the target Azure SQL Database has been created and it has a new replacement admin login, open Data Migration Assistant to proceed with the migration of the schema from the source Amazon RDS for SQL Server to the target Azure SQL Database.
\n
\n\n
Select the New (+) icon, and then select the Migration project type.
\n
Under Project name, specify a name for the migration.
\n
Under Source server type, select SQL Server.
\n
Under Target server type, select Azure SQL Database.
\n
Under Migration scope, select Schema only., and then select Create.
New Migration project (Schema)
\n
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and the select Connect.
Connect to source server
The right pane shows a list of databases available on the source server.
\n
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Next.
Select source database
\n
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane shows a list of databases available on the target server
\n
Select the destination database, and then select Next.
Select target database
\n
On the Select objects page, scroll down to the bottom of the list, deselect Users / admin, and then select Generate SQL script.
Select objects
The Script & deploy schema page appears, showing the DMA Schema Migration Deployment Script.
Generated script
\n
Select the Generated script text box, and the add the following lines to the top of the script:
\n
/****** Manually add admin database user and link it to new admin login ******/ IF NOT EXISTS (SELECT * FROM sys.sysusers WHERE name = N'admin') CREATE USER [admin] FOR LOGIN [newadmin] WITH DEFAULT_SCHEMA=[dbo] GO
\n The window should now look like this:
Add the code to create the 'admin' database user
\n
Select Deploy schema.
\n
When the process finishes, verify that all the statements were completed successfully:
Deploy schema results
\n\n
\n
Migrate Data
\n
After the target Azure SQL Database has been created and the schema has been deployed, you can use Data Migration Assistant to proceed with the migration of the data from the source Amazon RDS for SQL Server to the target Azure SQL Database.
\n
\n\n
Select the New (+) icon, and then select the Migration project type.
\n
Under Project name, specify a name for the migration.
\n
Under Source server type, select SQL Server.
\n
Under Target server type, select Azure SQL Database.
\n
Under Migration scope, select Data only, and then select Create.
New Migration project (Data)
\n
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to source server
The right pane will show a list of databases available on the source server.
\n
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Connect.
Select source database
\n
Select Next.
\n
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane will show a list of databases available on the target server.
\n
Select the destination database, and then select Next.
Select destination database
The Select tables page will show the list of tables with row counts.
\n
Select tables as appropriate, and then select Start data migration:
Select tables
The Migrate data page shows progress.
\n
When the process is finished, verify that all tables were migrated successfully.
Migration results
The migration is now complete.
\n\n
Conclusion
\n
We have covered two mechanisms to migrate Amazon RDS for SQL Server databases to Azure SQL Database: using the Import/Export Service (BACPAC) and using the Data Migration Assistant (DMA). These tools are easy to use and work well for small-to-medium deployments. In part 2 we will cover the use of the Azure SQL migration extension for Azure Data Studio in combination with the Azure Database Migration Service, which provides more control over the migration and is better suited for migration at scale.
\n
\n
","body@stringLength":"52518","rawBody":"
Introduction
\n
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that automates backups and other operational tasks and is always running on the latest stable version of SQL Server. For many general-purpose workloads, Azure SQL Database can be a very cost-effective alternative to running the full SQL Server product, so it is a common scenario to move databases from SQL Server to Azure SQL Database.
\n
\n
Why move from Amazon RDS for SQL Server to Azure SQL Database?
\n
Amazon RDS for SQL Server is a popular choice for SQL Server workloads in the cloud. It provides a fully managed relational database service that offers SQL Server 2014, 2016, 2017, and 2019 while offloading database administration tasks like managing backups. However, Azure SQL Database can provide additional benefits not available in Amazon RDS for SQL Server:
\n
\n
Licensing Cost. When you set up an Amazon RDS DB instance for Microsoft SQL Server, the software license is included; it cannot be purchased separately. In Azure you can take advantage of Azure Hybrid Benefit, which allows you to use existing SQL Server licenses with Software Assurance to pay a reduced rate on Azure SQL Database, usually saving over 35%-50% in licensing costs.
\n
Free built-in High Availability and Zone Redundancy. Amazon RDS for SQL Server provides high availability by offering Multi-AZ DB instances, which are implemented using either SQL Server Database Mirroring or SQL Server AlwaysOn Availability Groups to provide zone redundancy. AWS Multi-AZ deployments cost extra, as much as twice the cost of Single-AZ deployments. Azure SQL Database high availability is achieved by using multiple compute nodes which are provided even in the lower price Basic, Standard and General Purpose service tiers. With Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region to provide zone-redundant availability at no extra cost.
\n
Always up to date SQL. When you set up an Amazon RDS DB instance for Microsoft SQL Server, you must specify the version of SQL Server to use. When Amazon RDS supports a new version of a database engine, you can upgrade your DB instances to the new version; however, this is a manual process that requires some downtime, not much different as if it were a regular SQL Server VM. In Azure, SQL is always up to date with the latest updates and patches being automatically applied, eliminating end-of-support hassles.
\n
Elastic Pools. Azure SQL Database elastic pools are a cost-effective solution for managing a group of databases that have varying and unpredictable usage patterns. This is a common problem for software-as-a-service (SaaS) developers, who usually create one database per customer but can end up with overprovisioned resources because of the unpredictability of customer usage patterns. Elastic pools solve this problem by ensuring that databases get the performance resources they need when they need it. They provide a simple resource allocation mechanism within a predictable budget. Amazon RDS for SQL Server lacks an elastic option for these scenarios.
\n
Serverless.Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Serverless is a cost-effective choice for databases with intermittent, unpredictable usage patterns that can afford some delay in compute warm-up after idle usage periods. Amazon RDS for SQL Server does not offer a serverless option.
\n
Large databases. Amazon RDS for SQL Server maximum database size is 16TB. The Hyperscale service tier in Azure SQL Database supports up to 100TB.
Moving databases from these systems into Azure SQL Database can be achieved using various mechanisms; the main options are:
\n
\n
\n\n
\n
\n
Migration option
\n
\n
\n
Comments
\n
\n
\n
\n
\n
Import/Export Service (BACPAC)
\n
\n
\n
It is the easiest to use and is integrated with SQL Server Management Studio. However, it requires additional storage and downtime because data is exported at the source, possibly copied to another location and then imported at the destination. It can also take a long time to process databases with many objects.
\n
\n
\n
\n
\n
Data Migration Assistant
\n
\n
\n
Migrates schema and data.
\n
Good for medium-sized deployments (i.e., small number of databases).
\n
\n
\n
\n
\n
Azure Database Migration Service
\n
\n
\n
Ideal for migrations at scale (i.e., large databases or many databases).
\n
\n
\n\n
\n
\n
This article focuses on the Amazon RDS for SQL Server scenario; describes a common problem that you might face when migrating to Azure SQL Database, provides some options to work around it, and a practical guide using three possible migration methods. The topic is divided in two parts: Part 1 covers the use of the Import/Export Service (BACPAC) and the Data Migration Assistant. Part 2 will cover the migration using the Azure Database Migration Service.
\n
\n
The problem with admin
\n
When you create a database in Amazon RDS for SQL Server, the AWS console suggests admin as the name for the system administrator account.
\n
\n
Specifying the Master username when creating a new RDS SQL database
\n
\n
This value can be changed, but many people just accept the default when configuring a new database. This would not present a problem if the database were to be later migrated to SQL Server or to Azure SQL Managed Instance, but it turns out that ‘admin’ is not a valid login name in Azure SQL Database. For example, consider the following T-SQL statement:
\n
\n
CREATE LOGIN [admin] WITH PASSWORD=N'S0meP@ssword!'
\n
\n
This statement would work against SQL Server or Azure SQL Managed Instance, resulting in the creation of a server login called ‘admin’. If the same statement is run against Azure SQL Database, it will result in the following error
\n
\n
Msg 40616, Level 16, State 1, Line 5 'admin' is not a valid login name in this version of SQL Server.
\n
\n
During migration from Amazon RDS for SQL Server to Azure SQL Database, the problem with the ‘admin’ login is that even though the SQL Server logins are defined at the server level and not at the database level, the migration tools will include server logins along with the database. Therefore, they will fail when attempting to create the login in the target server. For example, when using the Import/Export (BACPAC) feature, SQL Server Management Studio will throw the following error during import:
\n
\n
BACPAC Import error caused by presence of 'admin' login
\n
\n
The specific error is highlighted below:
\n
\n
Error SQL72014: .Net SqlClient Data Provider: Msg 40616, Level 16, State 1, Line 1 'admin' is not a valid login name in this version of SQL Server.
\n
\n
Data Migration Assistant would also throw a similar error:
\n
\n
Data Migration Assistant deploy schema error caused by presence of 'admin' login
\n
\n
Solution alternatives
\n
There are a couple of options to work around this problem:
\n
\n
Rename the ‘admin’ login in the source RDS server prior to the migration.
\n
Skip the ‘admin’ login when generating the scripts to be deployed to the destination Azure SQL Database and create an alternate login in the target database (with a name different to ‘admin’).
\n
\n
\n
Rename the ‘admin’ login in the source Amazon RDS for SQL Server
\n
This option sounds obvious, but it is not necessarily a feasible option in all cases. Renaming the login to something other than ‘admin’ prior to exporting from Amazon RDS for SQL Server will ensure that the BACPAC will work when importing it into the target Azure SQL Database.
\n
\n
To implement this option, connect to the source Amazon RDS for SQL Server instance using a query tool such as SQL Server Management Studio, select the master database, and run an ALTER LOGIN T-SQL statement. For example:
\n
\n
ALTER LOGIN [admin] WITH NAME = [rdsadmin];
\n
\n
After renaming the login, SQL Server will re-map the corresponding ‘admin’ database user to the new server login (i.e., the server login will have a new name, but the database user based on that login will continue to be called ‘admin’). Note that if you were connected using the ‘admin’ account in SQL Server Management Studio, the connection to the server will be broken after executing the statement because the ‘admin’ login is no longer valid. You will have to re-connect using the new login name to continue working in SQL Server Management Studio.
\n
\n
After the ‘admin’ login has been renamed at the source, you can use any of the three methods mentioned earlier (Import/Export BACPAC, Data Migration Assistant, Azure Database Migration Service) to migrate the database.
\n
\n
Note
\n
If an application relies on connecting to the database using the ‘admin’ login specifically, it will have to be modified or reconfigured so it can use a different login. If this is not possible (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
\n
\n
In some cases, it might not be possible to rename the ‘admin’ account at the source:
\n
\n
If some application still requires access to the source server using the ‘admin’ login.
\n
If you are not allowed to make any changes to the source system prior or during the migration.
\n
\n
If these restrictions apply to your scenario, you should use the approach described in the next section.
\n
\n
Create an alternate ‘admin’ login in the target Azure SQL Database
\n
If renaming the ‘admin’ login in the source Amazon RDS for SQL Server instance is not possible, an alternative approach could be to avoid creating the ‘admin’ login when migrating the schema; instead, create a login with a different name in the target Azure SQL Database server and then create a database user named ‘admin’ based on that login.
\n
Note
\n
Having a database user named ‘admin’ will ease migration of applications and existing T-SQL code that relies on that specific database username. However, it will still be required for the application to connect using a login different to ‘admin’. If it is not possible to modify or reconfigure the application so it can use a different login. (e.g., the application is “hard-coded” to use the ‘admin’ login), then Azure SQL Database is not a suitable target; in this case, consider migrating to SQL Server on Azure Virtual Machines, or to Azure SQL Managed Instance.
\n
\n
This approach can be implemented with a combination of SQL Server Enterprise Manager and the Data Migration Assistant (DMA) tool:
\n
\n
Use SQL Server Enterprise Manager to manually create a new login in the target Azure SQL Database server.
\n
After the login has been created, use the Data Migration Assistant (DMA) and specify to skip the creation of login/user when migrating the schema.
\n
\n
\n
After you determine which approach you can use, you should choose the migration tool for your scenario. The following table provides a guide on how to choose.
\n
\n
\n\n
\n
\n
Solution approach
\n
\n
\n
Migration tool options
\n
\n
\n
\n
\n
Rename the ‘admin’ login at the source Amazon RDS for SQL Server
\n
\n
\n
· Import/Export Service (BACPAC)
\n
· Data Migration Assistant
\n
· Azure Database Migration Service
\n
\n
\n
\n
\n
Create an alternate ‘admin’ login in the target Azure SQL Database
\n
\n
\n
· Data Migration Assistant
\n
· Azure Database Migration Service
\n
\n
\n\n
\n
\n
Using the Import/Export Service (BACPAC)
\n
A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from the database. A BACPAC file can be stored in Azure Blob storage or in local storage in an on-premises computer and later imported back into Azure SQL Database.
\n
Note
\n
Only use this option if you have renamed the ‘admin’ user at the source Amazon RDS for SQL Server instance.
\n
\n
Using the Import/Export Service (BACPAC)
\n
\n
The BACPAC file can be generated using SQL Server Management Studio or the SQLPackage.exe command-line utility. The following step-by-step instructions guide you through the Import/Export process using SQL Server Management Studio.
\n
\n
Export the source database into a BACPAC file
\n\n
Open SQL Server Management Studio and connect to the Amazon RDS for SQL Server instance as if connecting to a regular SQL Server Database Engine (in the server name, specify the endpoint of the Amazons RDS for SQL Server instance).
\n
In the Object Explorer pane, expand the Databases node, right-click the desired database, point to Tasks, and then select Export Data-tier Application:
Starting the Export Data-tier Application wizard
The Export Data-tier Application dialog box appears.
Export Data-tier Application wizard
\n
Select Next, and then, on the Export Settings page, specify a location to store the BACPAC file.
It can be a local path (Save to local disk), or a container in an Azure Storage account (Save to Microsoft Azure). Note that the Save to Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation completes.
Export Settings
\n
Select Next.
\n
On the Summary page, confirm that the settings are correct, and then select Finish.
Export Summary
When the process finishes, the Results page appears.
Export Results
\n
Confirm that all the steps completed successfully, and then select Close.
\n\n
\n
Import the BACPAC file into the target database
\n\n
In SQL Server Management Studio, connect to the target Azure SQL Database specifying the corresponding server name.
\n
In the Object Explorer pane, right-click on the Databases node, and then select Import Data-tier Application.
Starting the Import Data-tier Application wizard
The Import Data-tier Application dialog box appears.
Import Data-tier Application wizard
\n
Select Next, and then, on the Import Settings page, specify the location of the BACPAC file.
The source BACPAC file can be in local disk (Import from local disk), or in a container in an Azure Storage account (Import from Microsoft Azure). Note that the Import from Microsoft Azure option also requires that you specify a local directory for the temporary file. The temporary file will be created at the specified location and will remain there after the operation is complete. Import Settings
\n
Select Next, and then on the Database Settings page, specify the basic configuration settings for the new database: - New database name. - Edition: Basic, Standard or Premium for DTU-based purchasing model; General Purpose or Business Critical for vCore-based purchasing model. - Maximum database size (GB). - Service Objective: DTUs or Compute Hardware for the selected edition; for example, S1 for DTU Standard or GP_Gen5_8 for vCore General Purpose.
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
Database Settings
\n
Select Next, and then on Summary page, confirm that the settings are correct.
Import Summary
\n
Select Finish.
When the process is complete, the Results page appears.
Import Results
\n
Select Close, and then refresh and expand the Databases node.
The new database should appear there.
\n\n
\n
Using the Data Migration Assistant (DMA)
\n
The Data Migration Assistant (DMA) provides two core capabilities:
\n
\n
Analyses the source system and detects potential compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.
\n
Migrates schema and data between source and target databases.
\n
\n
\n
Using the Data Migration Assistant (DMA)
\n
\n
Perform an Assessment
\n
The following step-by-step instructions guide through the process of performing an assessment for migrating from Amazon RDS for SQL Server to Azure SQL Database.
\n\n
Download Data Migration Assistant for free from the Microsoft Download Center., and then install it.
\n
Start DMA, select the New (+) icon, and then select the Assessment project type.
\n
Under Project name, specify a name for the assessment.
\n
Under Assessment type, select Database Engine.
\n
Under Source server type, select AWS RDS for SQL Server.
\n
Under Target server type, select Azure SQL Database, and then select Create.
\n
On the Options page, select Check database compatibility, and then select Next.
Assessment options
\n
In the Connect to a server pane, enter the server name and authentication credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to server
\n
On the Add sources pane, select the databases to assess, and then select Add.
Add sources
The Select sources page shows the list of selected databases.
Start Assessment
\n
Select Start Assessment.
When the process completes, the Review results page appears, showing the results of the assessment.
\n
Verify that the assessment completed successfully (green ticks).
If the assessment returns any errors due to compatibility issues, you will need to address them before attempting to migrate the database.
Assessment results
\n\n
\n
Create the target database
\n
Unlike the BACPAC import, which creates a new database, DMA migrates schema and data to an existing database. Therefore, you must create a new database before running the migration. There are a variety of tools that can be used to create a new database, including the Azure Portal and PowerShell. A quick guide is available here:
\n
\n
Quickstart: Create a single database - Azure SQL Database
Note Take special consideration to the settings for the new database, because it can have significant implications in the time it would take to import the data. A database with a higher Service Objective (for example, S3 for DTU-based purchasing model) will import faster than one with a lower Service Objective (for example, S1 for DTU-based purchasing model). Consult the article Compare vCore and DTU-based purchasing models of Azure SQL Database to understand what’s available in each service tier. Consider using the maximum Service Objective (for example, P15 for DTU-based purchasing model) during the migration process to maximize import speed. You can then scale down after the import is successful.
\n
\n
Create the replacement admin login
\n\n
Open SQL Server Management Studio, connect to the server hosting the new Azure SQL Database created in the previous step, and run the following statement against the master database to create a new login instead of ‘admin’ (the sample code below uses ‘newadmin’):
\n
CREATE LOGIN [newadmin] WITH PASSWORD=N'S0meP@ssword!' GO
\n
\n\n
\n
Migrate Schema
\n
Once the target Azure SQL Database has been created and it has a new replacement admin login, open Data Migration Assistant to proceed with the migration of the schema from the source Amazon RDS for SQL Server to the target Azure SQL Database.
\n
\n\n
Select the New (+) icon, and then select the Migration project type.
\n
Under Project name, specify a name for the migration.
\n
Under Source server type, select SQL Server.
\n
Under Target server type, select Azure SQL Database.
\n
Under Migration scope, select Schema only., and then select Create.
New Migration project (Schema)
\n
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and the select Connect.
Connect to source server
The right pane shows a list of databases available on the source server.
\n
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Next.
Select source database
\n
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane shows a list of databases available on the target server
\n
Select the destination database, and then select Next.
Select target database
\n
On the Select objects page, scroll down to the bottom of the list, deselect Users / admin, and then select Generate SQL script.
Select objects
The Script & deploy schema page appears, showing the DMA Schema Migration Deployment Script.
Generated script
\n
Select the Generated script text box, and the add the following lines to the top of the script:
\n
/****** Manually add admin database user and link it to new admin login ******/ IF NOT EXISTS (SELECT * FROM sys.sysusers WHERE name = N'admin') CREATE USER [admin] FOR LOGIN [newadmin] WITH DEFAULT_SCHEMA=[dbo] GO
\n The window should now look like this:
Add the code to create the 'admin' database user
\n
Select Deploy schema.
\n
When the process finishes, verify that all the statements were completed successfully:
Deploy schema results
\n\n
\n
Migrate Data
\n
After the target Azure SQL Database has been created and the schema has been deployed, you can use Data Migration Assistant to proceed with the migration of the data from the source Amazon RDS for SQL Server to the target Azure SQL Database.
\n
\n\n
Select the New (+) icon, and then select the Migration project type.
\n
Under Project name, specify a name for the migration.
\n
Under Source server type, select SQL Server.
\n
Under Target server type, select Azure SQL Database.
\n
Under Migration scope, select Data only, and then select Create.
New Migration project (Data)
\n
On the Select source page, specify the server name and credentials to connect to the source Amazon RDS for SQL Server instance, and then select Connect.
Connect to source server
The right pane will show a list of databases available on the source server.
\n
Select the database that you want to migrate (you can leave the Assess database before migration? option blank, if you completed the assessment previously), and then select Connect.
Select source database
\n
Select Next.
\n
On the Select target page, specify the server name and credentials to connect to the target Azure SQL Database, and then select Connect.
Connect to target server
The right pane will show a list of databases available on the target server.
\n
Select the destination database, and then select Next.
Select destination database
The Select tables page will show the list of tables with row counts.
\n
Select tables as appropriate, and then select Start data migration:
Select tables
The Migrate data page shows progress.
\n
When the process is finished, verify that all tables were migrated successfully.
Migration results
The migration is now complete.
\n\n
Conclusion
\n
We have covered two mechanisms to migrate Amazon RDS for SQL Server databases to Azure SQL Database: using the Import/Export Service (BACPAC) and using the Data Migration Assistant (DMA). These tools are easy to use and work well for small-to-medium deployments. In part 2 we will cover the use of the Azure SQL migration extension for Azure Data Studio in combination with the Azure Database Migration Service, which provides more control over the migration and is better suited for migration at scale.
\n
\n
","kudosSumWeight":1,"repliesCount":0,"postTime":"2022-12-08T07:33:02.872-08:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wx","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3M2lCODg5NzkxQzBENjI2Mzk0?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wy","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NGk2OTY0MUM2QzIyNzM5N0FG?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wz","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NWkwODg3NUFDNDE0QjkwNTY1?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w0","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3N2lFRDhFMzg3NzM2QkYzNkU4?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w1","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4MmlDNTE3NDFFNjQ2MTc4RjFD?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w2","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4MmkxQjNCMkYyN0Y5NDhDNzA2?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w3","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4M2k5NjYxQ0IzNzg5ODcwRjE2?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w4","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NGk2MjJDODZFOTYxRjJCRUNG?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3w5","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NWk4QTE4NzQ1NzMyOEIwMUU3?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxMA","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4N2lCRDkzODdDNDI4REIyNURB?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxMQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5N2kwQzI1MDMzRjM3MjhCQTJB?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxMg","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5OWk3NzYwRTYyRkM3NTQ2N0Y5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxMw","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMGk1NUI5RjYxMDY3OEVCNTY0?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxNA","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMWk3OTczMTlGNzE2REZBMzU2?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxNQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMmlFNkY3Q0RGMjFBRUJFRkMw?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxNg","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwM2lDRTZFRjI5NkIwNzI3MkQz?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxNw","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3MWk0RTVCOUIwNUUzN0NBQzc5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxOA","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3NWkzMjQyOEE2QzgyMjFGOUY5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wxOQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3Nmk2Mjg4MkE4RjgxRENBQzMz?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyMA","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3N2lGMzEwOTUyRUYzRkI4MUQ5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyMQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OGkyOEI5QkI0Q0EzMjU1Rjg5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyMg","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OWk1Q0E0MjNERDg3Nzk2NTUw?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyMw","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE5NWlFMTY5RjI4OTgwNTA4RTUy?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyNA","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4NGk1MkFGMUEwMEM3ODIwRUI5?revision=21\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyNQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4Nmk2MTBBMzUwMDMyNzk2NDQ3?revision=21\"}"}}],"totalCount":38,"pageInfo":{"__typename":"PageInfo","hasNextPage":true,"endCursor":"MjQuMTB8Mi4xfG98MjV8X05WX3wyNQ","hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjQuMTB8Mi4xfG98MTB8X05WX3wx","node":{"__typename":"Tag","id":"tag:azure sql","text":"azure sql","time":"2018-12-05T17:15:03.966-08:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjQuMTB8Mi4xfG98MTB8X05WX3wy","node":{"__typename":"Tag","id":"tag:azure sql database","text":"azure sql database","time":"2017-08-22T12:33:06.546-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}},{"__typename":"TagEdge","cursor":"MjQuMTB8Mi4xfG98MTB8X05WX3wz","node":{"__typename":"Tag","id":"tag:Migration to Azure","text":"Migration to Azure","time":"2019-09-27T15:38:36.377-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":15,"rawTeaser":"
Learn about the migration path from Amazon RDS for SQL Server to Azure SQL Database and overcoming common problems.
\n
","introduction":"","coverImage":null,"coverImageProperties":{"__typename":"CoverImageProperties","style":"STANDARD","titlePosition":"BOTTOM","altText":""},"currentRevision":{"__ref":"Revision:revision:3673151_21"},"latestVersion":{"__typename":"FriendlyVersion","major":"1","minor":"0"},"metrics":{"__typename":"MessageMetrics","views":27530},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"placeholder":false,"originalMessageForPlaceholder":null,"contributors":{"__typename":"UserConnection","edges":[]},"nonCoAuthorContributors":{"__typename":"UserConnection","edges":[]},"coAuthors":{"__typename":"UserConnection","edges":[]},"blogMessagePolicies":{"__typename":"BlogMessagePolicies","canDoAuthoringActionsOnBlog":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.blog.action_can_do_authoring_action.accessDenied","key":"error.lithium.policies.blog.action_can_do_authoring_action.accessDenied","args":[]}}},"archivalData":null,"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[],"revisions({\"constraints\":{\"isPublished\":{\"eq\":true}},\"first\":1})":{"__typename":"RevisionConnection","totalCount":21}},"Conversation:conversation:3673151":{"__typename":"Conversation","id":"conversation:3673151","solved":false,"topic":{"__ref":"BlogTopicMessage:message:3673151"},"lastPostingActivityTime":"2022-12-08T07:33:02.872-08:00","lastPostTime":"2022-12-08T07:33:02.872-08:00","unreadReplyCount":0,"isSubscribed":false},"ModerationData:moderation_data:3673151":{"__typename":"ModerationData","id":"moderation_data:3673151","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3M2lCODg5NzkxQzBENjI2Mzk0?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3M2lCODg5NzkxQzBENjI2Mzk0?revision=21","title":"00 Teaser image.png","associationType":"TEASER","width":825,"height":430,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NGk2OTY0MUM2QzIyNzM5N0FG?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NGk2OTY0MUM2QzIyNzM5N0FG?revision=21","title":"01 AWS Console.png","associationType":"BODY","width":2068,"height":1715,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NWkwODg3NUFDNDE0QjkwNTY1?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3NWkwODg3NUFDNDE0QjkwNTY1?revision=21","title":"02 BACPAC import error.png","associationType":"BODY","width":3260,"height":2331,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3N2lFRDhFMzg3NzM2QkYzNkU4?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA3N2lFRDhFMzg3NzM2QkYzNkU4?revision=21","title":"03 DMA migrate error.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4MmlDNTE3NDFFNjQ2MTc4RjFD?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4MmlDNTE3NDFFNjQ2MTc4RjFD?revision=21","title":"04 Intro to BACPAC fig2.png","associationType":"BODY","width":2304,"height":1056,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4MmkxQjNCMkYyN0Y5NDhDNzA2?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4MmkxQjNCMkYyN0Y5NDhDNzA2?revision=21","title":"05 BACPAC Export fig1.png","associationType":"BODY","width":1596,"height":1529,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4M2k5NjYxQ0IzNzg5ODcwRjE2?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4M2k5NjYxQ0IzNzg5ODcwRjE2?revision=21","title":"05 BACPAC Export fig2.png","associationType":"BODY","width":1874,"height":1800,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NGk2MjJDODZFOTYxRjJCRUNG?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NGk2MjJDODZFOTYxRjJCRUNG?revision=21","title":"05 BACPAC Export fig3.png","associationType":"BODY","width":2576,"height":2475,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NWk4QTE4NzQ1NzMyOEIwMUU3?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4NWk4QTE4NzQ1NzMyOEIwMUU3?revision=21","title":"05 BACPAC Export fig4.png","associationType":"BODY","width":2576,"height":2475,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4N2lCRDkzODdDNDI4REIyNURB?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA4N2lCRDkzODdDNDI4REIyNURB?revision=21","title":"05 BACPAC Export fig5.png","associationType":"BODY","width":1874,"height":1800,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5N2kwQzI1MDMzRjM3MjhCQTJB?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5N2kwQzI1MDMzRjM3MjhCQTJB?revision=21","title":"06 BACPAC Import fig1.png","associationType":"BODY","width":1667,"height":1294,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5OWk3NzYwRTYyRkM3NTQ2N0Y5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODA5OWk3NzYwRTYyRkM3NTQ2N0Y5?revision=21","title":"06 BACPAC Import fig2.png","associationType":"BODY","width":1874,"height":1800,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMGk1NUI5RjYxMDY3OEVCNTY0?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMGk1NUI5RjYxMDY3OEVCNTY0?revision=21","title":"06 BACPAC Import fig3.png","associationType":"BODY","width":2576,"height":2475,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMWk3OTczMTlGNzE2REZBMzU2?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMWk3OTczMTlGNzE2REZBMzU2?revision=21","title":"06 BACPAC Import fig4.png","associationType":"BODY","width":1874,"height":1800,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMmlFNkY3Q0RGMjFBRUJFRkMw?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwMmlFNkY3Q0RGMjFBRUJFRkMw?revision=21","title":"06 BACPAC Import fig5.png","associationType":"BODY","width":2576,"height":2475,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwM2lDRTZFRjI5NkIwNzI3MkQz?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODEwM2lDRTZFRjI5NkIwNzI3MkQz?revision=21","title":"06 BACPAC Import fig6.png","associationType":"BODY","width":1874,"height":1800,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3MWk0RTVCOUIwNUUzN0NBQzc5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3MWk0RTVCOUIwNUUzN0NBQzc5?revision=21","title":"07 Intro to DMA fig2.png","associationType":"BODY","width":2304,"height":1056,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3NWkzMjQyOEE2QzgyMjFGOUY5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3NWkzMjQyOEE2QzgyMjFGOUY5?revision=21","title":"08 DMA Assessment fig2.png","associationType":"BODY","width":2855,"height":1652,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3Nmk2Mjg4MkE4RjgxRENBQzMz?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3Nmk2Mjg4MkE4RjgxRENBQzMz?revision=21","title":"08 DMA Assessment fig3.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3N2lGMzEwOTUyRUYzRkI4MUQ5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3N2lGMzEwOTUyRUYzRkI4MUQ5?revision=21","title":"08 DMA Assessment fig4.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OGkyOEI5QkI0Q0EzMjU1Rjg5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OGkyOEI5QkI0Q0EzMjU1Rjg5?revision=21","title":"08 DMA Assessment fig5.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OWk1Q0E0MjNERDg3Nzk2NTUw?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE3OWk1Q0E0MjNERDg3Nzk2NTUw?revision=21","title":"08 DMA Assessment fig6.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE5NWlFMTY5RjI4OTgwNTA4RTUy?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE5NWlFMTY5RjI4OTgwNTA4RTUy?revision=21","title":"09 DMA Migrate Schema fig1.png","associationType":"BODY","width":2852,"height":1650,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4NGk1MkFGMUEwMEM3ODIwRUI5?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4NGk1MkFGMUEwMEM3ODIwRUI5?revision=21","title":"09 DMA Migrate Schema fig2.png","associationType":"BODY","width":3926,"height":2271,"altText":null},"AssociatedImage:{\"url\":\"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4Nmk2MTBBMzUwMDMyNzk2NDQ3?revision=21\"}":{"__typename":"AssociatedImage","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/bS0zNjczMTUxLTQxODE4Nmk2MTBBMzUwMDMyNzk2NDQ3?revision=21","title":"09 DMA Migrate Schema fig3.png","associationType":"BODY","width":3846,"height":2475,"altText":null},"Revision:revision:3673151_21":{"__typename":"Revision","id":"revision:3673151_21","lastEditTime":"2022-12-08T07:24:11.929-08:00"},"CachedAsset:theme:customTheme1-1736155799712":{"__typename":"CachedAsset","id":"theme:customTheme1-1736155799712","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"favicon-1730836283320.png","imageLastModified":"1730836286415","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"favicon-1730836271365.png","imageLastModified":"1730836274203","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1300px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"3px","borderRadius":"3px","borderRadiusLg":"5px","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.16)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.12)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#717171","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#0069D4","secondary":"#333333","bodyText":"#333333","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#BC341B","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#D3F5A4","#243A5E"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Segoe UI","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"10px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"10px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Segoe UI","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"Segoe UI","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"600","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"}],"assetNames":["SegoeUI-normal-400.woff2","SegoeUI-normal-300.woff2","SegoeUI-normal-600.woff2","SegoeUI-normal-700.woff2","SegoeUI-italic-400.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"MWF Fluent Icons","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"}],"assetNames":["MWFFluentIcons-normal-400.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1731977288000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1731977288000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:o365.prod:pages/blogs/BlogMessagePage:board:MicrosoftDataMigration-1736181794921":{"__typename":"CachedAsset","id":"quilt:o365.prod:pages/blogs/BlogMessagePage:board:MicrosoftDataMigration-1736181794921","value":{"id":"BlogMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"blog-article","layout":"ONE_COLUMN","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":"LOCKED","bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"OneColumnQuiltSection","columnMap":{"main":[{"id":"blogs.widget.blogArticleWidget","className":"lia-blog-container","props":null,"__typename":"QuiltComponent"}],"__typename":"OneSectionColumns"}},{"id":"section-1729184836777","layout":"MAIN_SIDE","bgColor":"transparent","showTitle":false,"showDescription":false,"textPosition":"CENTER","textColor":"var(--lia-bs-body-color)","sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[],"side":[{"id":"custom.widget.Social_Sharing","className":null,"props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Share","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-pages/blogs/BlogMessagePage-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-pages/blogs/BlogMessagePage-1731977288000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This blog post cannot be found","name":"Blog Message Page","section.blog-article.title":"Blog Post","section.section-1729184836777.title":"","section.section-1729184836777.description":"","section.CncIde.title":"Blog Post","section.tifEmD.description":"","section.tifEmD.title":""},"localOverride":false},"CachedAsset:quiltWrapper:o365.prod:Common:1736155737853":{"__typename":"CachedAsset","id":"quiltWrapper:o365.prod:Common:1736155737853","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"className":"QuiltComponent_lia-component-edit-mode__0nCcm","links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"gxcuf89792","params":{},"routeName":"CommunityPage"},{"children":[],"linkType":"EXTERNAL","id":"external-link","url":"/Directory","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft365","params":{"categoryId":"microsoft365"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-teams","params":{"categoryId":"MicrosoftTeams"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows","params":{"categoryId":"Windows"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-securityand-compliance","params":{"categoryId":"MicrosoftSecurityandCompliance"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"outlook","params":{"categoryId":"Outlook"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"planner","params":{"categoryId":"Planner"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows-server","params":{"categoryId":"Windows-Server"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"azure","params":{"categoryId":"Azure"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"exchange","params":{"categoryId":"Exchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-endpoint-manager","params":{"categoryId":"microsoft-endpoint-manager"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"s-q-l-server","params":{"categoryId":"SQL-Server"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-2","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities","url":"/","target":"BLANK"},{"children":[{"linkType":"INTERNAL","id":"education-sector","params":{"categoryId":"EducationSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"a-i","params":{"categoryId":"AI"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"i-t-ops-talk","params":{"categoryId":"ITOpsTalk"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"partner-community","params":{"categoryId":"PartnerCommunity"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-mechanics","params":{"categoryId":"MicrosoftMechanics"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"healthcare-and-life-sciences","params":{"categoryId":"HealthcareAndLifeSciences"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"public-sector","params":{"categoryId":"PublicSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"io-t","params":{"categoryId":"IoT"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"driving-adoption","params":{"categoryId":"DrivingAdoption"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"s-m-b","params":{"categoryId":"SMB"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"startupsat-microsoft","params":{"categoryId":"StartupsatMicrosoft"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-1","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities-1","url":"/","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external","url":"/Blogs","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external-1","url":"/Events","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft-learn-1","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-learn-blog","params":{"boardId":"MicrosoftLearnBlog","categoryId":"MicrosoftLearn"},"routeName":"BlogBoardPage"},{"linkType":"EXTERNAL","id":"external-10","url":"https://learningroomdirectory.microsoft.com/","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-3","url":"https://docs.microsoft.com/learn/dynamics365/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-4","url":"https://docs.microsoft.com/learn/m365/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-5","url":"https://docs.microsoft.com/learn/topics/sci/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-6","url":"https://docs.microsoft.com/learn/powerplatform/?wt.mc_id=techcom_header-webpage-powerplatform","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-7","url":"https://docs.microsoft.com/learn/github/?wt.mc_id=techcom_header-webpage-github","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-8","url":"https://docs.microsoft.com/learn/teams/?wt.mc_id=techcom_header-webpage-teams","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-9","url":"https://docs.microsoft.com/learn/dotnet/?wt.mc_id=techcom_header-webpage-dotnet","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-2","url":"https://docs.microsoft.com/learn/azure/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"}],"linkType":"INTERNAL","id":"microsoft-learn","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"community-info-center","params":{"categoryId":"Community-Info-Center"},"routeName":"CategoryPage"}]},"style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","controllerHighlightColor":"hsla(30, 100%, 50%)","linkFontWeight":"400","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkBoxShadowHover":"none","linkFontSize":"14px","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","hamburgerColor":"var(--lia-nav-controller-icon-color)","linkTextBorderBottom":"none","brandLogoHeight":"30px","linkBgHoverColor":"transparent","linkLetterSpacing":"normal","collapseMenuDividerOpacity":0.16,"dropdownPaddingBottom":"15px","paddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","collapseMenuDividerBg":"var(--lia-nav-link-color)","linkColor":"var(--lia-bs-body-color)","linkJustifyContent":"flex-start","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-body-color)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","linkPaddingX":"10px","linkPaddingY":"5px","paddingTop":"15px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkBgColor":"transparent","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":false,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"linkTextColor":"var(--lia-bs-gray-700)"},"__typename":"QuiltComponent"},{"id":"custom.widget.HeroBanner","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":false,"useBackground":false,"cMax_items":3,"title":"","lazyLoad":false,"widgetChooser":"custom.widget.HeroBanner"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.MicrosoftFooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1731977288000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist."},"localOverride":false},"QueryVariables:TopicReplyList:message:3673151:21":{"__typename":"QueryVariables","id":"TopicReplyList:message:3673151:21","value":{"id":"message:3673151","first":10,"sorts":{"postTime":{"direction":"DESC"}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":false,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":true,"useNodeAncestors":false,"useUserHoverCard":true,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:component:custom.widget.HeroBanner-en-1736155868672":{"__typename":"CachedAsset","id":"component:custom.widget.HeroBanner-en-1736155868672","value":{"component":{"id":"custom.widget.HeroBanner","template":{"id":"HeroBanner","markupLanguage":"REACT","style":null,"texts":{"searchPlaceholderText":"Search this community","followActionText":"Follow","unfollowActionText":"Following","searchOnHoverText":"Please enter your search term(s) and then press return key to complete a search."},"defaults":{"config":{"applicablePages":[],"dynamicByCoreNode":null,"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.HeroBanner","form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"dynamicByCoreNode":null,"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"__typename":"Component","localOverride":false},"globalCss":null,"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"}},"localOverride":false},"CachedAsset:component:custom.widget.Social_Sharing-en-1736155868672":{"__typename":"CachedAsset","id":"component:custom.widget.Social_Sharing-en-1736155868672","value":{"component":{"id":"custom.widget.Social_Sharing","template":{"id":"Social_Sharing","markupLanguage":"HANDLEBARS","style":".social-share {\n .sharing-options {\n position: relative;\n margin: 0;\n padding: 0;\n line-height: 10px;\n display: flex;\n justify-content: left;\n gap: 5px;\n list-style-type: none;\n li {\n text-align: left;\n a {\n min-width: 30px;\n min-height: 30px;\n display: block;\n padding: 1px;\n .social-share-linkedin {\n img {\n background-color: rgb(0, 119, 181);\n }\n }\n .social-share-facebook {\n img {\n background-color: rgb(59, 89, 152);\n }\n }\n .social-share-x {\n img {\n background-color: rgb(0, 0, 0);\n }\n }\n .social-share-rss {\n img {\n background-color: rgb(0, 0, 0);\n }\n }\n .social-share-reddit {\n img {\n background-color: rgb(255, 69, 0);\n }\n }\n .social-share-email {\n img {\n background-color: rgb(132, 132, 132);\n }\n }\n }\n a {\n img {\n height: 2rem;\n }\n }\n }\n }\n}\n","texts":null,"defaults":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"Adds buttons to share to various social media websites","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Social_Sharing","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"Adds buttons to share to various social media websites","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Social_Sharing_social-share_c7xxz_1 {\n .custom_widget_Social_Sharing_sharing-options_c7xxz_2 {\n position: relative;\n margin: 0;\n padding: 0;\n line-height: 0.625rem;\n display: flex;\n justify-content: left;\n gap: 0.3125rem;\n list-style-type: none;\n li {\n text-align: left;\n a {\n min-width: 1.875rem;\n min-height: 1.875rem;\n display: block;\n padding: 0.0625rem;\n .custom_widget_Social_Sharing_social-share-linkedin_c7xxz_18 {\n img {\n background-color: rgb(0, 119, 181);\n }\n }\n .custom_widget_Social_Sharing_social-share-facebook_c7xxz_23 {\n img {\n background-color: rgb(59, 89, 152);\n }\n }\n .custom_widget_Social_Sharing_social-share-x_c7xxz_28 {\n img {\n background-color: rgb(0, 0, 0);\n }\n }\n .custom_widget_Social_Sharing_social-share-rss_c7xxz_33 {\n img {\n background-color: rgb(0, 0, 0);\n }\n }\n .custom_widget_Social_Sharing_social-share-reddit_c7xxz_38 {\n img {\n background-color: rgb(255, 69, 0);\n }\n }\n .custom_widget_Social_Sharing_social-share-email_c7xxz_43 {\n img {\n background-color: rgb(132, 132, 132);\n }\n }\n }\n a {\n img {\n height: 2rem;\n }\n }\n }\n }\n}\n","tokens":{"social-share":"custom_widget_Social_Sharing_social-share_c7xxz_1","sharing-options":"custom_widget_Social_Sharing_sharing-options_c7xxz_2","social-share-linkedin":"custom_widget_Social_Sharing_social-share-linkedin_c7xxz_18","social-share-facebook":"custom_widget_Social_Sharing_social-share-facebook_c7xxz_23","social-share-x":"custom_widget_Social_Sharing_social-share-x_c7xxz_28","social-share-rss":"custom_widget_Social_Sharing_social-share-rss_c7xxz_33","social-share-reddit":"custom_widget_Social_Sharing_social-share-reddit_c7xxz_38","social-share-email":"custom_widget_Social_Sharing_social-share-email_c7xxz_43"}},"form":null},"localOverride":false},"CachedAsset:component:custom.widget.MicrosoftFooter-en-1736155868672":{"__typename":"CachedAsset","id":"component:custom.widget.MicrosoftFooter-en-1736155868672","value":{"component":{"id":"custom.widget.MicrosoftFooter","template":{"id":"MicrosoftFooter","markupLanguage":"HANDLEBARS","style":".context-uhf {\n min-width: 280px;\n font-size: 15px;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.c-uhff-link {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.c-uhff {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.c-uhff-nav {\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n .c-heading-4 {\n color: #616161;\n word-break: break-word;\n font-size: 15px;\n line-height: 20px;\n padding: 36px 0 4px;\n font-weight: 600;\n }\n .c-uhff-nav-row {\n .c-uhff-nav-group {\n display: block;\n float: left;\n min-height: 1px;\n vertical-align: text-top;\n padding: 0 12px;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.c-list.f-bare {\n font-size: 11px;\n line-height: 16px;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 8px 0;\n margin: 0;\n }\n }\n }\n }\n}\n.c-uhff-base {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 30px 5% 16px;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.c-uhff-ccpa {\n font-size: 11px;\n line-height: 16px;\n float: left;\n margin: 3px 0;\n }\n a.c-uhff-ccpa:hover {\n text-decoration: underline;\n }\n ul.c-list {\n font-size: 11px;\n line-height: 16px;\n float: right;\n margin: 3px 0;\n color: #616161;\n li {\n padding: 0 24px 4px 0;\n display: inline-block;\n }\n }\n .c-list.f-bare {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 30px 24px 16px;\n }\n}\n","texts":{"New tab":"What's New","New 1":"Surface Laptop Studio 2","New 2":"Surface Laptop Go 3","New 3":"Surface Pro 9","New 4":"Surface Laptop 5","New 5":"Surface Studio 2+","New 6":"Copilot in Windows","New 7":"Microsoft 365","New 8":"Windows 11 apps","Store tab":"Microsoft Store","Store 1":"Account Profile","Store 2":"Download Center","Store 3":"Microsoft Store Support","Store 4":"Returns","Store 5":"Order tracking","Store 6":"Certified Refurbished","Store 7":"Microsoft Store Promise","Store 8":"Flexible Payments","Education tab":"Education","Edu 1":"Microsoft in education","Edu 2":"Devices for education","Edu 3":"Microsoft Teams for Education","Edu 4":"Microsoft 365 Education","Edu 5":"How to buy for your school","Edu 6":"Educator Training and development","Edu 7":"Deals for students and parents","Edu 8":"Azure for students","Business tab":"Business","Bus 1":"Microsoft Cloud","Bus 2":"Microsoft Security","Bus 3":"Dynamics 365","Bus 4":"Microsoft 365","Bus 5":"Microsoft Power Platform","Bus 6":"Microsoft Teams","Bus 7":"Microsoft Industry","Bus 8":"Small Business","Developer tab":"Developer & IT","Dev 1":"Azure","Dev 2":"Developer Center","Dev 3":"Documentation","Dev 4":"Microsoft Learn","Dev 5":"Microsoft Tech Community","Dev 6":"Azure Marketplace","Dev 7":"AppSource","Dev 8":"Visual Studio","Company tab":"Company","Com 1":"Careers","Com 2":"About Microsoft","Com 3":"Company News","Com 4":"Privacy at Microsoft","Com 5":"Investors","Com 6":"Diversity and inclusion","Com 7":"Accessiblity","Com 8":"Sustainibility"},"defaults":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.MicrosoftFooter","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"dynamicByCoreNode":false,"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_MicrosoftFooter_context-uhf_f95yq_1 {\n min-width: 17.5rem;\n font-size: 0.9375rem;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-link_f95yq_12 {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff_f95yq_12 {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.custom_widget_MicrosoftFooter_c-uhff-nav_f95yq_35 {\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n .custom_widget_MicrosoftFooter_c-heading-4_f95yq_49 {\n color: #616161;\n word-break: break-word;\n font-size: 0.9375rem;\n line-height: 1.25rem;\n padding: 2.25rem 0 0.25rem;\n font-weight: 600;\n }\n .custom_widget_MicrosoftFooter_c-uhff-nav-row_f95yq_57 {\n .custom_widget_MicrosoftFooter_c-uhff-nav-group_f95yq_58 {\n display: block;\n float: left;\n min-height: 0.0625rem;\n vertical-align: text-top;\n padding: 0 0.75rem;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.custom_widget_MicrosoftFooter_c-list_f95yq_78.custom_widget_MicrosoftFooter_f-bare_f95yq_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 0.5rem 0;\n margin: 0;\n }\n }\n }\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff-base_f95yq_94 {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 1.875rem 5% 1rem;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_f95yq_107 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: left;\n margin: 0.1875rem 0;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_f95yq_107:hover {\n text-decoration: underline;\n }\n ul.custom_widget_MicrosoftFooter_c-list_f95yq_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: right;\n margin: 0.1875rem 0;\n color: #616161;\n li {\n padding: 0 1.5rem 0.25rem 0;\n display: inline-block;\n }\n }\n .custom_widget_MicrosoftFooter_c-list_f95yq_78.custom_widget_MicrosoftFooter_f-bare_f95yq_78 {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 1.875rem 1.5rem 1rem;\n }\n}\n","tokens":{"context-uhf":"custom_widget_MicrosoftFooter_context-uhf_f95yq_1","c-uhff-link":"custom_widget_MicrosoftFooter_c-uhff-link_f95yq_12","c-uhff":"custom_widget_MicrosoftFooter_c-uhff_f95yq_12","c-uhff-nav":"custom_widget_MicrosoftFooter_c-uhff-nav_f95yq_35","c-heading-4":"custom_widget_MicrosoftFooter_c-heading-4_f95yq_49","c-uhff-nav-row":"custom_widget_MicrosoftFooter_c-uhff-nav-row_f95yq_57","c-uhff-nav-group":"custom_widget_MicrosoftFooter_c-uhff-nav-group_f95yq_58","c-list":"custom_widget_MicrosoftFooter_c-list_f95yq_78","f-bare":"custom_widget_MicrosoftFooter_f-bare_f95yq_78","c-uhff-base":"custom_widget_MicrosoftFooter_c-uhff-base_f95yq_94","c-uhff-ccpa":"custom_widget_MicrosoftFooter_c-uhff-ccpa_f95yq_107"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1731977288000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1731977288000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1731977288000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1731977288000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1731977288000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"Category:category:Exchange":{"__typename":"Category","id":"category:Exchange","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Planner":{"__typename":"Category","id":"category:Planner","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Outlook":{"__typename":"Category","id":"category:Outlook","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Community-Info-Center":{"__typename":"Category","id":"category:Community-Info-Center","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:EducationSector":{"__typename":"Category","id":"category:EducationSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:DrivingAdoption":{"__typename":"Category","id":"category:DrivingAdoption","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Azure":{"__typename":"Category","id":"category:Azure","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows-Server":{"__typename":"Category","id":"category:Windows-Server","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:SQL-Server":{"__typename":"Category","id":"category:SQL-Server","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftTeams":{"__typename":"Category","id":"category:MicrosoftTeams","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PublicSector":{"__typename":"Category","id":"category:PublicSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoft365":{"__typename":"Category","id":"category:microsoft365","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:IoT":{"__typename":"Category","id":"category:IoT","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:HealthcareAndLifeSciences":{"__typename":"Category","id":"category:HealthcareAndLifeSciences","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:SMB":{"__typename":"Category","id":"category:SMB","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:ITOpsTalk":{"__typename":"Category","id":"category:ITOpsTalk","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoft-endpoint-manager":{"__typename":"Category","id":"category:microsoft-endpoint-manager","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftSecurityandCompliance":{"__typename":"Category","id":"category:MicrosoftSecurityandCompliance","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftLearn":{"__typename":"Category","id":"category:MicrosoftLearn","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:MicrosoftLearnBlog":{"__typename":"Blog","id":"board:MicrosoftLearnBlog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AI":{"__typename":"Category","id":"category:AI","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftMechanics":{"__typename":"Category","id":"category:MicrosoftMechanics","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:StartupsatMicrosoft":{"__typename":"Category","id":"category:StartupsatMicrosoft","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PartnerCommunity":{"__typename":"Category","id":"category:PartnerCommunity","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows":{"__typename":"Category","id":"category:Windows","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"CachedAsset:text:en_US-components/community/Navbar-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1731977288000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","gxcuf89792":"Tech Community","external-1":"Events","s-m-b":"Small and Medium Businesses","windows-server":"Windows Server","education-sector":"Education Sector","driving-adoption":"Driving Adoption","microsoft-learn":"Microsoft Learn","s-q-l-server":"SQL Server","partner-community":"Microsoft Partner Community","microsoft365":"Microsoft 365","external-9":".NET","external-8":"Teams","external-7":"Github","products-services":"Products","external-6":"Power Platform","communities-1":"Topics","external-5":"Security, Compliance & Identity","planner":"Planner","external-4":"Microsoft 365","external-3":"Dynamics 365","azure":"Azure","healthcare-and-life-sciences":"Healthcare and Life Sciences","external-2":"Azure","microsoft-mechanics":"Microsoft Mechanics","microsoft-learn-1":"Community","external-10":"Learning Room Directory","microsoft-learn-blog":"Blog","windows":"Windows","i-t-ops-talk":"ITOps Talk","external-link-1":"View All","microsoft-securityand-compliance":"Security, Compliance, and Identity","public-sector":"Public Sector","community-info-center":"Lounge","external-link-2":"View All","microsoft-teams":"Microsoft Teams","external":"Blogs","microsoft-endpoint-manager":"Microsoft Intune and Configuration Manager","startupsat-microsoft":"Startups at Microsoft","exchange":"Exchange","a-i":"AI and Machine Learning","io-t":"Internet of Things (IoT)","outlook":"Outlook","external-link":"Community Hubs","communities":"Products"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1731977288000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1731977288000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1731977288000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1731977288000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1731977288000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCoverImage-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCoverImage-1731977288000","value":{"coverImageTitle":"Cover Image"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeTitle-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeTitle-1731977288000","value":{"nodeTitle":"{nodeTitle, select, community {Community} other {{nodeTitle}}} "},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTimeToRead-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTimeToRead-1731977288000","value":{"minReadText":"{min} MIN READ"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1731977288000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1731977288000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1731977288000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1731977288000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1731977288000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1731977288000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageRevision-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageRevision-1731977288000","value":{"lastUpdatedDatePublished":"{publishCount, plural, one{Published} other{Updated}} {date}","lastUpdatedDateDraft":"Created {date}","version":"Version {major}.{minor}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1731977288000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1731977288000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageAuthorBio-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageAuthorBio-1731977288000","value":{"sendMessage":"Send Message","actionMessage":"Follow this blog board to get notified when there's new activity","coAuthor":"CO-PUBLISHER","contributor":"CONTRIBUTOR","userProfile":"View Profile","iconlink":"Go to {name} {type}"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1731977288000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1731977288000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1731977288000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1731977288000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserRegistrationDate-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserRegistrationDate-1731977288000","value":{"noPrefix":"{date}","withPrefix":"Joined {date}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeAvatar-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeAvatar-1731977288000","value":{"altTitle":"Node avatar for {nodeTitle}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeDescription-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeDescription-1731977288000","value":{"description":"{description}"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1731977288000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1731977288000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1731977288000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false}}}},"page":"/blogs/BlogMessagePage/BlogMessagePage","query":{"boardId":"microsoftdatamigration","messageSubject":"migrate-databases-from-amazon-rds-for-sql-server-to-azure-sql-database-–-part-1","messageId":"3673151"},"buildId":"HRH9asyXK5xcdgT_PgIf7","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"o365","openTelemetryServiceVersion":"24.10.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","khorosSignInIdpId":"kh-auth-idp","apolloDevToolsEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/blogs/BlogArticleWidget/BlogArticleWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.tsx","./components/external/components/ExternalComponent.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[{"id":"analytics","src":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/pagescripts/1729284608000/analytics.js?page.id=BlogMessagePage&entity.id=board%3Amicrosoftdatamigration&entity.id=message%3A3673151","strategy":"afterInteractive"}]}