|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/5/2009 4:31:06 PM
Posts: 3,
Visits: 3
|
|
I am attempting to write a TPT script to move data from one table to another. The tables are on two different Teradata systems (one is production the other is test). My source and target table are exactly the same in every way (fields, datatypes,...). I was able to get the script to work no problem.
Here is my question. Since the tables are exactly the same, does the script need to have DEFINE SCHEMA listing all the fields and data types?
Sure would be nice not to have to define field level details. My ultimate goal is to create a dynamic TPT script moving a variable table list and it would be sure nice not to have to go down to field level definitions.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
We do understand that it would be nice to not have to specify a schema object in the script, and we are working towards that goal. If you have further questions on this, do not hesitate to ask, and please send all questions to the Tools section of the Developers Exchange site.
Thanks!
|
|
|
|