- 论坛徽章:
- 0
|
给你提供两个思路, 因为不知道具体需求,前一种适合简单, 后一种适合复杂情况,比如一对多,星型复制等,可靠性强,对复制粒度,方式,容错等有较好支持,缺点是配置/管理较复杂.
1. User proxy databases
When a user proxy database is created, metadata for the proxy tables is imported automatically from the remote location that contains the actual tables. This metadata is then used to create proxy tables within the proxy database.
To create a proxy database, use:
create database <dbname>
[create database options]
[with default_location = ’pathname’]
[for proxy_update]]
2. Use Sybase replication server
基本原理如 Source DB -->Queue--> Replication Server --> Target DB, 复制基于扫描log --> SQL --> 优化 --> 目标地执行 |
|