Meld Homepage , Electronic PCB PCBA , Software .NET AVR PLM BOM , Network TCP UDP MQTT , Microcontrollers AVR ARM , Powersupplys Switchmode , Nursecall MC5000 CD2000

Date: 2021-02-09
Updated: 2021-02-09
Author: Erik Leth Danielsen
Convert Access database to SQLite database Framework 2.0

Convert Access database to SQLite database Framework 2.0

Problem:
Many companies uses a Access database it's a single file database from Microsoft
Microsoft Access was the goto database, you got with the Microsoft office pack.
But when many companies are moving to Linux They need a open source database there can do the same
The Most Widely Deployed and Used Database Engine is SQLite it's the database there are everywhere 
in all mobile devices.
Example my homepage was running ASP with a Access DB now it runs nodejs with SQLite DB.
So I needed a tool to convert my old access DB to a SQLite DB.

Test Software



Solution written in .Net:
First I needed a dll for SQLite, Found this example:
see YouTube How to use and connect Sqlite in a C# 
code main project adodotnetsqlite.sourceforge.net 

This is the newest Version sqlite-netFx20-binary-bundle-Win32-2005-1.0.113.0 sqlite.org 
This Version also works SQLite-1.0.58.0-binaries from sourceforge.net  
This Version doesn't work SQLite.NET.0.21_x68_dll with SQLite Ver.3
Download complete code:
I have made a Converting tool
it also contains sqlite-netFx20-binary-bundle-Win32-2005-1.0.113.0\System.Data.SQLite.dll
Complete Code VB.Net
To Run it \SqliteTest\bin\Release\SqliteTest.exe
Press the ConvDB Button select the access DB file, it will output a SQLite DB file in the same folder.

The program also contains 
1. SQLite DB Test

2. ADODB interface for SQLite is used in my software 
so I just can import ClsADODBsq.cs and replace the ADODB in a old project.

3. ADO Access vs SQLite Benchmark (access=63mS vs sqlite=16mS)

To view code open \SqliteTest.sln in .net

Links:
sqlite.org
Admin Tool sqlitebrowser.org
YouTube SQLite: The Database at the Edge of the Network with Dr. Richard Hipp
YouTube SQLite with D. Richard Hipp
ADO Data Types
DB-Engines Ranking

Privacy Policy © MELDCO APS | skovsgaardsparken 6 | 8362 hoerning | E-mail: info@meldco.dk | VAT ID: 34576149 256635