Is There A Way To Change Default Type Mapping?

[JasonR]

Hi.

Using the migration tool, all “datetime” columns in MS SQL Server are mapped to timestamp in MySQL by default. This is causing issues as most of the data in the datatime columns are date of birth and such and are therefor before 1970. Any dates before 1970 end up as 0000-00-00.

I know that in the migration tool I can manually change the mapping, but I have over 500 tables, a lot of which have at least 1 date that is effected by this.

So, I was hoping that there was a way of changing the default so I would not have to manually change each table.

Thanks,

Jason

[peterlaursen]

It is the ODBC driver that returns 'SQL_TYPE_TIMESTAMP' for the datatype.

There will always be issues with such datatypes that are not identical on different systems!

We have described the issue here:

http://webyog.com/faq/17_125_en.html

I think we chose the best option!

[JasonR]

peterlaursen wrote on Jun 29 2007, 03:06 PM:

It is the ODBC driver that returns 'SQL_TYPE_TIMESTAMP' for the datatype.

There will always be issues with such datatypes that are not identical on different systems!

We have described the issue here:

http://webyog.com/faq/17_125_en.html

I think we chose the best option!

Hi Thanks for the info.

I understand, and agree that timestamp is normally the best option. And was not suggesting that it be changed as the default.

I was just simply wondering if there was a way of changing this behavior temporarily. But that is fine, I will manually change the column mappings for the tables / columns that it effects.

Thanks for taking the time to respond.

Cheers,

Jason

[peterlaursen]

Actually we have discussed to add some 'global mapping' options.

But currently we don't have this option, and we cannot add it overnight!

[Author]

Posts