Pre-script introduction in the scheme compare deployment script.
Hi , I am trying to understand how to introduce a pre-script ALTER SESSION SET CURRENT_SCHEMA = <> SQL statement in the top of the deployment script which is generated during the schema compare either between source DB vs target DB or TFS vs Target DB.
There's no way of doing this right now, although it's something we might add in future. Your best bet is either to add it manually, or if you're automating, run your own pre-deployment script with sqlcl or sqlplus prior to running Schema Compare's deployment script. Can I ask why you need this particular statement? Are you generating scripts without schema names so you can execute on a different schema target?