Other Databases

[uyuni]

Do you plan to include connection to other databases (directly, not ODBC)?

I have looked around in the internet but not found suitable software which can connect and synchronize between MySQL/Access/SQL-Server. The only one I've found is http://dbconvert.com/convert-mssql-to-mysql-sync.php but support is not really good.

I think real sync to other databases (not only import and not only ODBC) is needed by quite some projects.

Emilio

[peterlaursen]

We have no such plans!

SQLyog is 'coded around' the MySQL C-client-API.  There is nothing like it for other databases really.  The MySQL SHOW statement (used extensively by SQLyog) has also no parallel elsewhere.

Your question has been asked before.  I think I use to reply that probably only around 30% of the existing code would go into a version for another databases, but only that much!  Some GUI code could be re-used but only that.  

I do not say that you will never see a Webyog product for other databases, but there are no plans fore a 'SQLyog for PostgreSQL' or 'SQLyog for SQL Server' or whatever – and no 'SQLyog for everything' either!

Basically there are two issues.

1) MySQL is probably the SQL database that differs most from the SQL standard!

2) the SQL standard is pretty weak/ little detailed on how to query 'metadata'-  And a GUI tool need to query metadata all the time.

… and as a result SQL databases are very differnt, except that they use (almost) the same language structure to query data!

[DonQuichote]

uyuni wrote on May 6 2007, 02:06 PM:

… I have looked around in the internet but not found suitable software which can connect and synchronize between MySQL/Access/SQL-Server.

I think real sync to other databases (not only import and not only ODBC) is needed by quite some projects.

MS-Access can connect to both SQL server and MySQL. In fact, MS-Access can be used as a form engine or as a complete programming environment. If you desperately want to avoid ODBC (I would not know how you would connect to SQL server then), it would not surprise me if you could use the C library through API calls from Access VBA. Personally, I would prefer using ODBC to reinventing a wheel.

“Sync to other databases” can be quite a task. If you want to do that with Access, it is best to do so with pass-through queries and remember time of the last sync (both remote and local!). Off course, you would need timestamps on all the records that need to be synched (or some other means of knowing which records did change). And off course, you'd need to think about what you want in detail: If a record is changed in both MySQL and Access after the last known sync action, do you want a warning, a method to correct and compare things by hand, or should the latest change win?

[Author]

Posts