|
MySQL to SQLite |
Posted in 13th, 02/2006 04:45 by MarcoNickolai |
Hallo,
can someone please explain in a few steps how to convert a MySQL Data Base into a SQLite database with DBManager.
thanks in advance
Marco - / |
Re: MySQL to SQLite |
Posted in 15th, 02/2006 09:52 by support |
Hi,
This is actually very simple. For this task you will need the Enterprise Edition with support for MySQL and SQLite engines.
1) Using Server Manager add both servers. Although SQLite is not a server DBManager uses this to attach databases on disk
2) You can copy the structure and data by dragging the tables out of mysql into sqlite. For this you will need to select the objects view; or
3) Use the Data Migration Wizard and fill its information
That's it.
Best Regards,
Support / DBTools Software |
Re: MySQL to SQLite |
Posted in 15th, 02/2006 02:07 by MarcoNickolai |
Hi,
i test the connection to LQLite DB and get a error "Error loading DBSQLITE3.DLL for SQLite" but DBSQLITE3.DLL is available! Why?
Best Regards,
Marco - / |
Re: MySQL to SQLite |
Posted in 15th, 02/2006 03:19 by support |
Hi Marco,
Which DBManager edition and version are you using?
There is one Freeware edition that does not ship the SQLite DLL with the setup. In this case you just need to download the latest DLL from www.sqlite.org and it will work fine.
Best Regards,
Support / DBTools Software |
Re: MySQL to SQLite |
Posted in 15th, 02/2006 06:57 by MarcoNickolai |
Hi,
that's it. Now work the programm fine. Next time buy our company your programm.
Thank you,
Marco
- / |
Legends
Topic has Replies
Topic With no Replies
|
|
|