|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/migrate-on-premises-sql-server-to-cloud-azure-sql-database/
课程评论：没有评论
课程名称：将本地SQL Server迁移至云Azure SQL数据库 课程概述：选择微软的Azure平台来托管您组织的数据库有助于降低成本并支持更高效的IT基础设施。在评估了将数据库切换至Azure的利弊并获得迁移批准后，迁移至云可以帮助减少组织的运营费用。数据迁移助手（DMA）通过检测可能影响SQL Server或Azure SQL数据库新版本功能的兼容性问题，帮助您升级到现代数据平台。DMA还推荐针对目标环境的性能和可靠性改进，并允许您将模式、数据及不包含的对象从源服务器迁移到目标服务器。对于大型迁移（无论是数据库数量还是大小），建议使用Azure数据库迁移服务，以大规模迁移数据库。您可以将本地或本地SQL Server实例迁移到托管在本地或可通过Azure虚拟机（VM）访问的现代SQL Server实例。Azure虚拟机可以通过VPN或其他技术进行访问。迁移工作流程帮助您迁移以下组件：数据库模式、数据和用户、服务器角色、SQL Server和Windows登录信息。成功迁移后，应用程序可以无缝连接到目标SQL Server数据库。 课程大纲：无
Choosing Microsoft's Azure platform to host your organisation's databases can help to reduce costs and support a higher-functioning IT infrastructure. Once you've assessed the pros and cons of switching your databases to Azure and the migration has been approved, migrating to the cloud could help you to reduce your organisation's overheads.The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.For large migrations (in terms of number and size of databases), we recommend that you use the Azure Database Migration Service, which can migrate databases at scale.You can migrate an on-premises or local SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure virtual machine (VM) that is accessible from your on-premises network. The Azure VM can be accessed using VPN or other technologies. The migration workflow helps you to migrate the following components:Schema of databasesData and usersServer rolesSQL Server and Windows loginsAfter a successful migration, applications can connect to the target SQL Server databases seamlessly.
