Data migration from SQL Server to Oracle + Identity Column

[TSrinivasan]

Hi All,
I am doing data migration from SQL Server to Oracle using TOAD for the first time. I export data from SQL Server to a notepad file. I import data using TOAD from that notepad file. When I try to do for normal tables it works fine.

When I am trying to import data which has IDENTITY column in the table it is not importing the data.


Please do advice me.

Thanks in advance,
Srinivasan.T

[debasisdas]

There is nothing like IDENTITY in oracle.

[bxchen]

I suggest you try DFSTrans, it provide the way to handle auto increase number for IDENTITY column. here is the web site: www.DirectFocus Software.com.