Over the time I have started developing a tool that pulls salesforce metadata information and creates oracle/sql server “create table” scripts. Isn’t that really awesome!!
The most useful part of the tool is field data type mapping i.e, what data type of salesforce maps to what data type of oracle/sql server. Below is the list of mapping that I used while generating create table scripts – enjoy!!
| salesforce data type | sql server data type | oracle data type |
| boolean | bit | varchar2(1) |
| date | smalldatetime | date |
| datetime | Datetime | date |
| currency | decimal(precision,scale) | number(precision,scale) |
| double | decimal(precision,scale) | number(precision,scale) |
| int | Int | number(10) |
| picklist | nvarchar(255) | varchar2(255) |
| id | nvarchar(18) | varchar2(18) |
| reference | nvarchar(18) | varchar2(18) |
| textarea | nvarchar(max) | varchar2(4000) |
| nvarchar(255) | varchar2(255) | |
| phone | nvarchar(255) | varchar2(255) |
| url | nvarchar(255) | varchar2(255) |
| textarea | nvarchar(max) | varchar2(4000) |
| multipicklist | nvarchar(max) | varchar2(4000) |
| anyType | nvarchar(max) | varchar2(4000) |
| percent | decimal(5,2) | number(5,2) |
| combobox | nvarchar(max) | varchar2(4000) |
| base64 | nvarchar(max) | varchar2(4000) |
| time | nvarchar(255) | varchar2(255) |
| string | nvarchar(length) | varchar2(length) |
Recent Comments