How to create a table in one TD server using DDL in other TD server

Tools & Utilities
Highlighted
Enthusiast

How to create a table in one TD server using DDL in other TD server

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

1 REPLY 1
Enthusiast

Re: How to create a table in one TD server using DDL in other TD server

Hi All,

 

Could you please provide your inputs on my above comment as i am struck at this point and any suggestion would be very helpful.

 

Thanks.