Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Our old product supports 4 different database types for storing data:

  • SQLite
  • MySql
  • Sql Server CE
  • Sql Server

There is also an export feature, which allows to export some data and here is the problem - it actually exports the database itself:

  • SQLite and Sql Server CE - the database file (*.db3 or *.sdf respectively)
  • Sql Server - the database backup file
  • MySql - the whole database directory

Stupid, right? We also came to think so. So, I had to write a tool, which given an old export file converts it to some database independent binary format.

The problem is how to unit test it? At the very least, I need 4 databases with identical data, which brings me to my question:

Is there a tool to reliably convert between the 4 databases? 

Note, that I do not need a super duper tool, which knows to do all the pairwise conversions.

Until now I used to convert SQLite to Sql Server CE, but besides having had to fix several bugs in their code, there is a deeper issue with their conversion - all the integral types become 64 bits long after the conversion, which is not good for me.


share|improve this question

closed as off-topic by Paul White, Phil, RolandoMySQLDBA, RLF, Michael Green Jan 24 at 10:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, RolandoMySQLDBA, RLF, Michael Green
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

You may be able to use Kettle, aka Pentaho Data Integration, to do this.

If not supported natively, someone will have written a plug in for SQL Server CE/SQLLite. Kettle supports any JDBC compliant data source. MySQL and SQL Server are supported of course

share|improve this answer

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