Should Oracle built-in routines be emulated in Snowflake and BigQuery?

database-migrationsnowflakebigqueryoracle

The user is considering migrating from Oracle to Snowflake or BigQuery and is wondering whether to emulate Oracle's built-in routines in the new platforms.

Synthesized Answer

Based on 1 community responses

When migrating from Oracle to Snowflake or BigQuery, it's essential to assess whether emulating Oracle's built-in routines is necessary. Both Snowflake and BigQuery offer a wide range of built-in functions and features that can replace many Oracle routines. However, some custom or complex routines might require emulation. Before deciding, evaluate the frequency of use, complexity, and potential performance impact of these routines in your current Oracle setup.

Key Takeaways

Assess the usage and complexity of Oracle built-in routines in your current setup
Explore Snowflake and BigQuery's built-in functions to determine if they can replace Oracle routines
Consider the performance implications of emulating routines in the new platforms

Discussion (1 comments)

Showing 1 comments

avi_vallarapu

19 days ago

This is probably an Interesting if not a Poll leading to interesting conversations.

If you already know, Orafce is an extension that emulates in PostgreSQL, a subset of functions and packages from the Oracle RDBMS.

This extension is very helpful while porting Oracle applications to PostgreSQL, avoiding application code rewrites in a performant way.

Do you think it is worth having a similar emulation of Oracle functions/packages on Snowflake and BigQuery ?

View on Hacker NewsHN ID: 46283009Classification: qa

Privacy Policy

Resources

Briefings

Inbox recaps on the loudest debates & under-the-radar launches.

Connect

Not affiliated with Hacker News or Y Combinator. We simply enrich the public API with analytics.