---
url: https://dml.beyondthecloud.dev/dml/merge.md
---

# Merge

Merge duplicate records into a master record.

**Example**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Account duplicate1 = [SELECT Id FROM Account WHERE ...];
Account duplicate2 = [SELECT Id FROM Account WHERE ...];

new DML()
    .toMerge(masterAccount, new List<Account>{ duplicate1, duplicate2 })
    .systemMode()
    .withoutSharing()
    .commitWork();
```

## toMerge

Register records for merging. The actual DML is executed when `commitWork()` is called.

**Signature**

```apex
Committable toMerge(SObject mergeToRecord, SObject duplicatedRecord);
Committable toMerge(SObject mergeToRecord, List<SObject> duplicateRecords);
Committable toMerge(SObject mergeToRecord, Id duplicatedRecordId);
Committable toMerge(SObject mergeToRecord, Iterable<Id> duplicatedRecordIds);
```

### Single Duplicate Record

**Signature**

```apex
Committable toMerge(SObject mergeToRecord, SObject duplicatedRecord);
```

**Standard DML**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Account duplicateAccount = [SELECT Id FROM Account WHERE ...];

Database.merge(masterAccount, duplicateAccount);
```

**DML Lib**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Account duplicateAccount = [SELECT Id FROM Account WHERE ...];

new DML()
    .toMerge(masterAccount, duplicateAccount)
    .commitWork();
```

#### By Record ID

Merge using a duplicate record ID directly.

**Signature**

```apex
Committable toMerge(SObject mergeToRecord, Id duplicatedRecordId);
```

**Standard DML**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Id duplicateAccountId = '001xx000003DGbYAAW';

Database.merge(masterAccount, duplicateAccountId);
```

**DML Lib**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Id duplicateAccountId = '001xx000003DGbYAAW';

new DML()
    .toMerge(masterAccount, duplicateAccountId)
    .commitWork();
```

### Multiple Duplicate Records

**Signature**

```apex
Committable toMerge(SObject mergeToRecord, List<SObject> duplicateRecords);
Committable toMerge(SObject mergeToRecord, Iterable<Id> duplicatedRecordIds);
```

**Standard DML**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
List<Account> duplicateAccounts = [SELECT Id FROM Account WHERE ...];

Database.merge(masterAccount, duplicateAccounts);
```

**DML Lib**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
List<Account> duplicateAccounts = [SELECT Id FROM Account WHERE ...];

new DML()
    .toMerge(masterAccount, duplicateAccounts)
    .commitWork();
```

#### By Record IDs

Merge using a collection of duplicate record IDs.

**Signature**

```apex
Committable toMerge(SObject mergeToRecord, Iterable<Id> duplicatedRecordIds);
```

**Standard DML**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Set<Id> duplicateAccountIds = new Set<Id>{ duplicateId1, duplicateId2 };

Database.merge(masterAccount, new List<Id>(duplicateAccountIds));
```

**DML Lib**

```apex
Account masterAccount = [SELECT Id FROM Account WHERE ...];
Set<Id> duplicateAccountIds = new Set<Id>{ duplicateId1, duplicateId2 };

new DML()
    .toMerge(masterAccount, duplicateAccountIds)
    .commitWork();
```
