Finance | Project Operations, Human Resources, ...

need to update or insert data on PROD without downtime in D365FO

(0) Share

Report

Posted on by CU10121822-0

314

Hi Team,

Is it possible to update or insert data on PROD without downtime? If required, then what will be the best approach.

Kindly elaborate please.

Thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Martin Dráb 239,762 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sure, that's what users do every day. They open forms and create and update data there.

I guess you meant something else but forgot to mention your actual requirement...

Was this reply helpful? Yes No
CU10121822-0 314 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin,

mean while I am searching on google , and found something "Custom scripts". What is it?

How we can proceed with that. Is with custom scripts we can do the same what i am looking for?

Kindly elaborate please. thanks!

Was this reply helpful? Yes No
Suggested answer

Adis 6,816 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Custom scripts is the way to go in my opinion. We do this some times when it is required. I would suggest to copy PROD to a sandbox, test the script there and the run it in production.

Run custom X++ scripts with zero downtime - Finance & Operations | Dynamics 365 | Microsoft Learn

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Suggested answer

Subra 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU10121822-0

Yes, We can update the record using custom script. Please do complete testing taking a backup from Prod to UAT and do the testing and execute the same in Prod.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/run-custom-scripts

Is there any specific reason why you are looking for this approach?

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
CU10121822-0 314 on at

Like (0)

Report
Copy link

Link copied!

Thanks Adi and Subra,

As said "copy PROD to a sandbox, test the script there and the run it in production".

1.Means need to restore PROD db backup to SandBox.

2. then run the custom script

3. and finally run in to PROD. is it??

So. I am not aware of that earlier. Kindly let me know where to write the custom script and to run in PROD, deployment package in not required right?

Kindly explain please

Was this reply helpful? Yes No
Suggested answer

Subra 1,302 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU10121822-0

Yes, you are correct.

For the custom Script can be developed in the dev environment. if you have any internal team for the support. you can reach out to them and do the needful.

Custom script is required package but it's not required downtime.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No