1

I want to migrate a postgres DB that uses JSONB fields to a MySQL DB with the new JSON fields.

The question was answered for databases without json - but both solutions don't support json fields

Improve this question
3
  • it does now (a relatively recent edition) Commented Nov 10, 2015 at 20:17
  • 2
    MySQL just added a JSON data type in 5.7.8. Without more information about your use of JSON I can't say much more than to use at least 5.7.8. With a feature that brand new (they're only on 5.7.9) I'd be wary. Commented Nov 10, 2015 at 20:17
  • I use the latest version, that does indeed support json fields. but the migration tools (including the one in workbench) don't support it. Commented Nov 10, 2015 at 20:20
Related questions
0
MySql table into JSON format
0
Getting errors while migrating this JSON data to postgresql
3
PostgreSQL table to json
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.