机器人:MySQL来SQLite的转换 [英] android:MySQL to SQLite conversion
问题描述
我知道这个问题已经张贴在这里几次,但它仍然不是很清楚。是否有mysql数据库转换为sqlite3的数据库,一个免费的工具?
I know this question has been posted several times here but still its not very clear. Is there a free tool to convert mysql database to sqlite3 database?
如果我出口MySQL数据库为XML格式,它是可以读取它,并在创建活动的Android code SQLite数据库?如果这是可能的,我只是将XML添加到我的资产文件夹,并分析它的活动开始。
If I export the mysql db to xml format, is it possible to read it and create sqlite database in android activity code? If this is possible, I will just add the xml to my assets folder and parse it on activity start.
也是我的Android应用程序将需要从具有MySQL数据库服务器定期更新数据库。我应该如何升级在应用程序运行时的数据库?应以XML或JSON服务器返回数据库?
Also my android application would need to update the database regularly from the server which has mysql database. How should i update the database at application run time? Should the server return database in xml or json?
问候,
萨班
推荐答案
我终于用在这个环节中提到的脚本,它完美地为我工作
I have finally used the script mentioned in this link and it worked perfectly for me
http://www.jbip.net/content/how-convert-的mysql-sqlite的
这篇关于机器人:MySQL来SQLite的转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!