Ruby/Rails-反向迁移-从DDL到Ruby代码 [英] Ruby / Rails - Reverse Migration - DDL to Ruby Code

问题描述

使用Ruby或Rails中的任何工具，可以让我从数据库中提取所有表架构并生成与Ruby等价的"DLL"语句吗?

Any tools in Ruby or Rails that would allow me to extract from database all the table schema and generate Ruby equivalent "DLL" statements?

可以将架构从Microsoft SQL Server移植到Postgres，或将MySQL移植到Sqlite的东西.

Something that would allow me to port schema from say Microsoft SQL Server to Postgres, or MySQL to Sqlite.

推荐答案

在Rails/ActiveRecord中，可以使用rake db:schema:dump生成db/schema.rb，并使用rake db:schema:load将其加载到数据库中.

In Rails/ActiveRecord, you can use rake db:schema:dump to generate db/schema.rb, and rake db:schema:load to load it into a database.

这篇关于Ruby/Rails-反向迁移-从DDL到Ruby代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！