Practical Guide to Large Database Migration

ISBN-13: 9781138391628 / Angielski / Twarda / 2019 / 198 str.

Preston Zhang

Opis

This book introduces concepts in database migration with large sample databases. It has step-by-step guidelines and screenshots for database migration tools. Many detailed cases are provided for migrating Oracle, SQL Server and MySQL databases.

Spis treści

　

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

O autorze

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.