|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-database-migration-engineer-sql-server-oracle/
课程评论：没有评论
**课程概述：** 本课程旨在教授学员如何使用 Oracle SQL Developer 工具，将第三方数据库（以 Microsoft SQL Server 为例）迁移到 Oracle 数据库。数据迁移是数据库从业人员必备的一项重要技能，能够熟练掌握相关的工具和流程将大大提升工作效率。 **课程内容梗概：** 本课程将详细讲解数据库迁移的整个流程，主要包括以下几个关键步骤： 1. **设置迁移仓库（Migration Repository）：** 学习如何创建一个专门的数据库模式，用于存储在迁移过程中收集和转换的元数据。 2. **配置第三方数据库连接：** 掌握如何下载并配置 JDBC 驱动，从而连接到需要迁移的第三方数据库（如 SQL Server）。 3. **捕获源数据库（Capturing Source Database）：** 了解如何获取第三方数据库的“时间点”快照，以便迁移向导能够基于此快照进行操作，避免对在线数据库造成影响。 4. **将捕获的模型转换为 Oracle 模型：** 学习如何将从源数据库捕获的模型转换为 Oracle 特定的模型。 5. **翻译第三方 SQL 对象到 Oracle：** 重点讲解如何将 T-SQL 对象（包括约束、函数、存储过程、触发器、视图等）翻译成 Oracle SQL 对象。 6. **生成创建目标数据库的脚本：** 在模型转换完成后，学习如何生成 SQL 脚本来创建新的 Oracle 数据库模式，并执行这些脚本。 7. **将数据从第三方数据库迁移到 Oracle：** 作为迁移流程的最后一步，掌握如何使用迁移向导将数据从第三方数据库复制到新的 Oracle 数据库表中。 通过本课程的学习，学员将能够独立完成从 SQL Server 到 Oracle 的数据库迁移任务，并对数据迁移的核心概念和技术有深入的理解。
Data Migration is an important function anyone working with a database should be able to carry out.There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracle SQL Developer to migrate a third party database from Microsoft SQL Server into Oracle.Database migration involves several steps specified below:Setting up a Migration Repository: The Migrations Repository is a database schema that stores the meta_data collected and transformed in the migration process. Configuring the Third Party Database Connection : You need to configure a database connection for the database which you would like to migrate. There are two steps to this process:Download JDBC driver and Connecting to Third Party Database.Capturing Source Database:This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer with a "point in time" view of your database. Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database.Convert Captured Model to Oracle: The next step in the migration process is to convert the captured model of the database to an Oracle-specific model. Translate Third Party SQL Objects to Oracle:The next step in the migration process is to translate the T-SQL objects - constraints, functions, procedures, triggers, views - to Oracle SQL objects. Generating Scripts to Create Target Database:Once the conversion process has completed, SQL Developer has a model of what the converted database will look like. This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts.Move Data from Third Party Database to Oracle:The last step in the Migration Wizard is to move the data to the new database. Migrating the data is a process that copies the data from the third-party database to the new tables in the Oracle database. The Migration Wizard uses the same Oracle database connection required to run the scripts as it does to move the data.
