Transfert de base de données de Ms Dynamics AX R3

Cela s’avère très utile pour procéder au transfère de base de données de Ms Dynamics AX R3 d'un environnement à un autre pour des fins de tests , développement ....

1- exporter la base de données Ms Dynamics AX via l'utilitaire de transfert de données Test Data Transfer Tool (beta) for Microsoft Dynamics AX 2012 [AX 2012]


exécuter la commande d'export sur la fenêtre de commande Windows :
cd "C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)"
DP.EXE EXPORT  "C:\RepertoireDeSauvegarde"  NomBaseDeDonnéesMicrosoftDynamicsAX

2 - copier le répertoire de sauvegarde sur l'environnement de destination
3- arrêter le AOS
4- importer la base de données sur environnement de destination via la commande Windows :

cd "C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)"
DP.EXE IMPORT "C:\RepertoireDeSauvegarde"  NomBaseDeDonnéesMicrosoftDynamicsAX


après avoir effectuer l'opération de transfert avec succès, on peut roncontrer quelques problèmes, comme exemples:
- société par défaut inexistante: cela est du au que cette société est crée sur l'environnement destination alors que sur l'environnement source ne l'ai pas, et que la table userInfo (contient les infos sur les options utilisateurs)  n'est pas mis à jour au moment du transfère: Pour procéder à la résolution de ce prob, rdv sur la table userInfo et changer le champ company de votre compte utilisateur, ensuite redémarrer le AOS et vous êtes connecté.

NB: certaines tables ne sont pas transférées =>

