Tuesday, July 9, 2019

In case you want to change your Dynamics 365 Finance and Operation Env URL

if there is a case you want to change your env URL in later point of time (rarely happens).
this is not straight forward like Dynamics 365 CE.
in FO you got to re create the env.

login LCS -> STOP the env -> Deallocate the env -> Delete the Env. after that you will get the Configure button over there  and reconfigure as per new URL.

NOTE: take note if you will do above, you will be loosing your data.
Hence take back up first and then you can restore those into the new env.

Regards,
yes.sudhanshu

Database movement operations in Dynamics 365 Finance and Operation


This is new feature given in LCS which is self-service action that can be used as part of Data Application Lifecycle Management. No more depending on MS or raising support ticket.

Below are the ways you can do this
  1. Refresh database : https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/database-refresh 
       Data elements that aren't copied during refresh
When refreshing a production environment to a sandbox environment, or a sandbox                             environment         to another sandbox environment, there are certain elements of the database               that are not copied over to the target environment. These elements include:
·         Email addresses in the LogisticsElectronicAddress table.
·         Batch job history in the BatchJobHistory, BatchHistory, and BatchConstraintHistory tables.
·         SMTP password in the SysEmailSMTPPassword table.
·         SMTP Relay server in the SysEmailParameters table.
·         Print Management settings in the PrintMgmtSettings and PrintMgmtDocInstance tables.
·         Environment-specific records in the SysServerConfig, SysServerSessions, SysCorpNetPrinters, SysClientSessions, BatchServerConfig, and BatchServerGroup tables.
·         Document attachments in the DocuValue table.
·         All users except the admin will be set to Disabled status.
·         All batch jobs are set to Withhold status.
  1. Export a database : https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/export-database 
Data elements that aren't exported
When you export a database backup from an environment, some elements of the database aren't exported in the backup file. Here are some examples:
·         Email addresses in the LogisticsElectronicAddress table
·         Batch job history in the BatchJobHistory, BatchHistory, and BatchConstraintHistory tables
·         SMTP password in the SysEmailSMTPPassword table
·         SMTP Relay server in the SysEmailParameters table
·         Print Management settings in the PrintMgmtSettings and PrintMgmtDocInstance tables
·         Environment-specific records in the SysServerConfig, SysServerSessions, SysCorpNetPrinters, SysClientSessions, BatchServerConfig, and BatchServerGroup tables
·         Document attachments in the DocuValue table
  1. Import a database : https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/import-database 
Data elements that require attention after import
Specific activities must be completed when you import a database backup into a sandbox UAT environment. Here are some examples:
·         Make sure that email capabilities are correctly reconfigured or turned off, according to your requirements.
·         Make sure that integration settings are turned on or off, according to your requirements.
·         Make sure that Application Object Server (AOS) servers are added back to required batch groups.
·         Make sure that system Help and task guides are reconnected.
·         Make sure that batch jobs are set to a status of Waiting.
·         Make sure that users are re-enabled.
  1. Database point-in-time restore (PITR) : https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/database-point-in-time-restore 
Above is helpful... 


Export Import Database in D365 Finance and Operation across Tiers

when there is a need to move the Data across environments for Dynamics 365 Finance and Operation.
in general we will get Prod, Sandbox: Test and Sandbox:Dev env when we subscribe D365F&O.

Moving Database from Sandbox: Test to Prod or vicevarsa is fine using LCS.
but moving Database from Sandbox: Test to Sandbox: Dev or viceversa is challenging.

cause : BIG NOTE: Move Database is only available on Tier 2+ environments.

Then how if there is a case we need to move from Dev to Test and vice versa.

below are the link to do so.....

Move from Dev to Test (UAT)

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/dbmovement-scenario-goldenconfig#export-the-database-from-sql-server 

Move from Test (UAT) to Dev 

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-operations-database 

All the steps (mainly some scripts) in above did not work for me. i did some modifications and get it done.

Do let me know if need any help.

Regards,
yes.sudhanshu