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

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 http://sqlite2ce.codeplex.com/ 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.

Thanks.

share|improve this question

closed as off-topic by Paul White, Phil, RolandoMySQLDBA, RLF, Michael Green Jan 24 '15 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.

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.