topic Re: Migrate all tables named SC_% from Oracle to SQL Server. in Talend Studio

Migrate all tables named SC_% from Oracle to SQL Server.

Anonymous — Wed, 20 Apr 2016 21:00:19 GMT

Hi All,
My needs are to move about 130 Oracle tables named with "SC_" string, into SQL Server. Blank tables with equvalent datatypes are already created in SQL Server.

I was hoping to create a job using tOracleTableList component, use "CURRENT_TABLE" variable to and be able to use it for tOracleInput and tMSSQLOutput components.

Not sure if this would work, so wanted to take some advise as to how to achieve this task?

Re: Migrate all tables named SC_% from Oracle to SQL Server.

Anonymous — Thu, 21 Apr 2016 10:31:31 GMT

Hi
you are on a good way, but the tablename is not imporant at this position.
You need to build a dynamic query : "select * from " + YOURTABLENAME and place this in the toracleinput query box

the YOURTABLENAME must then be in you mssqloutput tablename box

and it shoukld work ( if you are in TIS and have dynamic row type)

HTH

Re: Migrate all tables named SC_% from Oracle to SQL Server.

Anonymous — Thu, 21 Apr 2016 13:56:26 GMT

djdeejay,
Thanks for reply.
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] I'm still a beginner and do not understand your suggestions.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] 1) How would I supply the value for YOURTABLENAME in the dynamic query.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] 2) Is YOURTABLENAME a variable, if yes, then how do I set it using the properties tab?[/font][/color]

[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] Please guide.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] Thanks,[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] DP.[/font][/color]

Re: Migrate all tables named SC_% from Oracle to SQL Server.

Anonymous — Fri, 22 Apr 2016 08:09:27 GMT

CURRENT_TABLE might be YOURTABLENAME, but if you have some more time, wait for me, then i come over and do the job for you