---
title: "Bulk Migration"
slug: "bulk-migrate"
tags: ["Bulk Migrate", "User Information", "CSV Upload"]
updated: 2025-03-10T20:15:20Z
published: 2025-03-10T20:15:20Z
canonical: "mfa.rapididentity.com/bulk-migrate"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://mfa.rapididentity.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Migrate

> Bulk Migrate is our solution to not having a built-in way to update user information en masse through the web portal. To do this, we generate a SQL report that can be copied to a CSV file where we can make the necessary changes, then upload the CSV file to the server. These changes are instant and only update the values changed.

          Bulk Migrate is only possible for pre-existing MFA accounts and cannot create new accounts.

          

## Part 1 - Getting User Report From SQL

1. In your SQL database manager, run the following query:

```
-- Queries the following data with their respective titles:
-- UserName, Domain, Email, Language, AuthSet, Role, UserState

USE [ONE]
SELECT 
Users.name AS 'UserName', 
Users.domain AS 'Domain', 
Users.email AS 'Email', 
Languages.name AS 'Language', 
Auth_Sets.name AS 'AuthSet', 
Roles.name AS 'Role', 
States.name AS 'UserState'

FROM (Users
INNER JOIN User_Roles ON Users.user_id = User_Roles.user_id
INNER JOIN Roles ON User_Roles.role_id = Roles.role_id
INNER JOIN Auth_Sets ON Users.auth_set_id = Auth_Sets.auth_set_id
INNER JOIN States ON Users.state_id = States.state_id
INNER JOIN Languages ON Users.language_id = Languages.language_id )

-- Excludes the 'ONE_sys_admin' and  and 'Password Only' accounts 
-- to avoid accidental modifications to those accounts/account types
WHERE Auth_Sets.name != 'RapidIdentity Password Only'
ORDER By Users.name ASC
```

**You can add additional WHERE clauses to refine your results, if necessary.*

1. In the results page from the query, copy the results. **The column headers are optional.** ![bulkMigrate_results.png](https://cdn.document360.io/cf888ab6-47bb-4aaa-984b-26a47cdccf46/Images/Documentation/bulkMigrate_results.png)

⬇️⬇️⬇️

![bulkMigrate_results_copyWith...png](https://cdn.document360.io/cf888ab6-47bb-4aaa-984b-26a47cdccf46/Images/Documentation/bulkMigrate_results_copyWith...png)
2. Paste the results to your CSV editor of choice (this example utilizes Google Sheets). ![bulkMigrate_results_excel.png](https://cdn.document360.io/cf888ab6-47bb-4aaa-984b-26a47cdccf46/Images/Documentation/bulkMigrate_results_excel.png)
3. Modify your users' information as necessary. Be sure to leave the headers alone.

          Example

          

If you are setting some of or all of your users to *New Credential* so that they can use the Enrollment Tile, you would change all instances of *Steady State*.
4. Once your changes are complete, save your file as a .CSV.

---

## Part 2 - Uploading The .CSV

1. In your Admin Portal, go the the *Users* tab.
2. On the left-hand side, click *New Users*.
3. In the new dropped down menu, select *Bulk Migrate*.
4. In the main Bulk Migrate screen, click *Choose File* to open your file explorer and select your new .CSV file.
5. If you kept the headers like this example, be sure to check (✓) the "Ignore First Line" option.
6. Finally, click *Bulk Migrate* to upload your .CSV.  

![bulkMigrate_step2.png](https://cdn.document360.io/cf888ab6-47bb-4aaa-984b-26a47cdccf46/Images/Documentation/bulkMigrate_step2.png)