MySQL --> SQLite
Posted: 20.03.2010, 10:28
Hi!
I'm trying to extend my program to off-line functionalities. Since mysql embedded is commercial ( ) I opted for SQLite. But there's a problem - I want the SQLite DB to be created dynamically (in case the main server DB gets updated I will not have to worry about changes). As I can see the create syntax is not usable from MySQL in SQLite. Did someone had a similar issue? Can the Zeos metadata component be used in this case?
I'm trying to extend my program to off-line functionalities. Since mysql embedded is commercial ( ) I opted for SQLite. But there's a problem - I want the SQLite DB to be created dynamically (in case the main server DB gets updated I will not have to worry about changes). As I can see the create syntax is not usable from MySQL in SQLite. Did someone had a similar issue? Can the Zeos metadata component be used in this case?