CODEWITHSUNDEEP
ruby-on-railsrubyruby-on-rails-3devise
Laas
Laas

Reputation: 6068

Migrate legacy database users to Devise

We have an old PHP app in MySQL that we're currently rewriting in Rails and PostgreSQL. I'm looking for a way to migrate users one-by-one when they first sign in to the new system, so that we migrate only active users.

Is there a hook in Devise that I can use to catch a failed login towards the new database and check if the user exists in the old MySQL database and migrate the user if found.

BTW, the Rails app can access both databases and the migration code is already in place that accepts old username as input.

Or should I just simply make a separate _migration_assistant_ page that accepts old logins and initiates the migration?

PS. any user can possibly have thousands of database records to migrate so it can take a bit of time, but we already make use of PosgreSQL's COPY FROM to speed it up (about a few secs per account).

EDIT: There are currently about 5000 users and we expect roughly 1000 of them to return to the new site.

Upvotes: 2

Views: 676

Answers (1)

Groveriffic
Groveriffic

Reputation: 1421

You could migrate the required data from just your users table. Include the original primary key in a column 'old_id'.

Create a custom encryptor so that users can log in with their existing password.

Redirect users when they log in to a page that triggers the migration process per user making use of the saved 'old_id'.

After your migration period you could look at the Devise trackable columns to determine which users can be cleaned up.

Upvotes: 3

Related Questions