Transform PostgreSQL to Access SQL

[jaryszek]

Hi,

looking for a tool which help to transfrom PostgresSQL to AccessSQL.
I want to just use powerful access quuery designer from postgres.

Thanks for any tips,
Best,
Jacek

 

[jaryszek]

Pat,

thank you. I saw few converters online but hmm they were not efficient unfortunately. There are also paid tools which can transfor access sql to postgresql but i do not know which to choose and what to use. This is why i wrote the question - maybe somebody has more experience?

Best,
Jacek

 

[Galaxiom]

I want to just use powerful access quuery designer from postgres.

"Powerful" and "Access" don't belong in the same sentence, especially not the query designer. The Access query designer doesn't even support half of what can be done in Access SQL.

Definitely would recommend you do not pursue this path. Access SQL is considerably different from Standard SQL and quite clumsy. The forced nesting join syntax is hideous. What the query designed does to the SQL typed in is abominable. Besides, Access SQL does not support many of the constructs and keywords used in database servers.

You could try looking for a graphical query designer for Postgres but really you need to learn to write SQL. Don't be put off by what you have seen of Access SQL. Standard SQL or T-SQL are easier to write than Access SQL.

 

[jaryszek]

thanks

 

[jaryszek]

BTW. No other database has drag and drop editor like Access which fasten writing sqls so so much for me.

 

[jaryszek]

Thank you for your voice Pat.

I think we're about to see updates to QBE and they may be out in some channels already.

It would be nice to see update but who knows how microoft will support it