如何将访问mdb db转换为sqlite db [英] how to convert access mdb db to sqlite db

问题描述

大家好，



我在vb.net中创建了一个应用程序，我使用的是mdb数据库。

它的工作原理很好，该应用程序没有任何问题。



我想将该数据库中的所有mdb表或数据转换为Sqlite。

In我的数据库有三十万以上的记录需要一些时间才能在数据库中加载数据。

用于快速搜索我希望将Mdb转换为sqlite的数据。





是否可以给我回复..

先谢谢。

解决方案

< blockquote>有些产品声称可以为您进行此转换，但您可以通过将Access表格导出为CSV格式然后使用 SQLite shell [ ^ ]将它们导入SQLite上的表格。



我建议首先在SQLite上创建表，以确保将日期解释为日期，将int作为整数解释，而不是依赖导入来确定数据类型是什么。



在导入之前不要向表中添加任何索引。



使用Access或SQLite选择适当的索引进行搜索数据库更快。



导出然后加载需要一些时间，但只需要完成一次。



刚到SQLite网站检查一下，还发现这个链接到他们的转换器 [ ^ ]。它声称也从Access读取。

Hi all of you,

I have created one application in vb.net and i am used mdb database.
It works fine there is no any problem in that application.

I want to convert all mdb table or data in that database to Sqlite.
In my database there are 3 lakh above record it take some time to load data in database.
for fast searching the data i want to convert the Mdb to sqlite.


Is it possible then give me reply..
Thanks in Advance.

解决方案

There are products out there that claim to do this conversion for you, but you can do it for free by exporting the Access tables to CSV format and then using the SQLite shell[^] to import them into tables on SQLite.

I would suggest creating the tables on SQLite first to ensure that dates are interpreted as dates, ints as ints etc rather than relying on the import to determine what the data types are.

Don't add any indexes to the tables until after you have imported them.

With either Access or SQLite choose appropriate indexes to search the database(s) faster.

It will take some time to export then load but it only needs to be done once.

Just went to the SQLite site to check on something and also found this link to their converter[^]. It claims to read from Access also.

这篇关于如何将访问mdb db转换为sqlite db的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！