Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

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

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

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.