Hi,
Can we change the schema name on the server directly. Because when we migrate the whole workbooks we need to download edit the custom sql and then publish back. is there any way to change?
Unfortunately no. That's another drawback of using custom sql.
You'll need to download this workbook and edit by hand.