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
   [timestamp]
   ,[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 columns in Data Migration Status table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Migration Type Primary Key Searchnvarchar(500)
3Destination Table ID Primary Key Searchint
4Total Number Searchint
5Migrated Number Searchint
6Progress Percent Searchdecimal(38,38)
7Status Searchint
8Source Staging Table ID Searchint
9Migration Codeunit To Run Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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