|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/migrating-oracle-databases-to-sql-server-oracletosql/
课程评论：没有评论
**课程名称：** 从 Oracle 迁移到 SQL Server (OracleToSQL) **课程概述：** 本课程将指导您如何使用 Microsoft SQL Server Migration Assistant (SSMA) for Oracle，将 Oracle 数据库迁移至 SQL Server、Azure SQL Database 或 Azure Synapse Analytics。 **为何选择 SQL Server？** Oracle 和 SQL Server 都是广泛使用的关系型数据库管理系统。然而，对于许多寻求技术成本优化的客户而言，SQL Server 是一个更具经济效益的选择。与 Oracle 相比，SQL Server 在许可和支持费用方面更为低廉，这使其成为性价比更高的替代方案。 **SSMA for Oracle 的功能：** SSMA for Oracle 提供了一个全面的环境，帮助您高效地完成数据库迁移。主要功能包括： * **评估迁移：** 审查数据库对象和数据，评估数据库的迁移可行性。 * **迁移数据库对象：** 将 Oracle 数据库对象迁移至 SQL Server、Azure SQL Database 或 Azure Synapse Analytics。 * **迁移数据：** 将 Oracle 数据库数据迁移至 SQL Server、Azure SQL Database 或 Azure Synapse Analytics。 **需要注意：** 您不能迁移 Oracle 的 `SYS` 和 `SYSTEM` 模式。 **本课程适合：** 希望降低技术成本、寻求更经济高效的数据库解决方案，并将现有 Oracle 数据库迁移至 Microsoft SQL Server 生态系统的用户。
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.Oracle and SQL Server are both very popular RDBMS systems that are widely used to run enterprise applications. SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, Azure SQL Database, or Azure Synapse Analytics, and then migrate data to SQL Server, Azure SQL Database, or Azure Synapse Analytics. Note that you cannot migrate SYS and SYSTEM Oracle schemas.These days lot of customers are looking to save on their technology costs. Adopting economical technologies and software that are equally capable and powerful to fulfil requirements is one of the ways to achieve cost optimization. Databases are one of the tiers which customers spend a lot of money as part of license and support fees. Support staff is an additional cost to maintain these databases. SQL Server is very economical if we compare it with Oracle and that is the main reason for clients to choose SQL Server over Oracle.
