Sync SQL Server rowversion-timestamp column into Dataverse column

[nicksoft]

Has any one sync SQL server "Rowversion -timestamp" datatype into Dataverse column?

We are looking for a best way to store SQL Server datatype "Rowversion -timestamp" into dataverse column. 

According to this article "Column data types in Microsoft Dataverse (contains video) - Power Apps | Microsoft Learn" , bigint - timestamp might be the way, but creation of this column is only awailable through API only.  Has any one have example how it can be done?

If Any one have any recommendation, please let me know. 

[eleung83 · Accepted solution]

You have two options, either perform an odata webapi request with a payload to create a new attribute: 
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/customize-entity-metadata
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/create-update-entity-def...

Or you can write some code e.g. in a console app, that consumes the current CrmSdk Core assemblies to add new columns to a table:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/org-service/create-custom-entit...

https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.messages.createattributerequest?view=...
https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.metadata.bigintattributemetadata?view...