DB Migration: Last table data is blank (Output DB)

[Anonymous]

Hi,

Using the following job and settings, I was able to dynamically migrate a whole database from MSSQL to MySQL.

However, I noticed that the last table's data is blank (only the table structure and column is migrated).

Please refer to the screenshots and attached job file below.

**The table and its schema is migrated, but no data inside the table. // I'm using a dynamic schema.

Job Design and DBInput

dbinput

DBOutput

DBOutput

When I tried to logged each component, I found that the last table's data is loaded and pass on from tDBInput to tMap and also from tMap to tDBOutput, as the last table's data showed up in the log.

However, when I check the actual output database, only the last table contains no data at all.

Output DB's 1st Table - Have data

2nd (last) table - No Data

==============================================================

[Anonymous]

@manodwhb 

I tried to use on component trigger from tdboutput as suggested however there's an error

[manodwhb]

You are doing wrong your dbconnection component should trigger before tdbtablelist.

[Anonymous]

@manodwhb 

Here I tried connecting it like this and there's no error.

However, no data is inserted to the output database (not only the last one but all)

[manodwhb]

If you used tdbconnection component you no need to connect to tdbouput, since you are using Torrin, which will execute first.

[Anonymous]

@manodwhb

but when I use existing connection from tdbconnection component, the last table data is not inserted (that's the initial setting)

[manodwhb]

if that is the case built in of tdbouput and do not use the existing connection.