Hi , i am working on automating syncing up of DDL's from prod to non-prod environments.
I am trying to export the DDL using tpt script to a file and use that file to sync up.
I havenot mentioned any schema section in my tpt script as i am not fetchcing any data but just fetch ddl.
But getting below error. Could you please let me know how we can do this or any other better way to accomplish this?
TPT_INFRA: Syntax error at or near line 7 of Job Script File 'tabletofile.tpt':
TPT_INFRA: At "(" missing SCHEMA_ in Rule: Schema Specification
Could you please provide your inputs on my above comment as i am struck at this point and any suggestion would be very helpful.