web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Is there a way to fetc...

Customer experience | Sales, Customer Insights,...

Unanswered

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

(0) Share

Report

Report

Posted on by Chris Higgins

10

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?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Deepan Raj 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 118 Super User 2026 Season 1

#2

Jimmy Passeti 46 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans