Can the encrypted password in the ocp file be decrypted?
I am using Oracle Schema Compare as part of an SSIS solution to move data from one environment to another. I want to make this as automated as possible. One of the ways I would like to do this is by automatically setting data source connection strings at runtime. I'm using the command-line along with a project file for the database scripting. I have a loop that loops over all of my ocp files and runs the compare/deploy (DB to Script). For each project file, I will also need to connect to that database to extract the data. I noticed that the ocp file has all of the connection info that I need to make the connections dynamically except the password for the DB is encrypted. Is there any way to read that encrypted value from the ocp file and decrypt it co that it can be used in creating the connection string? I'd like to avoid having yet another configuration item to maintain across all environments when everything I need is already contained in the ocp file.
0 · Share on Twitter