I'd agree with all of those too :) SQLLines has a free tool that I find myse...

[Comment from a deleted post]

Replies for: Some of the things in no particular order: Cross db joins Downtime-less schema changes Locking levels and transactions Cascade delete SQL flavors

I'd agree with all of those too :)

SQLLines has a free tool that I find myself coming back to when I need to translate between flavours - sqlines.com/online

Geshan Manandhar • Feb 16 '20

Sqlines is a good one.

Waylon Walker • Feb 16 '20 • Edited

Sounds like a cool tool, doesnt seem to work with my simple example. I will definitely keep it bookmarked to try when I have a real example.

postgresql

select * from table limit 10

Should convert to

Oracle

select * from table fetch first 10 rows only

Helen Anderson • Feb 16 '20

I used it when migrating from SQL Server to Postgres and found it handy in that particular use-case.

Dates were a a real drag:

SQL Server

SELECT DATEADD(day, 1, GETDATE())

Postgres

SELECT INTERVAL '1 day' + NOW()

The AWS Schema Conversion Tool is a slicker, although paid, version of the same if you are using their services.

geraldew • Feb 18 '20

In retrospect I could have just said "date handling" and walked away from the subsequent vortex of possible discussion. At my workplace I keep a wiki page with stock clippings of date literals, date constants and date expressions for the different dialects I use. I barely read/notice them now, I just trust my decades younger self to have ensured each was right and copy-paste them into place. Younger me never worked out INTERVAL syntax, so none of them have that.