Lazarus

Programming => Databases => Topic started by: Weitentaaal on January 19, 2021, 09:17:36 am

Title: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: Weitentaaal on January 19, 2021, 09:17:36 am

Thanks :D

Title: Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: JD on January 19, 2021, 10:36:11 am

Internet search

https://www.rebasedata.com/convert-access-to-sqlite-online

JD  :D

Title: Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: Weitentaaal on January 19, 2021, 02:43:14 pm

Yes but i can only convert 10 mb of the db :/

Title: Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: wp on January 19, 2021, 03:12:20 pm

Does the mdb contain macros? If yes, you're out of luck. If not, you can read the tables into ODBC. You'll have to recreate the queries by yourself.

Title: Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: Zvoni on January 19, 2021, 04:15:01 pm

DBeaver?

Title: Re: Does Any1 know a Tool to Convert Access db to sqlite db ? or has writen one by ?
Post by: JD on January 26, 2021, 01:09:19 pm

Quote from: Zvoni on January 19, 2021, 04:15:01 pm

DBeaver?

Exactly  :D :D