jet-tool icon indicating copy to clipboard operation
jet-tool copied to clipboard

Published 20 hours ago • verified publisher icon himselfv

dump ANSI SQL

Open himselfv opened this issue 9 years ago • 3 comments

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 avatar Jan 22 '16 00:01 himselfv

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 avatar Mar 02 '16 13:03 himselfv

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 avatar Mar 02 '16 15:03 himselfv

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].

himselfv avatar Oct 29 '18 03:10 himselfv