DBAmp - The latest version is 2.12.18.  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.18
====================================
- Fixed bug when Inserting with bulkapi using RecordTypeIds

Version 2.12.17
====================================
- Added support for the salesforce bulk api with sf_bulkops
- Fixed sf_bulkops bug for msg: Unable to create Salesforce Table Object

Version 2.12.16
====================================
- Fixed bug where sf_refreshall fails because TRY..CATCH fails to ROLLBACK

Version 2.12.15
====================================
- Fixed bug with Professional Edition access
- Fixed bug with numeric overflow

Version 2.12.14
====================================
- Fixed bug that cause msg "Invalid data for type "numeric"
- Fixed bug with sys_sffield output field SQL_Definition

Version 2.12.13
====================================
- Modified SF_ReplicateAll and SF_RefreshAll to continue processing if an error occurs
- Support for API 19.0

Version 2.12.12
====================================
- Added ToLabel support for picklist conversion

Version 2.12.11

====================================
- Fixed bug that caused dumps when the zip library was not initialized
- Added ORDER BY support for SOQL queries
- UserProfileFeed object is now skipped by both sf_replicateAll and sf_refreshAll

Version 2.12.9
====================================
- Fixed memory leak

Version 2.12.8
====================================
- Support for API 18.0

Version 2.12.7
====================================
- Fixed bug with SOQL Count() function returning multi-row results
- Added (back) Subset option on sf_refresh allowing you to handle schema changes better
- All custom fields are now created in SQL to allow nulls.
- There are now 2 versions of Create DBAmp SPROCS.sql. SQL 2000 users must execute Create DBAMP SPROCS SQL2000.sql
- Fixed bug with detecting delete rows in sf_refresh for linked servers using a read-only account

Version 2.12.6
====================================
- Added support for column subset views as a workaround for the 10K SOQL limit

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