DBAmp - The latest version is 2.12.5.  See below for version history.

Register for a free 30-day DBAmp trial.

Download latest version (for existing DBAmp customers only)

===============
VERSION HISTORY
===============
Version 2.12.5
====================================
- Correct one small memory leak
- Improved network retry capability

Version 2.12.4
====================================
- Corrected two small memory leaks

Version 2.12.3
====================================
- Removed buggy implmentation of sf_refresh Subset option

Version 2.12.2
====================================
- New stored procedure- SF_RefreshIAD. See documentation for details

Version 2.12.1
====================================
- Support for Proxy ConfigURL removed. All other proxy options remain.

Version 2.11.9
====================================
- Added support for alternate invocation of sf_bulksops
- Added 'subset' option to sf_refresh and sf_refreshall

Version 2.11.8
====================================
- Added support for api version 17.0
- Removed the Vote object from sf_replicateall and sf_refreshall due to salesforce restriction on queries

Version 2.11.7
====================================
- Fixed bug with single quotes in parameter values
- Fixed bug causing error message "Cannot get the data of the row from the OLE DB provider

Version 2.11.6
====================================
- Fixed bug with table names included on non-SOQL queries

Version 2.11.5
====================================
- Added support for SOQL relationship queries when using OPENQUERY. This new feature can make dramatic performance differences when joining tables.

Version 2.11.4
====================================
- Fixed bug with __Share and __History tables when using sf_bulkops or sf_generate

Version 2.11.3
====================================
- Fixed bug with decimal rounding

Version 2.11.2
====================================
- Fixed bug with UTF8 conversion

Version 2.11.1
====================================
- Added RAISEERROR statement to the sf_bulkops stored proc when it fails
- Added additional error messages for the "Batch Error" of sf_bulkops
- Added code for better memory management
- Fixed bug with negative literals in a WHERE clause

Version 2.10.9
====================================
- Fixed bug causing message "Error translating SQL statement.." when using parameters
- Added ability to use IgnoreNulls option with upsert

Version 2.10.8
===================================
- Option added to sf_bulkops to control batchsize. Smaller batch sizes may required to meet APEX restrictions.

Version 2.10.7
===================================
- Fixed slow memory leak which caused the error message: Not enough storage is available to process this command.
- Fixed bug with sf_bulkops when the table contained an Identity column.
- Added the ability to suffix table names with _QueryAll to retrieve archived and deleted records for that table.

Version 2.10.6
====================================
- Added support for BIT datatypes. See documentation for details on how to enable this setting.
- Fixed bug introduced in 2.10.4 with 2 single quotes

Version 2.10.5
====================================
- Added ability to Count() records with OPENQUERY. See documentation for more details.
- Added support for ConvertCurrency. See documentation for more details.
- Fixed bug with sf_refresh when used with Arizona timezone.

Version 2.10.4
====================================
- Fixed "Unable to set salesforce ServerURL and Session Id" bug with sf_replicate when a proxy was configured.

Version 2.10.3
====================================
- Upgraded to API level 15.0 (Spring 09)

Version 2.10.2
====================================
- Fixed bug where a Select against the Idea object returns Invalid data for type "numeric"
- Modified queries against the sys_sfobjects table to flush the local metadata cache
- Added new Trace option to show salesforce.com API performance

Version 2.10.1
====================================
- Redesigned sf_replicate for performance and reduced API counts

Version 2.9.19
=====================================
- Redesigned sf_refresh for performance and reduced API counts
- Rewrote sf_replicateall and sf_refreshall to use sys_sfobjects

Version 2.9.18
====================================
- Added support for Winter 09 (API 14.0)
- Removed ServerTimestamp from sys_sfsession for performance

Version 2.9.17
====================================
- Fixed bug with SQL Update that returns error msg "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption."
- Corrected sf_refreshall error with the AsyncApexJob table

Version 2.9.16
====================================
- Fixed bug with sf_refresh returns message "Error converting data type DBTYPE_DBTIMESTAMP to datetime"
- Improved single SQL Insert performance
- Added new option for sf_bulkops: Update:IgnoreNulls. See doc for more details

Version 2.9.15
====================================
- New system table added: sys_sfFields. Contains information about salesforce.com fields.
- New SQL script (Create DBAMP UDFS.sql) to create User Defined Functions for all DBAmp system tables.
- SF_BulkOps now produces warning messages for columns that do not match a field in salesforce.
- SF_ColCompare proc has been improved. See documentation for more details
- SF_Generate proc introduced. SF_Generate automatically creates input tables for SF_BulkOps
- Improved salesforce.com session caching to minimize the number of salesforce api logins
- Upgraded to use salesforce API 13.0 as default

Version 2.9.14
====================================
- Fixed bug that caused UTF8 conversion errors with Task table
- Modified sf_refreshall to skip the PartnerNetworkConnection table
- Fixed bug with the sys_sfpicklists table
- Fixed bug where sf_bulkops of Lead table was adding an AssignmentRuleHeader erronously, causing leads to be reassigned.

Version 2.9.13
====================================
- New parameter for sf_refresh and sf_refreshall that allows you to automatically replicate the object instead of throwing an error when there has been a schema change

Version 2.9.12
====================================
- Fixed issue with timeouts occuring with sf_replicate and sf_refresh

Version 2.9.11
====================================
- Added support for mulitple serial numbers with different expirations
- Fixed issue with dates in salesforce earlier than Jan 1, 1753

Version 2.9.10
====================================
- Error reporting added for low memory situation where DBAmp is unable to allocate needed buffers
- Added UseDefaultAssignment registry switch to add Assignment header to create and update requests

Version 2.9.9
====================================
- Fixed issue with SQL Update on 64 bit platforms
- Fixed issue with reference fields that have null values

Version 2.9.8
====================================
- Fixed situations where a field is made required but null values still exist on previous records
- Added SF_VASQuery for monitoring VAS memory on SQL 2005 systems.
- Modified SF_Refresh to handle ID collisions on the OpportunityHistory table

Version 2.9.7
====================================
- Add switch to turn off compression for debug sessions

Version 2.9.6
====================================
-- Stored Procedures sf_refresh, sf_bulkops, sf_uploadfile modified to use less sf session resources
-- Maximum size of Documents increased to 12582912 bytes.
-- DBAmp Configuration Program modified to allow update of DBAmp Serial Number
-- Upgraded to use salesforce API 12.0 as default
-- Fixed issue with text literals used in Select clause