search

himselfv / jet-tool

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

dump ANSI SQL #3

Open himselfv opened 8 years ago

himselfv commented 8 years ago

Original report by Laurent ROCHE (Bitbucket: 557058:1fa9a87a-5dfe-473e-89d6-d1ee82da4081, GitHub: ComputingFroggy).

Hi,

I would be nice to get the SQL dump in an ANSI SQL syntax to be able to use that file directly to another RDBMs !

Cheers, L@u

himselfv commented 8 years ago

Hi! Do you have a specific case in mind? I don't have time to study where Access SQL differs from ANSI precisely, but I might do it on a case by case basis.

himselfv commented 8 years ago

Original comment by Laurent ROCHE (Bitbucket: 557058:1fa9a87a-5dfe-473e-89d6-d1ee82da4081, GitHub: ComputingFroggy).

Well, It's been more than a month since I posted ... I don't remember. I will try and run the tool again, to give some examples.

himselfv commented 6 years ago

Original comment by Andrew Visser (Bitbucket: 557058:61583957-4151-4f34-a7fe-83f071c55f65, GitHub: visser).

I just had to do this. I'm moving an app off of Access onto Postgres.

I had to remove the surrounding square brackets [from everything].