Data Migration Status

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1799

Table Type: Company

Table Name: Data Migration Status
Database Table Name: CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1799

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Data Migration Status can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Migration Type]
   ,[Destination Table ID]
   ,[Total Number]
   ,[Migrated Number]
   ,[Progress Percent]
   ,[Status]
   ,[Source Staging Table ID]
   ,[Migration Codeunit To Run]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Status]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Status].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Migration Status].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Migration Status table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Migration Type Primary Key SearchMigration TypeNormalText250Migration Typenvarchar(500)
2Destination Table ID Primary Key SearchDestination Table IDNormalInteger4Destination Table IDint
3Total Number SearchTotal NumberNormalInteger4Total Numberint
4Migrated Number SearchMigrated NumberNormalInteger4Migrated Numberint
5Progress Percent SearchProgress PercentNormalDecimal12Progress Percentdecimal(38,38)
6Status SearchStatusNormalOption4Statusint
Available options are:
  • “Pending”
  • “In Progress”
  • “Completed”
  • “Completed with Errors”
  • “Stopped”
  • “Failed”
7Source Staging Table ID SearchSource Staging Table IDNormalInteger4Source Staging Table IDint
8Migration Codeunit To Run SearchMigration Codeunit To RunNormalInteger4Migration Codeunit To Runint
9Error Count SearchError CountFlowFieldInteger4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Data Migration Status].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Status]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Migration Status].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Data Migration Status].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Migration Status$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Migration Status]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Migration Status].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

Your email address will not be published. Required fields are marked *