When saving a redirect, SQL server database does not support ignoring conflicts.

[markpape]

Issue Summary

When changing the slug of a page, an attempt to save a redirect is done by wagtail, if the server is SQL server (MSSQL) a NotSupportedError appears related to including the kwarg {'ignore_conflicts': True}.

Exception Location: | .env/lib/python3.10/site-packages/django/db/models/query.py, line 681, in _check_bulk_create_options
Raised during: | wagtail.admin.views.pages.edit.EditView

Steps to Reproduce

1. Setup Wagtail with MSSQL, ODBC Driver 17 for SQL Server
2. Create a Page
3. Change a Page slug

• I have confirmed that this issue can be reproduced as described on a fresh Wagtail project: (no)

Technical details

• Python version: Run 3.10.12.
• Django version: 4.2
• Wagtail version: 6.01
• Browser version: Edge 123
• MSSQL DB driver: ODBC Driver 17 for SQL Server

Working on this

I do not yet have thoughts on skills needed except to allow for a condition for MSSQL and exclude the kwarg in that case.
I would be keen to work on this once the issue has been accepted.