arturasn / mdb2sqlite Goto Github PK

I just pulled down the project and just tried to build under VS 2013 and it is complaining about not finding "wx/setup.h' in the platform.h when compiling. Right above it gets the compiler.h, but there is no setup.h in the directory directly, but looks like there are ones in each of the platforms. Figure there is simple I am missing.

Thanks

Hi there,

thanks for your contrib, it is really needed. I just used Easysoft odbc trail driver to do conversion. Prior that used Jackcess.

Is there any possibility for Linux distro release or some "how to"? Also, since only using Linux, and can't try Win version atm, is there a command line option?

Cheers

I'm seeing errors for system tables. I wouldn't want to convert these tables.

We should skip main.MSys*

no such table: main.MSysNavPaneGroupCategories 
CREATE TRIGGER MSysNavPaneGroupCategoriesMSysNavPaneGroupsDelete AFTER DELETE ON MSysNavPaneGroupCategories FOR EACH ROW BEGIN DELETE FROM MSysNavPaneGroups WHERE GroupCategoryID = OLD.Id; END; 
no such table: main.MSysNavPaneGroups 
CREATE TRIGGER MSysNavPaneGroupsMSysNavPaneGroupToObjectsDelete AFTER DELETE ON MSysNavPaneGroups FOR EACH ROW BEGIN DELETE FROM MSysNavPaneGroupToObjects WHERE GroupID = OLD.Id; END; 
no such table: main.MSysNavPaneGroupCategories 
CREATE TRIGGER MSysNavPaneGroupCategoriesMSysNavPaneGroupsUpdate AFTER UPDATE OF Id ON MSysNavPaneGroupCategories BEGIN UPDATE MSysNavPaneGroups SET GroupCategoryID = new.Id WHERE GroupCategoryID = OLD.Id; END; 
no such table: main.MSysNavPaneGroups 
CREATE TRIGGER MSysNavPaneGroupsMSysNavPaneGroupToObjectsUpdate AFTER UPDATE OF Id ON MSysNavPaneGroups BEGIN UPDATE MSysNavPaneGroupToObjects SET GroupID = new.Id WHERE GroupID = OLD.Id; END; 

If I create relationship one to one for primary key in ms access then it is not converted to sqlite db.
I have two tables t_device and t_device_data_last.
There are primary keys:
t_device.id
t_device_data_last.deviceId
and it has relationship one-to-one.

detail from ms access:
Relationships
t_devicet_device_data_last
t_device t_device_data_last
id 1 1 deviceId

              Attributes:                Unique; Enforced; Cascade Updates; Cascade Deletes
              RelationshipType:          One-To-One

detail from sqllite (dump.txt)

CREATE TABLE t_device_data_last (deviceId REAL NOT NULL PRIMARY KEY UNIQUE,dateTime TEXT COLLATE NOCASE,temperature REAL,humidity REAL DEFAULT 0,batteryPower REAL DEFAULT 0,dateTimeInt REAL,runCnt INTEGER,restarfromZeroCnt INTEGER,lastRunCnt INTEGER,runningTime INTEGER,pressure REAL DEFAULT 0,co2 INTEGER DEFAULT 0,tvoc INTEGER DEFAULT 0,baseLineReg INTEGER DEFAULT 0,current INTEGER DEFAULT 0 /*current in micro ampere */,voltage INTEGER DEFAULT 0 /*voltage */);

there is missing FOREIGN KEY(deviceId) REFERENCES t_device(id) in dump.txt for CREATE TABLE of t_device_data_last table.

The table t_device_data_last is created before t_device.
How is check which table should be created first? Is it important during conversion?

Could you please provide standalone executable?

Default value for DATETIME columns may be specified as "Now()" in mdb database, but sqlite does not support "Now()". Converter should replace "Now()" to "CURRENT_TIMESTAMP".