下面的命令加载数据到目标数据库中。
The following command loads the data into the target database.
每个联邦目标数据库都需要一组控制表。
One set of control tables is needed for each federated target database.
访问目标数据库不需要执行数据整合过程。
Accessing the target database does not require the execution of a data-consolidation process.
把源和目标数据库的数据存储都分配给用户。
Assign both the datastores for your source and target databases to users.
为目标数据库添加数据存储的步骤是相同的。
Use the same steps as a guide for adding a datastore for your target database.
方法1要求目标数据库被配置为联邦数据库。
Approach 1 requires that the target database is configured as federated database.
DDL还可以回滚,但这取决于目标数据库的功能。
Based on the target database capabilities, the DDL can also be rolled back.
因此,这种方法的性能特性仅由目标数据库服务器决定。
Therefore, the performance characteristics of this approach are determined only by the target database server.
也就是说,为了成功地执行复制,需要访问目标数据库。
This means in order to perform the replication successfully, the target database needs to be accessed.
容器将用能被目标数据库接受的最低级锁定来装载数据。
The container will load the data with the weakest lock available for the targeted database.
用户名必须与目标数据库中创建表时所在的模式相匹配。
The user name must match the schema name where tables are created in target database.
使用XML配置文件为每个目标数据库定义不同的SQL。
Use XML configuration files to define different SQL for each target database.
对于本文中的示例,目标数据库服务器是DB 2UDB。
For the example in this article, the target database server is DB2 UDB.
本节概述在源数据库和目标数据库之间设置复制订阅的步骤。
This section gives an overview of the steps to set up a replication subscription between your source database and a target database.
如果目标数据库是DB2,将已配置的捕获文件绑定到db2包。
Bind the configured capture file into DB2 packages, if the target database is DB2.
但是,首先应该在目标数据库mysample中创建存储过程。
But first you should create your stored procedure in the destination database MYSAMPLE.
下面的表展示了MT K目前支持的源数据库与目标数据库的组合。
The following table shows the source and target database combinations that MTK currently supports.
运行此工具需要连接目标数据库,所以必须首先创建这个数据库。
Since a database connection to the target is required to run the tool, the DB2 database must be created first.
LOAD_ONLY:将指定的所有表从源数据库装载到目标数据库中。
LOAD_ONLY: Loads all specified tables from the source database to the target database.
本节描述为源和目标数据库创建数据存储并把它们分配给用户所需的步骤。
This section describes the steps required to create datastores for your source and target databases and assign them to users.
方法1-在目标数据库中,使用DB2的联邦数据库机制访问源数据库。
Approach 1 - From within the target database, the source database is accessed using DB2's mechanisms for federated databases.
SCHEMA_MAP允许用户在向目标数据库进行复制时对模式重新命名。
SCHEMA_MAP Allows user to rename schema when copying to a target.
这份报告表明被部署到Informix目标数据库的源数据库对象的数量。
This report indicates the number of source database objects deployed to Informix target database.
如果源数据库和目标数据库不在同一个实例中,那么必须对源数据库进行编目。
The source database must be cataloged if it does not reside in the same instance as the target database.
针对整合目标的服务请求的事务响应时间主要由目标数据库服务器的特性决定。
The transaction response time of a service request against the consolidated target is primarily determined by the characteristics of the target database server.
在为源数据库添加数据存储之后,按照相同的步骤为目标数据库添加数据存储。
After you finish adding a datastore for your source database, use the above steps as a guide and add another datastore for your target database.
由于到达目标数据库之前有多个跃点(hop),所以性能可能会有一些下降。
Due to the fact that there are multiple hops to get to the target database, it is possible that there might be some performance degradation.
这里共有五个步骤,来实现从源数据库中提取数据并且加载到目标数据库中去。
There are five steps to extract data from the source database and load it to the target database.
不断地复制或获取源数据库上的非活动日志文件,并在目标数据库上前滚它们。
Continually copy over or retrieve the inactive log files from the source database and roll them forward on the target database.
如果要从同一个逻辑模型实现多个目标数据库,那么可以使用创建新模型的选项。
The option to create a new model is good to implement multiple target databases from the same logical model.
应用推荐