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

Practical Guide to Large Database Migration

1st Edition

By Preston Zhang

CRC Press

200 pages | 100 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9781138391628
pub: 2019-04-15
SAVE ~$25.49
Available for pre-order
$169.95
$144.46
x


FREE Standard Shipping!

Description

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

 

Contents

Preface

Introduction to Database Migration

What is Database Migration

Database Migration Stages

Database Migration Paths

Database Migration Tools

Sample Large Databases

Summary

 

SQL Server Database Migration

SQL Server to MySQL Migration Example

SQL Server to SQL Server Migration Example

SQL Server to Oracle Migration Example

Summary

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

Summary

MySQL Database Migration

MySQL to MySQL Migration Example

MySQL to SQL Server Migration Example

MySQL to Oracle Migration Example

Summary

 

 

 

 

 

 

 

 

 

 

 

 

More About MySQL Workbench

MySQL Database Modeling

MySQL Server Management

MySQL Synchronization

Unique MySQL INSERT IGNORE Statement

Summary

Oracle Database Migration

Oracle to MySQL Migration Example

Oracle to SQL Server Migration Example

Oracle to Oracle Migration Example

Summary

More About and Oracle SQL Developer and Oracle EM

Oracle Query Builder

Oracle SQL Developer DBA Tool

Oracle 12c Enterprise Manager Database Express

Summary

Microsoft Access Database Migration

Microsoft Access to MySQL Migration Example

Microsoft Access to SQL Server Example

Microsoft Access to Oracle Migration Example

Summary

Index

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 pzhang0@hotmail.com.

Subject Categories

BISAC Subject Codes/Headings:
COM021000
COMPUTERS / Database Management / General
COM051010
COMPUTERS / Programming Languages / General
COM051230
COMPUTERS / Software Development & Engineering / General