> This page location: /docs.md > /docs/tools-and-connectors.md > /docs/relational-migrator.md

> For the complete MongoDB documentation index, see www.mongodb.com/docs/llms.txt

# Data Migration with Snapshot Jobs

Migration jobs transfer data from your relational database to MongoDB. Migration jobs use project-level [Data Modeling](https://www.mongodb.com/docs/relational-migrator/mapping-rules/introduction.md#std-label-rm-mapping-rules) to distribute data to your MongoDB database.

## Types of Migration Jobs

Relational Migrator offers snapshot migration jobs that run once for a point-in-time migration strategy. Snapshot migration jobs are the only type of migration job. Relational Migrator doesn't offer a continuous sync or change data capture (CDC) migration job.

To run snapshot migration jobs on a cadence, use the [REST API](https://www.mongodb.com/docs/relational-migrator/api-docs.md#std-label-rm-rest-api) with a task scheduler. Each run is a separate snapshot migration job and doesn't provide continuous sync.

## Compatibility

Some databases might have specific requirements, and Relational Migrator generates a script to modify source databases as necessary. See the following pages to learn more about configuration prerequisites for each type of relational database:

- [Configure MySQL](https://www.mongodb.com/docs/relational-migrator/jobs/prerequisites/my-sql.md#std-label-rm-prereq-mysql)

- [Configure Oracle](https://www.mongodb.com/docs/relational-migrator/jobs/prerequisites/oracle.md#std-label-rm-prereq-oracle)

- [Configure PostgreSQL](https://www.mongodb.com/docs/relational-migrator/jobs/prerequisites/postgres.md#std-label-rm-prereq-postgres)

- [Configure SQL Server](https://www.mongodb.com/docs/relational-migrator/jobs/prerequisites/sql-server.md#std-label-rm-prereq-sqlserver)

- [Configure DB2](https://www.mongodb.com/docs/relational-migrator/jobs/prerequisites/db2.md#std-label-rm-prereq-db2)

## Behavior

Migration jobs are non-idempotent by default. Relational Migrator inserts new documents and embedded arrays each time a job is run, with the option to delete each existing collection at the start of the sync dialogue. You can enable idempotency to delete inserts from the previous migration job automatically.

To enable idempotent inserts for documents and embedded arrays, set `migrator.engine.transform.idempotency: true` in the `user.properties` file. Enabling idempotency may have substantial performance impact on large jobs.

### Selective Migration

You can migrate a subset of tables from your project by selecting specific tables when creating a migration job. This allows you to test migrations on smaller datasets or migrate data in logical batches. For more information, see [Create a Migration Job.](https://www.mongodb.com/docs/relational-migrator/jobs/creating-jobs.md#std-label-rm-create-jobs)

### Indexes

Relational Migrator creates new [indexes](https://www.mongodb.com/docs/manual/indexes/) in your MongoDB collections to supplement the migration process. For best performance, review the indexes in your collection after migration to ensure that they best fit your application usage patterns.

Relational Migrator does not create new indexes in the relational database. Relational Migrator has read-only access to your source database.

See the following pages for more information on revewing your collection indexes:

- [Create an Index](https://www.mongodb.com/docs/manual/core/indexes/create-index/)

- [Drop an Index](https://www.mongodb.com/docs/manual/core/indexes/drop-index/)

- [db.collection.getIndexes](https://www.mongodb.com/docs/manual/reference/method/db.collection.getIndexes/)

## Get Started

You can perform the following tasks from the **Data Migration** tab.

| Task | Description |
| --- | --- |
| [Create a Migration Job](https://www.mongodb.com/docs/relational-migrator/jobs/creating-jobs.md#std-label-rm-create-jobs) | Create a migration job which uses the defined mapping rules and migration options. |
| [Preflight Checks for Migration Jobs](https://www.mongodb.com/docs/relational-migrator/jobs/preflight-checks.md#std-label-rm-preflight-checks) | Review the source database checks that Relational Migrator runs when you create a migration job. |
| [Monitor a Migration Job](https://www.mongodb.com/docs/relational-migrator/jobs/monitoring-jobs.md#std-label-rm-monitor-jobs) | View metadata, execution status, and issues for a migration job. |
| [Stop a Migration Job](https://www.mongodb.com/docs/relational-migrator/jobs/stopping-jobs.md#std-label-rm-stop-jobs) | Cancels the execution of a migration job. |
