Rails Migrations: How to split one table into two tables?

Question

I have a database with the following schema:

[ Region ] 1 --- * [ District ] 1 --- * [ Location ]

I would like to split the middle table into two tables as follows:

[ Region ] 1 --- * [ District ] 1 --- * [ Area ] 1 --- * [ Location ]

...leaving some fields (and their values) in the original District table while transferring other columns (and their values) into the newly-created Area table.

Is there a standard/clean way to do this in a rails migration (preferably without the use of raw SQL)?

score 3 · Accepted Answer · edited Jun 20 '20 at 09:12

3

Well you could do this in 2 steps:

First step

Write a migration that creates the Area table and its columns. In this migration write some Ruby code to populate the table with data from District.

Second step

Write a migration that changes the District table, for example one that drops unwanted columns from District.

At this point running the migrations should get you what you want without having to use SQL.

Hope it helps ! : )

edited Jun 20 '20 at 09:12

Community

1
1

answered May 16 '13 at 23:35

Raindal

3,227
15
14

Accepting as correct answer. Ended up breaking it down into multiple steps. – user456584 May 24 '13 at 20:25

Rails Migrations: How to split one table into two tables?

1 Answers1

First step

Second step