Data Migration Tool

The Data Migration Tool is used when installing Patch for MEM for the first time or when upgrading from a prior version.

New installations: The tool will create and configure your new Patch for MEM database.

Upgrades: If necessary, the tool will create a new database. It will also migrate settings and user data that were used in your previous version of Patch for MEM.

Who Needs to Use the Data Migration Tool?

The user who installs the database must have db_create permissions on the SQL Server. In addition:

If you are upgrading from 2020.1, the Data Migration Tool can be run just once by any user on any console.

If you are upgrading from a version prior to 2020.1, the Data Migration Tool must be run by all users on all consoles.

Accessing the Data Migration Tool

There are two ways to access the tool:

A dialog requesting you to launch the tool is displayed automatically when you access Patch for MEM for the first time following a new installation or an upgrade.

The tool can also be launched manually. You might do this if you prefer to automate the data migration process. In addition, you will need to launch the tool manually if you have multiple Patch for MEM 2019.2 consoles that used shared settings.

IMPORTANT! No Patch for MEM 2019.2 console should be allowed to connect to the database after it has been migrated by the Data Migration Tool. The database may be corrupted if this is allowed.

The methods used to launch the tool manually are:

Navigate to the C:\Program Files (x86)\Microsoft Endpoint Manager\AdminConsole\bin\ directory and double-click the file named ST.SCCM.DataMigrationTool.exe

Launch the tool from a command line prompt. This enables you to automate the process if you choose. Adding the argument /? will present usage information. For example: ST.SCCM.DataMigrationTool.exe /?

Using the Data Migration Tool

The Data Migration Tool will record log information to C:\Users\<username>\Ivanti\Patch\DataMigrationTool.log.

After accessing Patch for MEM for the first time following a new installation or an upgrade, one of the following dialogs is automatically displayed.

If you are performing a new installation or are upgrading from a prior version of Patch for MEM that did not use Shared Settings:

If you are performing an upgrade from a prior version of Patch for MEM that used Shared Settings:

In either case, perform the following steps.

1.Click Launch.

The Welcome dialog is displayed.

2.Click Next.

A dialog that asks for your Configuration Manager server name is displayed.

3.Type your server name

4.Click Test server connection and verify that the connection succeeded.

You cannot advance to the next dialog until you successfully test the connection.

5.Click Next.

A dialog that shows your current server and database names is displayed.

6.If necessary, edit the server name and the database name.

Server name: Type the name of the server that contains Microsoft SQL Server.

Database name: If you are performing a new installation or upgrading from a version prior to 2019.2, feel free to use the default name (IvantiPatchData) or type a different name. If you are upgrading from 2019.2 or later and had shared settings enabled, the database name that was used previously will be populated; do not change this name.

7.Click Test server connection and verify that the connection succeeded.

You cannot advance to the next dialog until you successfully test the connection.

8.Configure the database permissions.

This area is used to select the groups that will be enrolled in the db_datareader and db_datawriter roles on the database. The roles apply to globally-scoped Active Directory groups. The group(s) shown are the Active Directory groups you belong to that are domain qualified. All members in the groups you select will be provided read/write permissions on the database. If you need to add a group, do so using your normal process and then click Refresh. This will poll Active Directory for any new groups and will update the list.

Permissions can also be added at any time outside of the Data Migration Tool using SQL Server Management Studio.

9.Click Next.

If you have one or more tasks that need to be rescheduled due to a smart filter name conflict, a dialog that asks for your credentials is displayed. If you do not have any tasks that require rescheduling, skip to Step 12.

10.Specify credentials to use when rescheduling a publishing task.

11.Click Validate credentials and verify that the credentials were validated.

You cannot advance to the next dialog until you successfully validate the credentials.

IMPORTANT! Do not cancel out of the Data Migration Tool at this point. Doing so will have the effect of leaving your settings migrated, but tasks that require rescheduling will be unscheduled.

12.Click Next.

A dialog similar to one of the following is displayed, depending on whether you performed a new installation or upgraded from a previous version of Patch for MEM.

or

13.Click Next.

or

14.Click Finish.

Your Next Steps

With the database now configured and ready for use, your next steps should be to configure your settings.