Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
5
Erster Beitrag:
vor 3 Jahren
Letzter Beitrag:
vor 3 Jahren
Beteiligte Autoren:
Noel Tanti, issah, Jan de Bruin, Paul Turner

migrate mysql to hfsql

Startbeitrag von Noel Tanti am 07.02.2015 13:56

HI All

I might need to migrate a few mysql database to a HFsql server

If there a quick way of doing it? Any particular software to purchase?

Thanks
noel

Antworten:

hey

wdconver.exe ????

I used it for several occasions

Jan

von Jan de Bruin - am 07.02.2015 16:36
Hi Jan

did not know it existed.
will try it out

Thanks
Noel

von Noel Tanti - am 07.02.2015 18:56
Hi Noel

I'm sure you have good reason to mobe the data to HFSQL, however I must admit I go the other way. There is just no comparison between HFSQL and MySQL. The later is way faster, more flexible, more robust. Triggers work as they should, as do transactions, and the underlying files of the database are way more compact. Of course you do need to do a little more by hand in some cases, but I just wrote a simple SQL class which covers a lot of that.

Anyway good luck with your transfer!

Rgds
Paul

von Paul Turner - am 07.02.2015 21:51
I agree with Paul, especially when you have very complex SQL statements. Just create a view using the SQL and and access that view in WD as a single table. The only downside is you have to make changes to the database manually.....minor issue.

Paul, prepared to share your SQL class? If yes, lets talk: mixgh at yahoo dot com. I have a separate application for backup and restore using mysql dump with WD compression I can share. I install it at all my sites.

issah

von issah - am 09.02.2015 17:15
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.