References & Glossary for the 7 milestones of ...

References

[1] The current list is not intended to be exhaustive and the description is intended primarily to be conceptual and non-technological.

[2] Synonyms in SQL Instance – Database Tool : CREATE SYNONYM [dbo].[Syn_Mig_D365_AccountTable] FOR [D365DB_MSCRM].[dbo].[AccountBase] …

[3] Stored procedures and Functions in SQL Instance – Database Tool : CREATE PROCEDURE [dbo].[sp_Update_BusinessUnit] @ParamSet UNIQUEIDENTIFIER,  @ParamExp UNIQUEIDENTIFIER,  @BU_Name NVARCHAR(255)…

[4] “Metadata Diagram Tool” helps to generate the partial or complete CRM entities model (“system”, “custom”) in a “Visio” file

[5] “Object Explorer" View in the "SQL Management Studio" tool helps to centralize our visualization around the same concept extracted by the tool “Metadata Diagram Tool”.

[6] Decompiling with DotPeek affords to glimpse the use of entities and the existing relations between entities.

[7] All the D365 .NET library is in the following directory : in the “…Server/bin/…”

[8] In a way, it is a question of updating unique identifier only (GUID) and to replace that of D365 (who comes from "Template" of base) with that of CRM 2011. This modification touches the list of entities listed above but also, entities which are linked of a point of "logical" life (for example by the concept of "OwnerId") and "physical appearance“ (by the foreign key in the table). Here is below the non-exhaustive list of entities:

[9] [11] Deployment Manager from D365 SDK

[10] [12] D365 CRUD operations :

Glossary

Active Directory: AD is a directory service developed by Microsoft for Windows domain networks. It is included in most Windows Server operating systems as a set of processes and services (https://en.wikipedia.org/wiki/Active_Directory ).

CRUD Operations: In computer programming, create, read, update, and delete (CRUD) are the four basic functions of persistent storage (https://en.wikipedia.org/wiki/Create,_read,_update_and_delete ).

Deployment Manager: Dynamics 365 Deployment Manager is a Microsoft Management Console (MMC) snap-in that system administrators and value-added resellers use to manage Deployment Administrator accounts, organizations, servers, and licenses for Dynamics 365 for Customer Engagement deployments (https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/deploy/use-deployment-manager-to-manage-the-deployment ).

DLL: Library that contains code and data that can be used by more than one program at the same time ( ). 

Functions: SQL Server Functions are useful objects in SQL Server databases. A SQL Server function is a code snippet that can be executed on a SQL Server

( ).

GUID: A universally unique identifier (UUID) is a globally unique identifier (GUID). This number is created by running the Guidgen.exe command line program ( ).

Jet Brains dotPeek : Free .NET Decompiler tool ( )

Metadata: Data that provides information about other data.

SDK Deployment: Dynamics 365 Software Development Kit related to CRM Deployment. SDK helps to manage CRM organization (i.e. import a new organization from a database).

Synonyms: alias or alternative name for a database object such as a table, view, stored procedure, user-defined function, and sequence. A synonym provides you with many benefits if you use it properly ( ).

Stored procedures: SQL Server stored procedures are used to group one or more Transact-SQL statements into logical units. The stored procedures are stored as named objects in the SQL Server Database Server ( ).