Recent

Author Topic: Database convert tool  (Read 330 times)

Weitentaaal

  • Full Member
  • ***
  • Posts: 158
Database convert tool
« on: October 29, 2020, 02:43:07 pm »
Hey Guys,

is there any Tool to convert access Databases to SQLite DB's, or do i have to write one ?
and if i have to write one, how do i read a .mdb file ?

Thanks
ModdyMC Studio
Lazarus: 2.0.6 x86_64-win64-win32/win64
FPC-Version: 3.0.4
Compiler Version: 3.2.0

lucamar

  • Hero Member
  • *****
  • Posts: 3771
Re: Database convert tool
« Reply #1 on: October 29, 2020, 02:48:58 pm »
Google "convert access to sqlite" and you'll find quite a lot of tools for that.

As for reading Access database (.mdb, etc) it can be done with the standard Lazarus DB components. Only, IIRC, it has to be done with an ODBC connector, since there are no direct components as for SQLite, Firebird, MySQL, etc.
Turbo Pascal 3 CP/M - Amstrad PCW 8256 (512 KB !!!) :P
Lazarus/FPC 2.0.8/3.0.4 & 2.0.12/3.2.0 - 32/64 bits on:
(K|L|X)Ubuntu 12..18, Windows XP, 7, 10 and various DOSes.

Weitentaaal

  • Full Member
  • ***
  • Posts: 158
Re: Database convert tool
« Reply #2 on: October 29, 2020, 04:01:49 pm »
Yes but every tool just converts 50% of the db :/

But Thanks for ur Help
Lazarus: 2.0.6 x86_64-win64-win32/win64
FPC-Version: 3.0.4
Compiler Version: 3.2.0

 

TinyPortal © 2005-2018