DEV Community

Robert Rees
Robert Rees

Posted on

1

Migrating databases from Heroku to Render

One of the more interesting aspects of Heroku ending its free service is that there is no simple way to enter your credit card and simple switch your data over to a paid plan. You have to migrate from the free to the paid servers.

On that basis it makes sense to look at what the alternatives are before deciding to make a decision.

Render has had a lot of positive comments for picking up the mantle of Heroku's promise of developer friendly PaaS and making good the deficits. It's Postgres service does allow you to move between the trial and paid for database service for example just by entering payment details.

It also allows you to host multiple databases in the same instance which is what I want for a lot of my hobby apps as they don't really have a lot of data.

The service exposes a standard database URL and so far I have been able to use standard Postgres tools for everything I've wanted to do with the database. You can even just cut and paste a string to connect with pgcli.

The documentation for migrating from Render to Heroku is excellent and worked just as advertised.

Having imported the databases I then detached the Heroku instances and replaced the DATABASE_URL environment variable with the new URL from Render, restarted my dynos and every application I had worked perfectly.

The only issue I had was in my local setup where I needed to use the pg_restore from a matching version which I needed to specify the exact /usr/lib/postgresql/<version>/bin path.

Overall a great migration experience and I can't really fault it. I wish I had made the change sooner.

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (1)

Collapse
 
anurag profile image
Anurag Goel

Welcome to Render!

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay