DBConvert for Oracle & PostgreSQL VS Flyway

DBConvert for Oracle & PostgreSQL Reviews

1. mark-mercer    

   over 3 years ago
   Good for quick Oracle to Postgres migration

   Used it several times to move my Oracle dbs to Postgres Heroku. All was done quickly and error-free. Saved sessions could be moved by Scheduler.

   🏁 Competitors: DBConvert Studio, ora2pg, ESF Database Migration Toolkit

   👍 Pros:    Easy user interface|Smart scheduling|Fast conversion speed|Connection to remote servers

   👎 Cons:    Doesn't convert functions, triggers and procedures|Initial views can't be converted to target tables

Flyway Reviews

DBConvert for Oracle & PostgreSQL mentions (0)

Flyway mentions (58)

• Let's write a simple microservice in Clojure

  The session logs show that the application loads configurations and establishes a connection with a PostgreSQL database. This involves initializing a HikariCP connection pool and Flyway for database migrations. The logs confirm that the database schema validation and migration checks were successful. The startup of the Jetty HTTP server follows, and the server becomes operational and ready to accept requests on... - Source: dev.to / 8 days ago

• Ask HN: What tool(s) do you use to code review and deploy SQL scripts?

  Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows: https://flywaydb.org/ (Though I don't think it is "complete" or "perfect", either.) EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's... - Source: Hacker News / 19 days ago

• Using Flyway to version your database

  When software starts using a database, it's advisable to have version control, just as we have Github to control our source code. This is all to be sure about what was executed for that specific version. For Java and Spring boot, we have the Flyway framework that aims to resolve this situation, free of charge. - Source: dev.to / 5 months ago

• CI/CD for Databricks

  If you're looking for tools, like https://www.liquibase.com/ or https://flywaydb.org/, which are database-state-based schema migration toolkits - it might be relatively straightforward to build similar ones using Databricks SQL drivers. Source: 10 months ago

• Strategy to run database scripts on Kubernetes

  This is a 4th option, which should play nice with ArgoCD. The following example runs flyway as a k8s job. The desired migration changes are recorded as files within the chart. This helm chart can be integrated with your application (Using hooks to determine when the migration job is run) or run manually. Source: 11 months ago