Hi all

I'm new in TOS, I'm trying to make a job to migrate table data from an old Oracle database schema to a new MSSQL schema and I have a problem i with the following situation:

the Oracle table is :
--------------------------------|
GROUP                              |
--------------------------------|
CODE_GROUP                    |
CODE_GROUP_MOTHER      |
--------------------------------|

the MSSQL Server table is:
------------------------|
GROUP                    |
------------------------|
ID_GROUP               |
ID_GROUP_MOTHER |
CODE_GROUP          |
------------------------|

There is a self relation in the GROUP table with the columns CODE_GROUP and CODE_GROUP_MOTHER.

My problem is that the MSSQL ID_GROUP column must be IDENTITY and we can't reuse the Oracle table CODE_GROUP column because this table belongs to a legacy system but I put it in the MSSQL table CODE_GROUP column.

I don't know how to make the job to mantain this join on the target table

Last edited by daniel_garcia (2010-01-04 19:12:13)