|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-migration-mysql-microsoft-sql-server-oracle/
课程评论：没有评论
本课程主要讲解如何进行数据库迁移，重点关注从 **MySQL** 迁移到 **Microsoft SQL Server**，以及从 **Microsoft SQL Server** 迁移到 **Oracle**。 **主要内容包括：** * **数据库基础知识：** 介绍 SQL（结构化查询语言）、数据库的概念，以及像 MySQL 这样的数据库管理系统的作用。MySQL 作为一款流行的开源数据库，由 Oracle 公司开发、分发和支持。Microsoft SQL Server 是由微软开发的另一款关系型数据库管理系统，拥有多种版本以满足不同需求。 * **数据库迁移的定义与重要性：** 阐述数据库迁移是将数据从一个或多个源数据库迁移到一个或多个目标数据库的过程。这是数据库工作中一项非常重要的技能。 * **使用 SQL Server Migration Assistant (SSMA) 进行 MySQL 到 Microsoft SQL Server 的迁移：** 详细介绍如何利用 SSMA 工具实现 MySQL 数据库的模式（schema）和数据迁移到 Microsoft SQL Server。 * **使用 Oracle SQL Developer 进行 Microsoft SQL Server 到 Oracle 的迁移：** 演示如何利用 Oracle SQL Developer 这个免费强大的工具，将 Microsoft SQL Server 数据库迁移到 Oracle。 **迁移步骤详解：** * **建立迁移仓库（Migration Repository）：** 创建一个数据库模式来存储迁移过程中收集和转换的元数据。 * **配置第三方数据库连接：** 需要下载 JDBC 驱动并连接到源数据库（Microsoft SQL Server）。 * **捕获源数据库（Capturing Source Database）：** 创建源数据库的“时间点”快照，以便迁移向导能够基于此元数据进行操作。 * **将捕获的模型转换为 Oracle 模型：** 将源数据库的结构转换为 Oracle 兼容的模型。 * **翻译第三方 SQL 对象到 Oracle SQL 对象：** 转换包括约束、函数、存储过程、触发器和视图等 SQL 对象。 * **生成创建目标数据库的脚本：** 基于转换后的模型生成 SQL 脚本，用于创建新的 Oracle 数据库模式。 * **将数据从第三方数据库迁移到 Oracle：** 执行数据迁移，将源数据库的数据复制到新的 Oracle 数据库表中。 本课程旨在帮助学员掌握数据库迁移的整个流程和关键技术，熟练使用相关工具完成跨数据库平台的迁移任务。
MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.The SQL part of "MySQL" stands for "Structured Query Language". SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax.A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.MySQL is Open source which means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.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 (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.Database migration is the process of migrating data from one or more source databases to one or more target databases by using a database migration service. When a migration is finished, the datasets in the source databases resides fully, though possibly restructured, in the target databases.In this course you will learn how to migrate a database from MySQL into Microsoft SQL Server using SQL Server Migration Assistant for MySQL (SSMA). The migration will involve schema and data migration.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.
