Home » Forums » DBManager General
 
MySQL to SQLite (1407 previews)
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


- /
MySQL to SQLite (1407 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General