Practical Guide to Large Database Migration: 1st Edition (Hardback) book cover

Practical Guide to Large Database Migration

1st Edition

By Preston Zhang

CRC Press

198 pages | 298 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9781138391628
pub: 2019-04-03
SAVE ~$33.99
eBook (VitalSource) : 9780429422621
pub: 2019-03-27
from $28.98

FREE Standard Shipping!


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.

Table of Contents




Introduction to Database Migration

What is Database Migration

Database Migration Stages

Database Migration Paths

Database Migration Tools

Sample Large Databases



SQL Server Database Migration

SQL Server to MySQL Migration Example

SQL Server to SQL Server Migration Example

SQL Server to Oracle Migration Example


More About SQL Server Management Studio

Visual Database Design

SQL Server Query Designer

Generating Scripts

Activity Monitor

Query Options

Template Browser

Database Engine Tuning Advisor

Disk Usage Report

Database Properties

SQL Server Backup


MySQL Database Migration

MySQL to MySQL Migration Example

MySQL to SQL Server Migration Example

MySQL to Oracle Migration Example














More About MySQL Workbench

MySQL Database Modeling

MySQL Server Management

MySQL Synchronization

Unique MySQL INSERT IGNORE Statement


Oracle Database Migration

Oracle to MySQL Migration Example

Oracle to SQL Server Migration Example

Oracle to Oracle Migration Example


More About and Oracle SQL Developer and Oracle EM

Oracle Query Builder

Oracle SQL Developer DBA Tool

Oracle 12c Enterprise Manager Database Express


Microsoft Access Database Migration

Microsoft Access to MySQL Migration Example

Microsoft Access to SQL Server Example

Microsoft Access to Oracle Migration Example



About the Author

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]

Subject Categories

BISAC Subject Codes/Headings:
COMPUTERS / Database Management / General
COMPUTERS / Programming Languages / General
COMPUTERS / Software Development & Engineering / General
SCIENCE / Life Sciences / General