This is really a SQL Server question but I am trying to script 50 tables
from SQL Server to Oracle using DTS.

My problem is the Identity seed/sequence columns and default values are
not being copied.

If I pre-script all the tables using the "Script object" utility it is
no longer compliant with Oracle's sql syntax.

Has anyone had to do this before?

-Kevin

MS Sql Server LazyDBA home page