View Issue Details

IDProjectCategoryView StatusLast Update
0002247SymmetricDSBugpublic2020-02-19 09:37
Reporternatarajan Assigned To 
Priorityurgent 
Status newResolutionopen 
Product Version3.7.11 
Summary0002247: dbexport oracle date type with "default sysdate" not compatible with other databases
DescriptionIn mysql we don't have default sysdate and date should be converted to datetime.

Please let us know if you have solution for this one?

Oracle

CREATE TABLE CTT1.TTT_USER_METRICS_HISTORY
(
  USER_ID NUMBER,
  TRANSACTION_ID VARCHAR2(100 BYTE),
  TRANSACTION_COUNT NUMBER,
  LST_UPTD_DTTM DATE DEFAULT SYSDATE NOT NULL
)

MYSQL
CREATE TABLE `TTT_USER_METRICS_HISTORY`(
    `USER_ID` DECIMAL,
    `TRANSACTION_ID` VARCHAR(100) NULL,
    `TRANSACTION_COUNT` DECIMAL,
    `LST_UPTD_DTTM` DATE DEFAULT SYSDATE NOT NULL
)
Tagsddl/schema

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-03-31 14:25 natarajan New Issue
2019-04-23 12:58 elong Tag Attached: ddl/schema
2019-05-13 16:20 elong Summary dbexport oracle to mysql date datatype => dbexport oracle date type with "default sysdate" not compatible with other databases