how to get database from development to production?

Question

What is the best way to dump my development database structure and deploy it to a production server?

Im using capistrano deployment for rails app

how would one migrate changes in development database structure automatic with each cap deploy?

I use migrations but removed them at some points and did a scheme dump — Ilse
– Ilse, Commented Mar 17, 2012 at 17:43

Jesse Wolgamott · Accepted Answer · 2012-03-17 17:47:52Z

1

You can add a migration that executes your schema dump. Then use migrations to make changes after that.

Then, you'll execute cap deploy:migrations to deploy your code and run your migrations.

answered Mar 17, 2012 at 17:47

Jesse Wolgamott

40.3k4 gold badges86 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ilse Over a year ago

how would i add a migration that executres a schema dump? I understand the principe but no idea how to write that thx!

Ilse Over a year ago

Ok I pasted schema.rb from local machine to schema.rb on production and that seemed to work. The production schema.rb was empty I suspected it to be copied from my local git repo to prod.

Jesse Wolgamott Over a year ago

Check out rake schema:dump to get it into a file

Collectives™ on Stack Overflow

how to get database from development to production?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related