Is there a way to fetch fixed number of records using Data Migration Utility Tool?

(0) Share

Report

Posted on by Chris Higgins

I'm trying to migrate records to a test environment using Microsoft's Data Migration Utility Tool. I only want a few thousand records from each table. I tried using the "top="x"" within the FetchXML but I'm getting an error because the tool uses paging. Is there a way to only migrate over a fixed number of records using this tool?

All responses (1)

Answers (0)

Deepan Raj 25 on at

Like (0)

Report

RE: Is there a way to fetch fixed number of records using Data Migration Utility Tool?

Hi Chris Higgins

I have solution for your problem

step 1 please check your fetch xml query

SELECT TOP 4 autonumber(column)
FROM request(table)
where controlnumber(column) is not Null

i have used this query i have limited the number of records

the problem is in your records you need a autonumber or specific column that specifics a column count
pease check and use sql for cds to generate fetch xml and use in data migration tool

thank you