Migrate multiple database systems
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.
What you’ll learn
- Migrate data from SQL Server to Oracle.
- Migrate data from MS Access to SQL Server.
- Migrate data from MySQL to SQL Server.
- Create migration repository.
- Create migration user.
- Backup database before migration.
- Perform pre-migration assessment.
- Perform post-migration checks.
- Validate data mappings.
- Migrate schema and data.
Course Content
- Microsoft SQL Server Setup –> 10 lectures • 55min.
- Access Database Setup –> 2 lectures • 5min.
- Database Migration: MS Access To MSSQL Server –> 8 lectures • 31min.
- MySQL Database Server Setup –> 4 lectures • 28min.
- Data Migration: MySQL To SQL Server –> 8 lectures • 34min.
- Oracle Database Setup –> 4 lectures • 28min.
- Data Migration: SQL Server To Oracle –> 9 lectures • 50min.
Requirements
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.
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.
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.
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately