 | CYQ.DBImport DataBase ToolAccess to Mssql,Mssql to MySql,MySql to Sqlite,Sqlite to oracle,oracle to access |
mysql 导入 sqlite [教你如何将数据从mysql 导向 sqlite]
| mysql to other db |
|
|
| #TopicOwner |
如何将数据从mysql 导入到 sqlite中呢？ navicat是比较好用的一款工具，用它似乎是可以导数据的，不过navicat有一个坏点，就是数据导入通常给你导一半，遇到特殊符号就无能为力，因此，甚为纠结。 不过现在有了：CYQ.DBImport，用它可以更轻松的实现这个功能。 且看如何操作： 1：先下载工具：CYQ.DBImport 2：然后双击运行：CYQ.DBImport.exe 3：在DBConnection From中输入：MySql 数据库的链接，点击“Connect” 4：在DBConnection To 中输入：Sqlite 数据库的链接，点击“Connect” 5：点击“(Un)Check”全选表，然后点击“Import Go”，即可完成数据库转换。 就这样完成了，相当的简单。 mysql 相关的教程： 1：mysql 导入 access [教你如何将数据从mysql 导向 access] 2：mysql 导入 mssql(2000/2005/2008) [教你如何将数据从mysql 导向 mssql(2000/2005/2008)] mssql 相关的教程： 1：mssql 导入 access [教你如何将数据从mssql 导向 access] 2：mssql 导入 mysql [教你如何将数据从mssql 导向 mysql] Access相关的教程： 0：access 导出 表结构 [教你如何获取Access的表结构脚本] 1：access 导入 sql server [教你如何将数据从Access 导向 mssql] 2：access 导入 mysql [教你如何将数据从Access 导向 mysql] 介绍：CYQ.DBImport V2.0 发布[支持多种数据库互导数据/导出数据库脚本及数据库设计文档] 欢迎下载使用。  在线帮助： | |
| wangxiaomei8907132013/10/16 15:06:20 | #3 | |
 | 为什么我点了Import Go后，整个页面消失了，导出的文件没有内容。 | |
| 游客[注册][118.81.172.*]2011/11/16 11:40:50 | #2 | |
 | 我在使用SYQ.dbimport从mysql向sqlite导数据时，出现如下错误： -------DB Insert Start---------- -------------------------- Table: 09101h1 Start...... Read[Pager:0]：5......On Error : Error on DataOperator:Call Function::ExeNonQuery():SQLite error unrecognized token: "09101h1"insert into 09101h1([jiechi],[course]) Values(@jiechi,@course) 恳求解决方法 reply： 应该是你的表名取的太怪了，换个正常的表名试试。 | |
Post Comment
Bulletin
support import data in mutil database
Article Search
Categories
New Article
- Access to generate database design documents [to use CYQ.DBImport Tools]
- access to export table structure [to teach you how to get Access table structure script]
- import access into oracle [teach you how to move data from Access to oracle]
- import access into sqlite [teach you how to move data from Access to sqlite]
- import access into mysql [teach you how to move data from Access to mysql]
- import access into mssql(2000/2005/2008)[teach you how to move data from Access to mssql(2000/2005/2008)]
- CYQ.DBImport V2.0 [Support database reverse engineering/import data/Export of various databases of professional database design document ]
- CYQ.DBImport V1.0 [support database reverse engineering,import data from one database into another database]
New Comment
- I got what you intend,bookmarked, very decent website.
- I am incessantly thought about this, thanks for posting.
- This is a really good site post, im delighted I came across it. Ill be back down the track to check out other posts that
- Im obliged for the article post.Much thanks again. Fantastic.
- There is perceptibly a bundle to know about this. I suppose you made some nice points in features also.
- this I have discovered It absolutely useful and it has aided me out loads.
- Muchos Gracias for your article.Thanks Again. Awesome.
- va loans with bad credit How can I copyright all original content current and future on my website?
- Wow, fantastic blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, as well as the content!
- Very good post. I am going through some of these issues as well..