1st Edition

Practical Guide to Large Database Migration

By Preston Zhang Copyright 2019
    206 Pages
    by CRC Press

    206 Pages 298 B/W Illustrations
    by CRC Press

    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.

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


    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 [email protected].