DataDeploy and database Synonyms

Does anybody know whether or not DataDeploy 5.5.2 is able to deploy to a table via a database synonym rather than directly to the database table? For example our target table is called ABC and is owned by OWNER1. However we wish to connect DataDeploy to the database using a user of DEPLOY1. What seems to happen is that DataDeploy looks for a table called DEPLOY1.ABC. In this scenario this table does not exist as it is actually called OWNER1.ABC. To get around this we created a synonym so that DEPLOY1.ABC maps to OWNER1.ABC. However DataDeploy is still indicating that the table does not exist.

Any thoughts?

Find more posts tagged with

Comments

Michael

You could try using the exists-sql element to override the SQL that DD uses to check for the existance of the table.

Hope that helps.

Cheers
Michael

AndyL

Michael

Sounds like an idea worth pursuing. Would you know whereabouts in DataDeploy we would find this SQL in order to change it?

Thanks
Andy

Michael

Hi Andy

Check out your DataDeploy Admin guide. Search on exists.

It is something you put in your XML deployment config.

Cheers
Michael