Recent

Author Topic: Database convert tool  (Read 613 times)

Weitentaaal

  • Hero Member
  • *****
  • Posts: 503
  • Weitental is a very beautiful garbage depot.
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.12 x86_64-win64-win32/win64
Compiler Version: 3.2.2

lucamar

  • Hero Member
  • *****
  • Posts: 4219
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

  • Hero Member
  • *****
  • Posts: 503
  • Weitental is a very beautiful garbage depot.
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.12 x86_64-win64-win32/win64
Compiler Version: 3.2.2

 

TinyPortal © 2005-2018