QDatabaseConverter

[zweieck]

Hi,

i need to convert data of databases around (mysql, sqlite, oracle, Access, .. in all directions).
After searching i found some interesting things (like e.g. dbconvert.com).
In order to not reinvent the wheel i got the first important question:

• Does anybody know of such a (free) tool?
• Does anybody know of such a tool written in Qt?

But however i plan to develop something myself:

• a library to do the conversion job (in a Qt-ish style)
• a command line tool (obviously using the library)
• a GUI application allowing to Drag&Drop tables structure, data (or even only for example selected rows of source table) from source to target (think of it as 2 treeviews having an explorer like structure where you can copy data from different databases just like copying/moving files)

Do you think there might be a need for such tools?

Any hints for features appreciated.

Thanks,

RZ

[const]

But however i plan to develop something myself:

• a library to do the conversion job (in a Qt-ish style)
• a command line tool (obviously using the library)
• a GUI application allowing to Drag&Drop tables structure, data (or even only for example selected rows of source table) from source to target (think of it as 2 treeviews having an explorer like structure where you can copy data from different databases just like copying/moving files)

RZ

Hello, Zweieck! What about your plans? I think that such tools will be very useful for all database/qt developers.

[patrik08]

Hello, Zweieck! What about your plans? I think that such tools will be very useful for all database/qt developers.

I write one to extract from mysql + edit
to get on http://ppk.ciz.ch/qt_c++/mysql_model_browser/ 24 kb



if you write a url connection to db you can swap to other driver ...
and rewrite all global query

QString Scheme = QString( "mysql://username:pass@host:port/database" )
   QUrl dns(Scheme,QUrl::TolerantMode);
   const QString dbase = dns.path().replace("/","");
   QStringList drivers = QSqlDatabase::drivers();
   QString const type = "Q"+dns.scheme().toUpper();
    if (!drivers.contains(type)) {
    std::cout << "######### " << qPrintable(tr("Unable to Load Driver %1").arg(type)) << "\n" << std::endl;
    return false;      
    }

QString Scheme = QString( "mysql://username:pass@host:port/database" )
   QUrl dns(Scheme,QUrl::TolerantMode);
   const QString dbase = dns.path().replace("/","");
   QStringList drivers = QSqlDatabase::drivers();
   QString const type = "Q"+dns.scheme().toUpper();
    if (!drivers.contains(type)) {
    std::cout << "######### " << qPrintable(tr("Unable to Load Driver %1").arg(type)) << "\n" << std::endl;
    return false;      
    }

To copy to clipboard, switch view to plain text mode