AGREEMENTHEADERTMP      \\ Filtered by the tool
AGREEMENTLINETMP      \\ Filtered by the tool
AIFACTION      \\ Filtered by the tool
AIFADAPTER      \\ Filtered by the tool
AIFAPPSHAREFILE      \\ Filtered by the tool
AIFAUTHENTICATIONCOMPONENT      \\ Filtered by the tool
AIFAZURESERVICEBUS      \\ Filtered by the tool
AIFCHANNEL      \\ Filtered by the tool
AIFCORRELATION      \\ Filtered by the tool
AIFDATAPOLICY      \\ Filtered by the tool
AIFDATAPOLICYLEGALVALUE      \\ Filtered by the tool
AIFDATAPOLICYXPATH      \\ Filtered by the tool
AIFDOCUMENTFIELD      \\ Filtered by the tool
AIFDOCUMENTFILTER      \\ Filtered by the tool
AIFDOCUMENTLOG      \\ Filtered by the tool
AIFDOCUMENTSCHEMATABLE      \\ Filtered by the tool
AIFDOCUMENTSETFILTERELEMENT      \\ Filtered by the tool
AIFENDPOINTACTIONVALUEMAPEXT_RU      \\ Filtered by the tool
AIFEXCEPTIONMAP      \\ Filtered by the tool
AIFFILESYSTEMCONFIGURATION      \\ Filtered by the tool
AIFGATEWAYQUEUE      \\ Filtered by the tool
AIFGDSCACHE      \\ Filtered by the tool
AIFGLOBALSETTINGS      \\ Filtered by the tool
AIFLOOKUPENTRY      \\ Filtered by the tool
AIFLOOKUPTABLE      \\ Filtered by the tool
AIFMESSAGELOG      \\ Filtered by the tool
AIFOUTBOUNDPROCESSINGQUEUE      \\ Filtered by the tool
AIFPIPELINE      \\ Filtered by the tool
AIFPIPELINECOMPONENT      \\ Filtered by the tool
AIFPORT      \\ Filtered by the tool
AIFPORTACTIONPOLICY      \\ Filtered by the tool
AIFPORTDOCUMENT      \\ Filtered by the tool
AIFPORTUSER      \\ Filtered by the tool
AIFQUEUEMANAGER      \\ Filtered by the tool
AIFRESOURCEIDMAP      \\ Filtered by the tool
AIFRESOURCELOCK      \\ Filtered by the tool
AIFRESPONSE      \\ Filtered by the tool
AIFRUNTIMECACHE      \\ Filtered by the tool
AIFSCHEMASTORE      \\ Filtered by the tool
AIFSERVICE      \\ Filtered by the tool
AIFSQLCDCENABLEDTABLES      \\ Filtered by the tool
AIFSQLCTTRIGGERS      \\ Filtered by the tool
AIFSQLCTVERSION      \\ Filtered by the tool
AIFTRANSFORM      \\ Filtered by the tool
AIFTRANSFORMELEMENT      \\ Filtered by the tool
AIFVALUESUBSTITUTIONCOMPONENTCONFIG      \\ Filtered by the tool
AIFVALUESUBSTITUTIONCONFIG      \\ Filtered by the tool
AIFWCFCONFIGURATION      \\ Filtered by the tool
AIFWEBSITES      \\ Filtered by the tool
AIFXMLTRANSFORMCONFIG      \\ Filtered by the tool
AIFXSLTREPOSITORY      \\ Filtered by the tool
BATCHSERVERCONFIG      \\ Filtered by the tool
BATCHSERVERGROUP      \\ Filtered by the tool
BIANALYSISSERVER      \\ Filtered by the tool
BICONFIGURATION      \\ Filtered by the tool
BOMTMPUSEDITEM2PRODUCEDITEM      \\ Filtered by the tool
COLLABSITEPARAMETERS      \\ Filtered by the tool
DEL_USERGROUPINFO      \\ Filtered by the tool
DEL_USERGROUPLIST      \\ Filtered by the tool
DIRADDRESSBOOKSECURITYROLE      \\ Filtered by the tool
EPGLOBALPARAMETERS      \\ Filtered by the tool
EPPERSONALIZE      \\ Filtered by the tool
EPWEBSITEPARAMETERS      \\ Filtered by the tool
ETUDIANT      \\ Missing in Source
RELEASEUPDATEBULKCOPYFIELD      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYFIELDERRORS      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYFIELDOPTIONS      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYLOG      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYPARAMETERS      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYTABLE      \\ Filtered by the tool
RELEASEUPDATEBULKCOPYTABLEEXCEPTIONS      \\ Filtered by the tool
RELEASEUPDATEBULKFLAGS      \\ Filtered by the tool
RELEASEUPDATEBULKREFRECIDPATCH      \\ Filtered by the tool
RELEASEUPDATEBULKTABLEINFO      \\ Filtered by the tool
RELEASEUPDATECONFIGKEY      \\ Filtered by the tool
RELEASEUPDATECONFIGURATION      \\ Filtered by the tool
RELEASEUPDATEDATAAREAOFFSETS      \\ Filtered by the tool
RELEASEUPDATEDISCOVERYSTATUS      \\ Filtered by the tool
RELEASEUPDATEDYNAMICDEPENDENCY      \\ Filtered by the tool
RELEASEUPDATEEXTENDEDDATATYPES      \\ Filtered by the tool
RELEASEUPDATEJOBSTATUS      \\ Filtered by the tool
RELEASEUPDATELOG      \\ Filtered by the tool
RELEASEUPDATEMINORSCRIPTS      \\ Filtered by the tool
RELEASEUPDATEPRIORITIZEDJOBS      \\ Filtered by the tool
RELEASEUPDATESCRIPTDEPENDENCY      \\ Filtered by the tool
RELEASEUPDATESCRIPTS      \\ Filtered by the tool
RELEASEUPDATESCRIPTSHISTORY      \\ Filtered by the tool
RELEASEUPDATESCRIPTSUSEDTABLES      \\ Filtered by the tool
RELEASEUPDATESPECIALFIELDMAPPING      \\ Filtered by the tool
RELEASEUPDATESPECIALTABLEMAPPING      \\ Filtered by the tool
RELEASEUPDATESYSDELETED      \\ Filtered by the tool
RELEASEUPDATETABLERELATIONTYPE      \\ Filtered by the tool
RELEASEUPDATETRANSFORMSOURCEFIELD      \\ Filtered by the tool
RELEASEUPDATETRANSFORMTABLE      \\ Filtered by the tool
RELEASEUPDATETRANSFORMTARGETFIELD      \\ Filtered by the tool
RELEASEUPDATEVALIDATION      \\ Filtered by the tool
SECURITYROLEASSIGNMENTRULE      \\ Filtered by the tool
SECURITYSEGREGATIONOFDUTIESCONFLICT      \\ Filtered by the tool
SECURITYSEGREGATIONOFDUTIESRULE      \\ Filtered by the tool
SECURITYTASKPERMISSION      \\ Filtered by the tool
SECURITYUSERROLE      \\ Filtered by the tool
SECURITYUSERROLECONDITION      \\ Filtered by the tool
SQLDESCRIBE      \\ Filtered by the tool
SQLDICTIONARY      \\ Filtered by the tool
SQLSTATISTICS      \\ Filtered by the tool
SQLSTORAGE      \\ Filtered by the tool
SQLSYNCINFO      \\ Filtered by the tool
SQLSYSTEMVARIABLES      \\ Filtered by the tool
SRSANALYSISENUMS      \\ Filtered by the tool
SRSSERVERS      \\ Filtered by the tool
SYNCAPP      \\ Filtered by the tool
SYNCAPPCOMPANY      \\ Filtered by the tool
SYNCCOMPOUNDTYPE      \\ Filtered by the tool
SYNCPARAMETERS      \\ Filtered by the tool
SYNCSIMPLETYPE      \\ Filtered by the tool
SYNCSIMPLETYPEKEY      \\ Filtered by the tool
SYSACTIVETEMPTABLE      \\ Filtered by the tool
SYSAOSMEASUREMENT      \\ Filtered by the tool
SYSBCPROXYUSERACCOUNT      \\ Filtered by the tool
SYSBPPARAMETERS      \\ Filtered by the tool
SYSBREAKPOINTLIST      \\ Filtered by the tool
SYSBREAKPOINTS      \\ Filtered by the tool
SYSCACHEFLUSH      \\ Filtered by the tool
SYSCLIENTPERF      \\ Filtered by the tool
SYSCLIENTSESSIONS      \\ Filtered by the tool
SYSCLUSTERCONFIG      \\ Filtered by the tool
SYSCODEPROFILERCHILDLINESUM      \\ Filtered by the tool
SYSCODEPROFILERCHILDMETHODSUM      \\ Filtered by the tool
SYSCODEPROFILERCHILDOBJECTSUM      \\ Filtered by the tool
SYSCODEPROFILERLINESUM      \\ Filtered by the tool
SYSCODEPROFILERMETHODSUM      \\ Filtered by the tool
SYSCODEPROFILEROBJECTSUM      \\ Filtered by the tool
SYSCODEPROFILEROBJECTTABLE      \\ Filtered by the tool
SYSCODEPROFILERPARAMETERS      \\ Filtered by the tool
SYSCODEPROFILERPATHTABLE      \\ Filtered by the tool
SYSCODEPROFILERRUNLINE      \\ Filtered by the tool
SYSCODEPROFILERRUNSUM      \\ Filtered by the tool
SYSCODEPROFILERRUNTABLE      \\ Filtered by the tool
SYSCOMPILEILTABLE      \\ Filtered by the tool
SYSCONFIG      \\ Filtered by the tool
SYSDATAIMPLOG      \\ Filtered by the tool
SYSDATAIMPLOGREF      \\ Filtered by the tool
sysdiagrams      \\ Filtered by the tool
SYSEVENT      \\ Filtered by the tool
SYSEXPIMPFIELD      \\ Filtered by the tool
SYSEXPIMPGROUP      \\ Filtered by the tool
SYSEXPIMPRECORDS      \\ Filtered by the tool
SYSEXPIMPTABLE      \\ Filtered by the tool
SYSEXPIMPTABLEQUERY      \\ Filtered by the tool
SYSGLOBALCONFIGURATION      \\ Filtered by the tool
SYSIMAGETABLE      \\ Filtered by the tool
SYSINETCSS      \\ Filtered by the tool
SYSINETTABLE      \\ Filtered by the tool
SYSINETTHEMETABLE      \\ Filtered by the tool
SYSINHERITANCERELATIONS      \\ Filtered by the tool
SYSLABELINTERVAL      \\ Filtered by the tool
SYSLABELLOG      \\ Filtered by the tool
SYSMANAGEDCODEACCESSSPECIFIERINFO      \\ Filtered by the tool
SYSMANAGEDCODECODECOMMENTINFO      \\ Filtered by the tool
SYSMANAGEDCODEEXPRESSION      \\ Filtered by the tool
SYSMANAGEDCODEEXPRESSIONMETHODCALLINFO      \\ Filtered by the tool
SYSMANAGEDCODEEXPRESSIONPARAMETER      \\ Filtered by the tool
SYSMANAGEDCODEEXPRESSIONPROPERTYCALLINFO      \\ Filtered by the tool
SYSMANAGEDCODEMETHOD      \\ Filtered by the tool
SYSMANAGEDCODEMETHODACCESSSPECIFIRINFO      \\ Filtered by the tool
SYSMANAGEDCODENAMESPACE      \\ Filtered by the tool
SYSMANAGEDCODENAMESPACEIMPORT      \\ Filtered by the tool
SYSMANAGEDCODEPROPERTY      \\ Filtered by the tool
SYSMANAGEDCODEPROPERTYACCESSSPECIFIRINFO      \\ Filtered by the tool
SYSMANAGEDCODESTATEMENT      \\ Filtered by the tool
SYSMANAGEDCODETYPE      \\ Filtered by the tool
SYSMANAGEDCODETYPEACCESSSPECIFIRINFO      \\ Filtered by the tool
SYSMANAGEDCODEVARIABLE      \\ Filtered by the tool
SYSMANAGEDCODEVARIABLEACCESSSPECIFIRINFO      \\ Filtered by the tool
SYSOCCCONFIGURATION      \\ Filtered by the tool
SYSQUICKLINKS      \\ Filtered by the tool
SYSQUICKLINKSORDER      \\ Filtered by the tool
SYSRECORDLEVELSECURITY      \\ Filtered by the tool
SYSSECURITYFORMCONTROLTABLE      \\ Filtered by the tool
SYSSECURITYFORMTABLE      \\ Filtered by the tool
SYSSERVERCONFIG      \\ Filtered by the tool
SYSSERVERSESSIONS      \\ Filtered by the tool
SYSSETUPLOG      \\ Filtered by the tool
SYSSQMDEPLOYMENT      \\ Filtered by the tool
SYSSQMSETTINGS      \\ Filtered by the tool
SYSTESTJOBTABLE      \\ Filtered by the tool
SYSTESTLINE      \\ Filtered by the tool
SYSTESTLINELOG      \\ Filtered by the tool
SYSTESTPARAMETERS      \\ Filtered by the tool
SYSTESTRECORDCLEANUP      \\ Filtered by the tool
SYSTESTRECORDCOUNTTABLE      \\ Filtered by the tool
SYSTESTTABLE      \\ Filtered by the tool
SYSTRACEFILES      \\ Filtered by the tool
SYSTRACETABLE      \\ Filtered by the tool
SYSTRACETABLESQL      \\ Filtered by the tool
SYSTRACETABLESQLEXECPLAN      \\ Filtered by the tool
SYSTRACETABLESQLTABREF      \\ Filtered by the tool
SYSUPGRADEOVERRIDDENESTIMATES      \\ Filtered by the tool
SYSUPGRADEPARAMETERS      \\ Filtered by the tool
SYSUPGRADERULE      \\ Filtered by the tool
SYSUPGRADETREENODECONFLICTINFO      \\ Filtered by the tool
SYSUSERINFO      \\ Filtered by the tool
SYSUSERLICENSECOUNT      \\ Filtered by the tool
SYSUSERLICENSELIST      \\ Filtered by the tool
SYSUSERLOG      \\ Filtered by the tool
SYSUSERPROFILES      \\ Filtered by the tool
SYSUTILELEMENTSLOG      \\ Filtered by the tool
SYSVERSIONCONTROLMORPHXITEMTABLE      \\ Filtered by the tool
SYSVERSIONCONTROLMORPHXLOCKTABLE      \\ Filtered by the tool
SYSVERSIONCONTROLMORPHXREVISIONTABLE      \\ Filtered by the tool
SYSVERSIONCONTROLPARAMETERS      \\ Filtered by the tool
SYSVERSIONCONTROLSYNCHRONIZELOG      \\ Filtered by the tool
TABLE1      \\ Missing in Source
TIMEZONESLIST      \\ Filtered by the tool
TIMEZONESRULESDATA      \\ Filtered by the tool
TMPPAYMMANOUTPUTREPORT      \\ Filtered by the tool
TRVADMINCUSTOMFIELDS      \\ Filtered by the tool
USERGROUPINFO      \\ Filtered by the tool
USERGROUPLIST      \\ Filtered by the tool
USERINFO      \\ Filtered by the tool
USERINFOSTARTUPMODEL      \\ Filtered by the tool
VSASSEMBLY      \\ Filtered by the tool
XREFDIALOGUPDATE      \\ Filtered by the tool
XREFNAMES      \\ Filtered by the tool
XREFPATHS      \\ Filtered by the tool
XREFREFERENCES      \\ Filtered by the tool
XREFTABLERELATION      \\ Filtered by the tool