|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-migrate-mysql-database-to-microsoft-sql-server/
课程评论：没有评论
**课程概述：** 本课程旨在教授如何将流行的开源数据库 MySQL 成功迁移到 Microsoft SQL Server。课程将重点介绍使用 SQL Server Migration Assistant for MySQL (SSMA) 工具进行数据库迁移的过程，涵盖了模式（Schema）和数据迁移的关键步骤。 **核心内容：** * **MySQL 简介：** 了解 MySQL 作为开源 SQL 数据库的特性、其在数据管理中的作用以及 SQL 语言的基本概念。 * **Microsoft SQL Server 简介：** 认识 Microsoft SQL Server 作为一种关系数据库管理系统，以及其不同的版本和应用场景。 * **数据库迁移概念：** 理解数据库迁移的定义、目的以及它在不同软件应用和数据存储中的重要性。 * **迁移工具 SSMA for MySQL：** 学习使用 SSMA 工具来执行从 MySQL 到 Microsoft SQL Server 的迁移。 * **迁移过程详解：** 掌握迁移过程中涉及的模式转换和数据迁移的具体操作。 **课程目标：** 通过本课程的学习，学员将能够独立完成将 MySQL 数据库迁移到 Microsoft SQL Server 的任务，并理解整个迁移流程中的技术要点。
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.
