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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Migration Type  | nvarchar(500) |
| 3 | Destination Table ID | int |
| 4 | Total Number | int |
| 5 | Migrated Number | int |
| 6 | Progress Percent | decimal(38,38) |
| 7 | Status | int |
| 8 | Source Staging Table ID | int |
| 9 | Migration Codeunit To Run | int |
| 10 | $systemId | uniqueidentifier |
| 11 | $systemCreatedAt | datetime |
| 12 | $systemCreatedBy | uniqueidentifier |
| 13 | $systemModifiedAt | datetime |
| 14 | $systemModifiedBy | uniqueidentifier |