相關主題
商品描述
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.
商品描述(中文翻譯)
將非常大的資料庫從一個系統遷移到另一個系統，例如，將關鍵數據從 Oracle 轉移到 SQL Server，是一個主要挑戰。必須考慮幾個問題，例如轉移過程中數據的丟失、數據的安全性、成本和努力、涉及的軟體的技術方面等。提供實用工具和方法論以將數據從一個供應商遷移到另一個供應商的書籍非常少。本書介紹了大型樣本資料庫的資料庫遷移概念。它提供了逐步指南和資料庫遷移工具的截圖。書中展示了許多遷移 Oracle、SQL Server 和 MySQL 資料庫的範例。
作者簡介
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.
作者簡介(中文翻譯)
Preston Zhang 擁有超過 20 年的資料庫設計與實作經驗。作為一名資料庫管理員，他負責管理喬治亞州大學各系的 Oracle、SQL Server 和 MySQL 資料庫伺服器。他參與了多個 Oracle、SQL Server 和 MySQL 資料庫系統的資料庫遷移專案。他在 Oracle SQL、SQL Server T-SQL 和 MySQL 中撰寫了許多查詢，以處理數百萬條記錄以生成商業報告。他為一家大型健康照護公司開發了使用 Oracle 資料庫作為後端的網頁應用程式。他在私立大學教授本科資料庫和程式設計課程超過 10 年。他擁有威斯康辛州帕克賽德大學的計算機資訊系統碩士學位。他與家人居住在喬治亞州，聯絡方式為 pzhang0@hotmail.com。
