Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Salesforce to SQL Field Mapping Document

I'm trying to find our create a spreadsheet that can be used as a reference to show what Salesforce fields convert to in SQL. For instance, a checkbox is a varchar, a date is always datetime2(7), a picklist is always nvarchar, a lookup field is nchar, etc.

I'm working a on large scale consolidation and migration, and it would be very helpful as I create test SQL scripts to merge the data to make sure I'm using the right definitions. The length of fields is not critical on text as that will be determined by the target Org, but the type of field would be great.
1 person has
this question