secretpray/Convert DB in Rails App.md

Last active March 3, 2022 08:53

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/secretpray/5347dc9821d939e6f552b8fd5f9c6cce.js"></script>
Save secretpray/5347dc9821d939e6f552b8fd5f9c6cce to your computer and use it in GitHub Desktop.

Download ZIP

Convert sqlite3 to PostgreSQL (and other DB) in Rails

Raw

Convert DB in Rails App.md

Rails 6+

bin/rails db:system:change --to=postgresql

See list of other database type below:

rails db:system:change --to=mysql, 
rails db:system:change --to=sqlite3, 
rails db:system:change --to=oracle, 
rails db:system:change --to=frontbase, 
rails db:system:change --to=sqlserver, 
rails db:system:change --to=jdbc