You are not logged in.
I'm working on same topic..I noticed there are no developments on this issue.
Many people, it seems, would be interested in dynamically migrating tables.
AFAIK, the only way to do it is by writing temp schema file, anyway i didn't find any working example. The closest were topic:7208 and topic:5322
SQL templates could be a nice idea to start with, but I couldn't manage anything good.
Another idea could be to use ELT components, but again, I tried with no success.
Let me know if you had some news about this..
Before you start screaming "It can't be done in TOS!!!".
Let me say that I have done some digging within the forums and I do understand that TOS is a schema oriented graphical design, which means that schemas are defined at design time and not at execution time. Also I have looked at the following posts:
Dynamic job , Rotating file
With that in mind on to my question....
First is there any new development on this subject? Most of the posts are about a year old, some older than that.
Are there any "tricks" or workarounds for this?
Can tJava be used to do it programatically? If so, are there any examples that someone can point me to?
Currently I am working on delta synchronizations between PostgreSQL -> MSSQL. The tasks I create work great but I have to define a new task for each table since every table has a slightly different schema. So what I am trying to do is create a generic task that can pull the table schema from an *.xml and use that xml to build the schema for the given table.
Alternatively I do have all the schemas for all the tables in a DB... So is there a way to chose the correct schema for a given table at run time?
Currently I am using TOS 4.0 within XP.
Any help would be appreciated.