DataMigrationUsingFetchXml 1.0.4

dotnet add package DataMigrationUsingFetchXml --version 1.0.4
NuGet\Install-Package DataMigrationUsingFetchXml -Version 1.0.4
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="DataMigrationUsingFetchXml" Version="1.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DataMigrationUsingFetchXml --version 1.0.4
#r "nuget: DataMigrationUsingFetchXml, 1.0.4"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install DataMigrationUsingFetchXml as a Cake Addin
#addin nuget:?package=DataMigrationUsingFetchXml&version=1.0.4

// Install DataMigrationUsingFetchXml as a Cake Tool
#tool nuget:?package=DataMigrationUsingFetchXml&version=1.0.4

Data Migration using FetchXml

This utility allows the user to migrate data of the entity from source to target.
The user needs to define FetchXml queries for each entity to which data should be migrated.

DataMigration_MainPage

The utility has the following input parameters:

  • Source Instance – Source instance is the default instance that is connected via XRMToolBox.
  • Target Instance – Target instance can be selected by clicking on the Select Target Instance button.
  • Logs Path – Directory where the system will save the Log.txt file.
  • FetchXml Table – Table to add FetchXml either by typing manually or selecting a file.

For the lookup fields, the user can specify the search by name instead of searching by id. For that, it’s needed to add the SearchByPrimaryField="true" attribute in the FetchXml attribute tag.

For example

<attribute name="transactioncurrencyid" SearchByPrimaryField="true" />

image

Note` Link entities can be used only for filtering or sorting purposes. For field values migration each FetchXml grid line should represent only one entity. <br/> You can update a target instance using the appropriate criteria.

  • Create – Does not delete the corresponding target record and creates a source record. (Will error in case of primary key matching)
  • Delete & Create – Deletes matched record and creates source record. (Will create in case of not matching)
  • Upsert – Updates matched target record with source record data. (Will create in case of not matching)
  • Don't Create – Does not create a source record.

MatchingCriteria image <br/>

After choosing one of these actions you can set matching criteria to migrate your data more accurately.

Match

Note` Matching criteria are not available for the Create action. <br/> If you have a primary key in fetchXml, it will be selected by default in the Matching criteria. You can also add a new row and select an attribute name from the dropdown, which will display all attribute names from fetchXml, and you can bind selected rows using "AND" or "OR" operators.

Product Compatible and additional computed target framework versions.
.NET Framework net462 is compatible.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.4 2,339 4/15/2024
1.0.3 12,312 11/25/2022
1.0.2 629 11/17/2022