CYQ.DBImport DataBase ToolAccess to Mssql,Mssql to MySql,MySql to Sqlite,Sqlite to oracle,oracle to access |
mssql 导入 sqlite [教你如何将数据从mssql 导向 sqlite]
mssql to other db |
|
|
| #TopicOwner |
做为一名开发人员,经常用mssql打交道,因为在本机做项目通常都用mssql,由于做的网站可能只有虚拟主机,而虚拟主机上啥数据库也没有,或者自带的数据库最大只能200M,那就纠结了,200M的数据能干什么呢?文章还上不了1万,于是可能会考虑access或sqlite,当然了,操作sqlite还是mssql还是access,用CYQ.Data 数据框架都是一样的,一次开发,多种数据库应用。 不过话不多说,关键还是怎么导数据和生成sqlite的表结构。 其实很简单,用:CYQ.DBImport ,填两个数据库链接就完事了。 步骤如下: 1:先下载工具:CYQ.DBImport 2:然后双击运行:CYQ.DBImport.exe 3:在DBConnection From中输入:mssql(2000/2005/2008)数据库的链接,点击“Connect” 4:在DBConnection To 中输入:sqlite 数据库的链接,点击“Connect” 5:点击“(Un)Check”全选表,然后点击“Import Go”,即可完成数据库转换。 就这样完成了。 mssql 相关的教程: Access相关的教程: |
Post Comment
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..