|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-data-migration-database-migration-ms-sql-to-oracle-db/
课程评论：没有评论
课程名称：数据迁移：从 MS SQL 到 Oracle 数据库的迁移 课程概述：数据迁移是任何从事数据库工作的人都应具备的重要功能。为了执行数据库和数据迁移，有多种工具可供选择。在本课程中，我们将使用 Oracle 提供的免费强大工具 Oracle SQL Developer，将第三方数据库从 Microsoft SQL Server 迁移到 Oracle。数据库迁移包括几个步骤： 1. **设置迁移存储库**：迁移存储库是一个数据库架构，用于存储在迁移过程中收集和转化的元数据。 2. **配置第三方数据库连接**：您需要为要迁移的数据库配置连接，这个过程分为两个步骤：下载 JDBC 驱动程序和连接到第三方数据库。 3. **捕获源数据库**：此步骤用于捕获当前第三方数据库的快照，提供 SQL Developer 一个“时间点”的视图完成此步骤后，迁移向导将使用存储在其存储库中的元数据，而不是对实时数据库发出查询。 4. **转换捕获的模型到 Oracle**：迁移过程的下一步是将捕获的数据库模型转换为 Oracle 特定的模型。 5. **将第三方 SQL 对象翻译为 Oracle**：此步骤涉及将 T-SQL 对象（如约束、函数、过程、触发器、视图）翻译为 Oracle SQL 对象。 6. **生成创建目标数据库的脚本**：一旦转换过程完成，SQL Developer 将生成 SQL 脚本，用于创建新的 Oracle 数据库架构并执行这些脚本。 7. **将数据从第三方数据库迁移到 Oracle**：迁移向导的最后一步是将数据移动到新的数据库中。数据迁移是一个将数据从第三方数据库复制到 Oracle 数据库中新表的过程。迁移向导使用与执行脚本相同的 Oracle 数据库连接来移动数据。 此外，我们还将使用 Microsoft SQL Server Migration Assistant (SSMA) 工具，自动化将 Oracle、MySQL 和 Microsoft Access 的数据库迁移到 SQL Server。 本课程为学习数据库迁移提供了全面的指导，适合希望掌握数据迁移技能的学员。
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 metadata 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.We will also be using Microsoft SQL Server Migration Assistant (SSMA) tool to automate database migration to SQL Serverfrom Oracle, MySQL and Microsoft Access.
