Practical Guide to Large Database Migration  book cover
SAVE
$33.99
1st Edition

Practical Guide to Large Database Migration




ISBN 9781138391628
Published April 3, 2019 by CRC Press
206 Pages 298 B/W Illustrations

 
SAVE ~ $33.99
was $169.95
USD $135.96

Prices & shipping based on shipping country


Preview

Book 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

...
View More

Author(s)

Biography

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]