Finance | Project Operations, Human Resources, ...

Move 'Batch jobs' from one Environment to another

(0) Share

Report

Posted on by Miha Mencin

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Miha Mencin 5 on at

Like (0)

Report
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

Go to environment, from where you want to copy your configs. Go to 'Data Management' -> select one data project under 'Data projects' tab

Download the *.xlsx file.

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.

Go to 'Design'

Click edit button under 'Entities for a processing group' -> 'Table'

It is mandatory to add 'DefinitionGroupId - Processing group' from 'Available Fields' so it's under selected Fields. It's best to add all!

Do the same for steps from 1. to 6. for the environment you want to copy the batch jobs configs to.

Copy data from source ENV excel to target ENV excel. Select only rows that are below header.

Click publish in destination ENV excel.

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?

Was this reply helpful? Yes No