How to Switch from one database to another in Rails - MySQL to PostgreSQL Migration
In this quick tip we walk through how to migrate from one database adapter to another, in this specific case we migrate from MySQL to PostgreSQL. This technique can be very useful in the context of a one time migration to a new database. Perhaps you need to take advantage of a new feature, or maybe you just inherited a project and prefer a different database. Whatever the case may be, use this quick tip to help you make the transition to the db you want.
Previous Quick Tips Referenced
Rails: Syncing Database Between Environments
• How to Sync Production Data in Rails ...
SSH Config file tutorial
• How to Create and Use an SSH Config F...
Gems Referenced
capistrano-db-tasks: https://github.com/sgruhier/capistran...
yaml_db: https://github.com/yamldb/yaml_db
My Gear List
http://brain-trust.io/my-gear
My YouTube SEO Software
https://www.tubebuddy.com/braintrust
My Accounting Software
https://shareasale.com/r.cfm?b=960179...
Make sure you subscribe to my channel to keep up to date with new content!
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting BrainTrust Digital so I can continue to provide you with free content each week!