search

himselfv / jet-tool

MS Jet database schema export/SQL execution tool
21 stars 3 forks source link

jet-tool v0.6a cannot execute the SQL file which it dumps #9

Closed himselfv closed 5 years ago

himselfv commented 6 years ago

Original report by Anonymous.

jet-tool v0.6a cannot execute the SQL file which it dumps

dump the sql file first

jet dump --all --accdb -f testing.accdb > testing.sql

create a new empty database

jet touch -new -force -f testing2.accdb

execute the SQL file on the empty database

jet exec -f testing2.accdb < testing.sql # this line will fail

due to

1. jet-tool does not support the following string as a valid field: 'HK Int\'l Airport'

2. jet-tool cannot dump a valid datetime field:

it dumps like this: #12-12-2017 13:27:59 13:27:59

himselfv commented 6 years ago

Original comment by chris4540 (Bitbucket: 5a3cec5cebc8647f9a1c383d, GitHub: chris4540).

Sorry, I am a newbie of bitbucket. I forgot to login and this ticket is created by me.

himselfv commented 6 years ago

Original comment by himselfv (Bitbucket: 557058:736ea475-fec1-499e-93e9-568104650027, GitHub: himselfv).

Thank you for such thorough report! Both bugs confirmed and I hope fixed in 0.6b. If it doesn't work for you, please tell.

himselfv commented 5 years ago

Closed