cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase -> Oracle replication question (schema name)

marcin_najs
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

marcin_najs
Explorer
0 Kudos

Thanks, works perfectly !

Best Regards.

--

Marcin

Answers (0)