up vote 0 down vote favorite
share [g+] share [fb]

I have plenty of tables with SQL Server bit-type fields. When I run these through the MySQL Migration Toolkit, it seems by default they're converted to tinyint. This sucks for my code, because it's expecting true/false and it's getting possible values of 0-255.

Any idea where to change this conversion step in the migration toolkit?

link|improve this question
50% accept rate
feedback

1 Answer

up vote 1 down vote accepted

Resolved by not migrating everything live. Migration Toolkit allows for scripting the create and insert SQL statements. Modified these in Notepad++ and imported via PHPMyAdmin

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.