|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-developer-sql-servert-sqldatabase-migration/
课程评论：没有评论
课程名称：数据库开发者 - SQL Server/T-SQL/数据库迁移 课程概述： 作为数据库开发者，您将学习如何使用T-SQL（Transact-SQL）与Microsoft SQL Server进行交互，并执行从一个关系数据库管理系统迁移到另一个的数据库迁移。本课程将利用Oracle提供的强大免费工具Oracle SQL Developer，将第三方数据库从Microsoft SQL Server迁移至Oracle。数据库迁移涉及多个步骤，这些步骤包括： 1. **设置迁移存储库**：创建一个数据库模式以存储迁移过程中收集和转换的元数据。 2. **配置第三方数据库连接**：需要为要迁移的数据库配置连接，包括下载JDBC驱动和连接到第三方数据库的步骤。 3. **捕获源数据库**：捕获第三方数据库当前状态的快照，为SQL Developer提供一个“时间点”视图，以便后续操作。 4. **将捕获的模型转换为Oracle模型**：将数据库的捕获模型转换为特定于Oracle的模型。 5. **将第三方SQL对象转换为Oracle SQL对象**：将约束、函数、过程、触发器和视图等T-SQL对象翻译为Oracle SQL对象。 6. **生成创建目标数据库的脚本**：在转换过程完成后，SQL Developer会生成SQL脚本，以创建新的Oracle数据库模式。 7. **将数据从第三方数据库迁移至Oracle**：迁移数据的最后步骤是将数据从第三方数据库复制到新的Oracle数据库中的表。 通过此课程，您将掌握使用Oracle SQL Developer进行数据库迁移的全过程，提升您的数据库开发技能。
One of the many roles of a database developer includes working with relational database servers,using T-SQL(Transact ) to interact with Microsoft SQL Server and also performing database migrations from one relational database management system to another. 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.
