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?
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
