on 05-13-2015 1:52 PM
Hi.
I have implemented replication from Sybase to Oracle using MSA (via ECO at Oracle site).
I have a simple MSA replication scenario:
1. 2 physical connections (Primary: Sybase, Replicate: Oracle)
2. One *database* replication definition (primary server: Sybase ASE)
3. One subscription (connection to replicate server: Oracle via ECO).
My problem:
On primary Sybase site I have ALL tables in DBO schema to replicate.
On replicate Oracle site I do not have DBO schema (I use different destination schema names).
All transactions on Replicate site are with DBO prefix....but it does not exist in Oracle.
Question:
Is there any way to force RS to either:
- omit schema name in tranactions ("insert into table" instead of "insert into dbo.table....")
or
- change dest. schema name (force insert into myoracleschema.table)
I don't want to do this at table level (because I use MSA/Database RepDef. - over 2000 tables...).
Is there any way I can override dest. schema name ? Can I use Function Strings at Database Replication Definition level?
Or other DSI connection parameters?
I will be grateful for your help.
Best regards.
--
Marcin
Marcin,
If your replication server version is SP200 or later, please try this:
alter connection to ECO.ECO
set schemamap from ASE_PDS.ASE_DB.DBO to myoracleschema
go
check schema map
go
suspend connection to ECO.ECO
go
resume connection to ECO.ECO
go
Hunter Liu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.