Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Your Answer


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.