Sitecore Data Transfer tool helps quickly migrate dozens of Sitecore content items. This tool uses SQL BULK INSERT.

Full Description you can find here

In the SerializingOptions.json file:

• Specify the ConnectionString for the Master database of your Sitecore instance from which you would like to make content export
• Specify Sitecore content RootItemId under which your target content lives

Others parameters main remain as is

• Download or clone this repository
• Configure SerializingOptions.json
• Open the solution, make a build and run ScDataTransfer.UI project (this is a console application). You will see a simple screen:

• Press 2 for running
• After, you will see quite the same picture:

• When is completed, navigate to App_data folder and observe that the following files (the names of these go from the SerializingOptions.json):

To complete the whole content data transferring, we need to perform some more steps:

• Make sure to export the Root Sitecore Item (configured in the SerializingOptions.json) from the old Sitecore instance to a new one

• Use SQL Management Studio to execute BULK INSERT SCRIPT located here

• Log into your target Sitecore Admin Panel — Control Panel — Rebuild link databases:

• Certainly, you can publish migrated content if needed

In my case 43 000 items - two minutes for both Serialization and BULK INSERT processes.