Practical Guide to Large Database Migration

1. Auflage 2021
ISBN: 978-0-367-78007-4
Verlag: CRC Press

Buch, Englisch, 206 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 398 g

It is a major challenge to migrate very large databases from one system, say for example, to transfer critical data from Oracle to SQL Server. One has to consider several issues such as loss of data being transferred, the security of the data, the cost and effort, technical aspects of the software involved, etc. There a very few books that provide practical tools and the methodology to migrate data from one vendor to another. This book introduces the concepts in database migration with large sample databases. It provides step by step guides and screenshots for database migration tools. Many examples are shown for migrating Oracle, SQL Server and MySQL databases.

Autoren/Hrsg.

Zhang, Preston

Fachgebiete

• Naturwissenschaften Biowissenschaften Biowissenschaften
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Software Engineering
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken

Inhaltsverzeichnis

Introduction to Data Migration. Data Migration Phases. Sample Large Databases. Migrating Databases to MySQL. Migrating Databases to SQL Server. Migrating Databases to Oracle.

Über Autor(innen)

Preston Zhang has over 20 years of experiences in database design and implementation. As a database administrator, he manages Oracle, SQL Server and MySQL database servers for university departments in Georgia. He has done many database migration projects in Oracle, SQL Server and MySQL database systems. He has written many queries in Oracle SQL, SQL Server T-SQL and MySQL to process millions of records for business reports. He has developed Web applications using Oracle database as back-end for a large health care company. He has taught undergraduate database and programming courses in private universities for over 10 years. He has a Master of Science degree in Computer Information Systems from University of Wisconsin-Parkside. He lives in Georgia with his family and can be reached at [e-mail].