Dynamics 365 For Finance and Operations database import in dev environment using SQL
About import The process of database import is needed when a new developer starts to work on a project and requires configured data for performing testing scenarios. In our projects we use preconfigured user data to improve our development and testing performance. We store a Tier 1 environment database backup (.bak) and use it when a new developer comes to work with a project. As Microsoft releases platform updates, we need, somehow, to use old backups from environments of older versions, for data import on Tier 1 developer environments. Keep in mind, that this article considers only Tier 1 environments. This instruction can be used to import and work with databases for different projects. Import database To import database a developer needs to have the database backup. Importatnt! For this operation you need to use Tier 1 database backup (.bak). 1. Download database backup. The database backup can be found in Asset Library of LCS (LifeCycle Services) project, as it is show...