Data2Data™ is a unique program that allows you to move data and data objects (tables, views, keys, and indexes) between different DBMS systems. Currently supported are: Sql Server, Oracle, MySql, and OleDb (reading only for OleDb). And it's very affordable.  A general description of the program and its features appears below.  For more details, read the documentation and FAQ.

The program generates several different logs to give you a complete picture of what occured, including:

• DDL log: contains complete DDL used to create the new objects in your destination database
• Data log: contains every select and insert statement used to copy data from your source to your destination
• Error log: contains any errors thrown by your destination database when either creating data objects or copying data

It's also very easy to use. Within just a few minutes, you can copy an entire schema and its data in six simple steps:

1. Choose your source DBMS type (currently supported are Sql Server, Oracle, MySql, or any OleDb data store)
2. Log into your source database
3. Choose the objects you wish to copy
4. Choose the .Net provider of your destination DBMS
5. Log into your destination database (currently supported are Sql Server, Oracle, and MySql)
6. Choose whether or not to copy data also, and click "Export"

Since Data2Data™ is .Net based (written in C# using entirely "managed" code), you can use the OleDb source option to conceivably enter any compliant OleDb connection string to read from any OleDb data store, and then copy it to any of the three supported destination DBMS types. Limitations to this option may exist depending on the particular OleDb provider used, but we have tested successfully with Access and Excel, both Jet 4.0 and Jet 12.0. If there's a particular provider you'd like to use, feel free to test it out using our Evaluation Edition. (The Evaluation Edition is fully functional and never expires, but it limits you to copying only three tables at a time.)