Facing Issue in Record Sync-Unable to sync due to error in data source

Question

Hi All, 
 I am facing issue with record sync while writing dataset to the database table using write records. This works fine if we sync record manually , data is inserted , we get the primary key back to the process. The record is a simple record with no relationship defined. Going through the community posts , this issue comes when we have BIGINT type of datatypes defined in the table. So need to verify how to solve this issue without changing primary key column from int8/BIGINT to INT, as we need to store the values greater than int4 range in the database. Is there any way to make this sync work? Kindly guide. Attaching the screenshot. 
 
 Thanks

Ketan Patel · Answer

Great Point. 2 Billion cannot be Synced so no point in using synced records. So we are left with two options now: 
 1) Do not use records at all and use Query Entity and Write to Data Store Entities to perform DB operations. In this option we can keep DB column to BIGINT mapped to CDT Type "String" 
 2) Use Synced Records and get the DB Column Data Type changed to Int ensuring the value to this field will never exceed 2147483648. Adopt to data move and reset kind of cleanup process so the value could be contained within range.