Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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