使用IBM Data Movement Tool从SQL Server/Oracle到DB2的表数据迁
本文基于我们的成功实践,总结出如何使用 IBM Data Movement Tool 实现从 SQL Server/Oracle 到 DB2 的表数据迁移,并针对表数据迁移过程中遇到的常见问题,给出相应的解决方案。
SQL Server,Oracle 及 DB2 都是目前市场上很多应用程序所使用的关系型,随着应用程序功能的日趋强大,应用程序的版本升级和重新安装都将要求保留原有数据。这样不同类型之间的迁移成了现在应用程序功能中数据迁移部分的重点。目前市场上出现了一些数据库迁移工具(比如:IBM Data Movement Tool)。互联网上针对这些工具的介绍大部分都是基于数据对象的整体迁移,也就是在数据结构迁移的基础上进行数据迁移。但是有些应用程序并不需要数据结构的迁移,而是仅仅需要表数据的迁移。比如 IBM SPSS 的一款产品 Collaboration and Deployment Services (简称:CADS。CADS 是一个可以广泛使用和部署的企业级平台,它可以集成 IBM SPSS 的其它预测分析产品比如 IBM SPSS Modeler,IBM SPSS Statistics 或者 IBM SPSS Data Collection,从而向用户提供完整的商业解决方案。), 它支持 SQL Server, Oracle, DB2 等多种数据库。在安装 CADS 的时候,安装程序会自动创建数据库对象,包括表结构,视图,函数,存储过程等。在安装和使用 CADS 的时候,会对表数据进行增、删、改、查的操作。对此款产品考虑跨数据库类型迁移数据时,最初的迁移步骤为:创建源数据库 -> 安装源 CADS -> 产生源数据 -> 创建目标数据库 -> 用第三方数据迁移工具从源数据库向目标数据库迁移数据 -> 安装目标 CADS 。由于在安装目标 CADS 服务器的时候,会自动重建视图,函数,存储过程等除表数据之外的其他对象,所以其他对象不需要使用第三方数据迁移工具进行迁移。而对于表结构,使用第三方迁移工具生成的目标表结构和通过安装目标 CADS 服务器所创建的表结构差异很大(主要是数据类型的差异),因此,如果在用第三方迁移工具迁移表结构及表数据后安装目标服务器,将很难保证目标服务器对数据类型的正确处理。所带来的问题隐患也是不可估量的。所以,为了减少数据迁移带来的隐患,CADS 决定采用第三方迁移工具仅仅迁移表数据。这样,CADS 的跨数据库类型的迁移步骤就变为:创建源数据库 -> 安装源 CADS 数据库 -> 产生源数据 -> 创建目标数据库 -> 安装目标 CADS 服务器 -> 使用第三方迁移工具仅仅迁移表数据 -> 在迁移后的目标数据库上重新部署 CADS 服务器。对于 CADS 来说,重新部署非常简单,所以采取这种方案进行数据迁移,就可以避免数据类型带来的问题隐患。
现在,很多应用程序的架构类似于 CADS,这就要求考虑如何使用第三方迁移工具仅仅实现表数据迁移。本文将基于我们的成功实践,总结出如何使用 IBM Data Movement Tool 实现从 SQL Server/Oracle 到 DB2 的表数据迁移,并针对表数据迁移过程中遇到的常见问题,给出相应的解决方案。
迁移工具简单介绍及表数据迁移步骤详细介绍
IBM Data Movement Tool 简单介绍
此工具是一个非常简单但是强大的工具,它支持从 MySQL、PostgreSQL、 Teradatra、SQL Server、Sybase、Oracle、 DB2、Access 等数据库迁移到 DB2 数据库。并且提供了图形界面和命令行两种方式,操作起来也很方便。
本文主要介绍如何利用 IBM Data Movement Tool 仅仅进行表数据的迁移。
用 IBM Data Movement Tool 进行从 SQL Server/Oracle 到 DB2 的表数据迁移步骤
使用 IBM Data Movement Tool(以下简称 IDMT)进行数据迁移有两种方式:图形界面方式和命令行方式。此章节就基于这两种方式详细介绍从 SQL Server/Oralce 到 DB2 9.7 LUW 的表数据迁移步骤。
在使用 IDMT 进行数据迁移之前,需要做一些准备工作,使 IDMT 可以连接源数据库和目标数据库。
基于图形界面方式的数据迁移
步骤 1 — 连接源数据库和目标数据库
打开 IDMT 图形界面,在“Extract/Deploy”页面,在源数据库(Source Database)和目标数据库(Target Database)中填写相应的信息。需要注意的是:在 Migration 一行,仅仅需要选中“DDL”和“Data”两个复选框。然后点击“Connect to ORACLE”和“Connect to DB2”按钮,以保证源数据库和目标数据库可以连接成功。请参考图 1 。
图 1 提取及加载数据对话框
步骤 2 — 设置参数
如果迁移的数据中,存在 Graphic 和 DBCLOB 类型的数据,则在“Set Params”页面,需要设置“Graphic”和“DBCLOB”为 true。然后点击“Save Params”按钮。请参考图 2 。
图 2 参数设置对话框

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

