converting date type during migration from SQL server to Orcale
644653Jul 9 2008 — edited Jul 10 2008Hi,
I have a problem about date type converting from SQL Server to Orcale. As I know, the date type DATETIME [SQL] to TIMESTAMP [ORC] and SMALLDATETIME [SQL] to DATE [ORC]. So, I set DATETIME: yyyy-mm-dd HH24:mi:ss.ff3 and SMALLDATETIME: yyyy-mm-dd HH24:mi:ss in Preferences > Migration > Data Move Options.
But when I came to Captured Model and select datatype mapping. The default mapping is set both DATETIME and SMALLDATETIME to DATE. Should I change the DATETIME to TIMESTAMP manuelly or keep the default setting? Please advice. Thanks.