Data Upgrade Manual Bulk Copy and generation of Direct SQL Scripts using X++ Job

  • During data upgrade often it comes a requirement to run Bulk Copy for some tables which were unable to be Bulk Copied Before due to any reason (which could be table / field mapping issue etc..)
  • Now if the particular tables were unable to be Bulk copied from source to target since there Direct Sql Script was not generated which is stored in ReleaseUpdateBulkCopyTable in AX 2012 in Field named 'DirectSQl' :
  • To generate that DirectSQL script to perform Bulk Copy follow the following procedure:
    • The class which handles the Bulk Copy process is 'ReleaseUpdateBulkCopyDB', few thing we will need prior to execute the below script is to Obtain the Source and Target connection string which could be obtaine from table 'RELEASEUPDATEBULKCOPYPARAMETERS',
    •  Use the following SQL Script to fetch this information : 
      • Select * from RELEASEUPDATEBULKCOPYPARAMETERS
    • Copy the SourceConnectionString and TargetConnectionString and update the below X++ job :
static void BulkCopy(Args _args)
{
ReleaseUpdateBulkCopyTable ReleaseUpdateBulkCopyTable;
ReleaseUpdateBulkCopyDB BC = new ReleaseUpdateBulkCopyDB();
BC.setSourceConnection('<SourceConnectionString >');
BC.setTargetConnection('<TargetConnectionString>');
BC.initConnections();
while select ReleaseUpdateBulkCopyTable
where ReleaseUpdateBulkCopyTable.oldtablename== <tableName>
{
BC.bulkCopyTable(ReleaseUpdateBulkCopyTable);
}
}

Execute this Job with the Condition as per requirenment  , this will generate the DirectSql and perform the Bulk Copy of Data from Source to target.



Comments

Post a Comment

Popular posts from this blog

D365: SSRS Report Development/ Customization

Image
Hi guys, Today in this blog I will be demonstrating the procedure for the SSRS Reports development and customization in D365FO. Before proceeding with the Development or customization make sure that you have created a new model for your customization since we will be using extensions approach in our customization because An extension enables you to add functionality to existing model elements and source code. Coming back to the main objective of this blog which is to Develop SSRS reports in D365. One point to keep in mind is that there is no change on How you develop query based report and RDP based report in D365FO . The only change is you have to use extensions for standard report. If you are developing brand new report based on custom tables, there is no change. So in this Blog I will discuss How to customize an existing SSRS Report in D365 using Extensions approach step by step: Step#1:  The first step is to create a new model, Below are the steps to create a new model: Na...
Read more

D365: X++ code to add custom lookup on worker to show specific workers team workers only

/// <summary>             ///             /// </summary>             /// <param name = "_formReferenceControl"></param>             /// <returns></returns>             public Common lookupReference( FormReferenceControl _formReferenceControl)             {                 SysReferenceTableLookup      sysTableLookup = SysReferenceTableLookup ::newParameters( tablenum ( HcmWorker ), _formReferenceControl, true );                 Query ...
Read more

Dynamics ax 2012: Sample code for fetching records in tmp table using query and Insert record set

public static server void constructData(ASMARMatricsReportingTmp     _tmp,                                         TransDate                    _asOfDate,                                         TransDate                    _startDate,                            ...
Read more