IBM suddenly announced a new round of layoffs! IBM's chief communications officer announced the news at the latest seven-minute staff meeting. This time it will mainly focus on the marketing and communications departments. Although IBM did not issue a formal statement on the scale of layoffs, as recently as January this year, they announced that they would lay off 3,400 people. The company's CEO Arvind Krishna said earlier that the company will replace 8,000 jobs with artificial intelligence in the next five years. This whole sudden operation directly confused the employees...Have these 8,000 people started laying off employees long ago△Source: One Acre and Three Minutes According to statistics from relevant websites, about 204 technology companies have laid off employees so far this year Nearly 50,000 people. Including Google parent company Alphabet, Amazon

IBM recently announced a new set of products that build on the recently launched generative AI coding capabilities for mainframe developers to make it easier to run artificial intelligence on their older data center hardware. IBM said in an update to IBMZ Designed to help customers improve business outcomes by implementing business AI across multiple industries and use cases, it includes a new set of developer toolkits supporting the most widely used AI frameworks and Python programming language, enhancements to Machine Learning forz/OS , and performance improvements in the IBMz/OS mainframe operating system. IBM said these updates will allow clients to improve the accuracy of policy advice, improve the reliability and timeliness of anti-money laundering controls, and reduce

The full English name of ibm is "International Business Machines Corporation", which refers to International Business Machines Corporation or International Business Machines Corporation, with its head office in Armonk, New York.

IBM recently launched a new enterprise investment vehicle, the Enterprise Artificial Intelligence Venture Fund. The fund aims to back startups working to develop enterprise-focused AI products. IBM's move follows other tech giants also ramping up investments in the AI startup ecosystem. A few weeks ago, AnthropicPBC, a large language model developer, received a total of up to $6 billion in financing from Amazon and Google. Recently, Hewlett Packard Enterprise and SAPSE joined a more than $500 million investment in German artificial intelligence provider AlephAlpha GmbH. IBM intends to support a number of startups "from early stage to hyper-growth" through its Enterprise Artificial Intelligence Venture Fund. According to media reports, I

ChatGPT is popular on the Internet, and the AI model training behind it has also attracted widespread attention. IBM Research recently announced that the cloud-native supercomputer Vela it developed can be quickly deployed and used to train basic AI models. Since May 2022, dozens of the company’s researchers have been using this supercomputer to train AI models with tens of billions of parameters. Base models are AI models trained on large amounts of unlabeled data, and their versatility means they can be used for a range of different tasks with just fine-tuning. Their scale is enormous and requires massive and costly computing power. Therefore, as experts say, computing power will become the biggest bottleneck in developing the next generation of large-scale basic models, and training them requires a lot of computing power and time. Training available

IT House reported on October 31 that IBM recently issued a press release stating that in order to alleviate the current shortage of language programmers proficient in COBOL (a programming language designed and developed in 1959), it launched the generative AI programming assistant "watsonx". IBM launched a service called "IBMZ" in August this year, aiming to convert COBOL into Java language. Recently, the service was officially launched under the name "watsonx". Watsonx's core functions simplify the conversion of COBOL code to Java and are designed to modernize large computers. IBM said the artificial intelligence assistant is extremely accurate in code translation and can reduce

According to statistical analysis based on public data by intellectual property management company Anaqua, the region with the largest number of semiconductor patents in the world in 2023 will be the United States. This is the second consecutive year that the United States has topped the list. The company uses advanced AcclaimIP patent analysis software to analyze semiconductor-related patents published by the U.S. Trademark and Patent Office. The results show that the number of semiconductor patents in 2023 reached 348,774, a slight increase compared with 347,408 in 2022. According to countries and regions, the number of patents obtained by American companies is 162,557, ranking first among all countries, an increase of 18% from 2022. The data shows that Japan ranks second (40,960 cases), followed by China (2

IBM put its AI and hybrid cloud strategy at the center of its annual IBMThink conference. While other vendors have been focusing on the consumer side of new AI applications over the past few years, IBM has been developing a new generation of models to better serve enterprise customers. IBM recently announced the launch of watsonx.ai, an AI development platform for hybrid cloud applications. IBM WatsonxAI development services are currently in the technology preview stage and will be generally available in the third quarter of 2023. AI will become a key business tool, ushering in a new era of productivity, creativity and value creation. For enterprises, it’s not just new AI constructs that access large language models (LLMs) through the cloud. Large language models make up Chat
