Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Move 'Batch jobs' from one Environment to another

(0) ShareShare
ReportReport
Posted on by 5

Greetings All,

I want to move all the 'Batch jobs' from PROD to UAT environments, since there are differences between them. Since there is a lot of jobs and entities that are being exported to BYODs, going manually trough all is a no-go. I'm developing D365FO on VHD provided by MS. When setting up the VHD, I imported a AXDB + BYODs.from PROD. WIth AXDB all the jobs came already configured as on PROD. I can't do the same for UAT, since it's using different configs.

We are using:

  • Application release: 10.0.26
  • Platform release: Update50

Is there a way to copy just certain tables from PROD to UAT, so I get the same configured 'Batch jobs' without affecting any other configs?

Example for copying tables:

  • [dbo].[BATCH]
  • [dbo].[BATCHABORTREQUESTTABLE]
  • [dbo].[BATCHCLASSCONFIGURATIONOVERRIDES]
  • [dbo].[BATCHCONSTRAINTS]
  • [dbo].[BATCHCONSTRAINTSHISTORY]
  • [dbo].[DMFBATCHSTATUSTABLE]
  • [dbo].[DMFDEFINITIONGROUPEXECUTION]
  • [dbo].[DMFDEFINITIONGROUPEXECUTIONBATCHLINK]
  • [dbo].[DMFEXECUTION]
  • [dbo].[DMFPARAMETERS]
  • [dbo].[DMFSTAGINGLOG]

Thank you in advance.
Best regards

  • Miha Mencin Profile Picture
    Miha Mencin 5 on at
    RE: Move 'Batch jobs' from one Environment to another

    Hello Mohit,

    we have a lot of custom code, that uses different endpoints, configs, etc. so we really want to avoid restoring the database from PROD to UAT, that why I only want to copy only the batch-job configs.

    I was told there is also another way to copy batch-job configs. I tried it but the mappings we're not applied and 'Export across all companies' is not applied

    1. Go to environment, from where you want to copy your configs. Go to 'Data Management' -> select one data project under 'Data projects' tab
    2. Download the *.xlsx file.
      2023_2D00_04_2D00_14_5F00_09.19.45_5F00_capture_2D00_Export_5F002D002D005F00_Finance_5F00_and_5F00_Operations_5F0014205F00_Mozilla_5F00_Firefox.png
    3. Open it in Excel(one of the full version). You will get a prompt from 'Microsoft Dynamics' asking you to sign in. After signing in, you'll see all the entities in this batch job.
      2023_2D00_04_2D00_14_5F00_09.34.57_5F00_capture_2D00_DataManagementDefinitionGroupDetails_5F00_6381705325270.png
    4. Go to 'Design'
      2023_2D00_04_2D00_17_5F00_13.49.03_5F00_capture_2D0028002B0029005F00_Forums_5F002D005F00_Dynamics_5F00_365_5F00_Finance_5F00_Forum_5F002D005F00_Dynamics.png
    5. Click edit button under 'Entities for a processing group'  -> 'Table'
      2023_2D00_04_2D00_17_5F00_13.49.51_5F00_capture_2D00_DataManagementDefinitionGroupDetails_5F00_6381732810236.png
    6. It is mandatory to add 'DefinitionGroupId - Processing group' from 'Available Fields' so it's under selected Fields. It's best to add all!
      2023_2D00_04_2D00_17_5F00_13.50.30_5F00_capture_2D0028002B0029005F00_Forums_5F002D005F00_Dynamics_5F00_365_5F00_Finance_5F00_Forum_5F002D005F00_Dynamics.png
    7. Do the same for steps from 1. to 6. for the environment you want to copy the batch jobs configs to.
    8. Copy data from source ENV excel to target ENV excel. Select only rows that are below header.
      2023_2D00_04_2D00_14_5F00_09.47.51_5F00_capture_2D00_DataManagementDefinitionGroupDetails_5F00_6381705325270.png
    9. Click publish in destination ENV excel.
    10. Check target ENV if the data project was published

    Does anyone have an idea, why the mappings aren't applied? Is it even possible to copy them this way and have everything working?

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Move 'Batch jobs' from one Environment to another

    Hi Miha, May I know what do you meant by 'I can't do the same for UAT, since it's using different configs'.

    Restoring database from Prod to UAT is straight forward and most common step. I would suggest to retsore DB instead of migrating batch jobs. If you still want to import table specific data, it can be done by data entities. However, standard data entities like BatchJobEntity is Readonly so you have to duplicate it.

  • Suggested answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: Move 'Batch jobs' from one Environment to another

    Hi Miha,

    A database refresh lets you copy the transactional and financial reporting databases of your production environment into the target, sandbox UAT environment. Please check the thread for the same topic:

    community.dynamics.com/.../1235350

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans