MS Dynamics AX2012 / D365 Finance and operations

  Sometimes D365FO developers facing the task to import, export, or delete models. Some ISV solutions are provided as model files, which contain programmable objects (metadata and code) and related resources. Also, all the systems customizations should be created in a model. In this blog post we will learn how to management models, using the Fleet Management Extension model as an example. A model is a group of elements, such as metadata and source files, that typically constitute a distributable software solution and includes customizations of an existing solution. Also, a model is a design-time concept, for example a warehouse management model or a project accounting model. A model always belongs to a package. A package is a deployment and compilation unit of one or more models. It includes model metadata, binaries, and other associated resources. One or more packages can be packaged into a deployable package, which is the vehicle used for deployment on runtime environments. ...

  2.  Create new database. After you connected to your work server in SSMS(Microsoft SQL Server management Studio) you need to Right click on Databases folder and choose “Restore database”. In table 1 are show settings for database restoration. This process will create a new database called AxDB _ new. Table 1. Settings for database restoration Picture 2. Restore database 3.  Run script to alter database. After performing steps above, you need to change current main database to imported one. To perform this operation use script below: --set main db to single connections and drop the existing connections ALTER DATABASE AxDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE --rename datbase to db_old ALTER DATABASE AxDB MODIFY NAME = AxDB_old --set the old db to multi user ALTER DATABASE AxDB_old SET MULTI_USER --rename the new db to the main db name ALTER DATABASE AxDB_new MODIFY NAME = AxDB   Now your environment is ready to perform data upgrade operation.