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

IMPORTANT: Version 2.14.3 is NOT compatible with SQL 2000.

Register for a free 30-day DBAmp trial.

Download latest version (for existing DBAmp customers only)

 

===============
VERSION HISTORY
===============

Version 2.14.3
=================================
- Added support for the bulkAPI to the sf_refresh stored procedure

Version 2.14.2
=================================
- SF_Replicate / SF_ReplicateAll now automatically create a primary key on the Id field
- SF_CreateKeys / SF_DropKeys now only create/drop foreign keys.
- Added support for UnDelete operation with SF_Bulkops

Version 2.14.1
=================================
- Added support for loading content and attachments using a file name.
- The following features have been deprecated starting with this release:
    SQL 2000 support,
    sys_sflastid, and
    SF_UploadFile.
Contact DBAmp support if you need to explore workarounds.

Version 2.13.13
=================================
- Corrected length calculations for MaxBase64Size
- Fixed bug with OpenQuery / SOQL when using Group By

Version 2.13.12
=================================
- Support for API 23.0 (WINTER 12)
- Support for the MetadataOverride registry setting

Version 2.13.11
==================================
- Added support for running DBAmp out of process
- Added support for Delete with OpenQuery
- Corrected error with sf_createviews not including date fields

Version 2.13.10
==================================
- Modified sf_refresh to add timestamp to the temporary tables it creates
- Added 'Verify' option to sf_refresh and sf_refreshall
- All base64 fields are now treated as nullable.

Version 2.13.9
==================================
- Added 'Repair' option to sf_refresh

Version 2.13.8
==================================
- Improved memory utilization for low memory situations
- Fixed bug when using OpenQuery to Update a column to null
- Fixed issue with embedded single quotes in a where clause
- Support for API 22.0 (Summer 11)

Version 2.13.7
==================================
- Fixed bug with WHERE clause evaulation when using the BIT datatype
- Fixed bug when UPDATE with OPENQUERY sets a Datetime field to a new value

Version 2.13.6
===================================
- Fixed bug with sf_refresh and deleted records (V 2.13.5 users only)

Version 2.13.5
====================================
- Support for API 21.0

- MAJOR BREAKING CHANGE with sf_bulkops. In order to make it easier to detect successful rows after a sf_bulkops run, sf_bulkops now populates the Error field with Operation Successful. Previously, sf_bulkops would write a single blank for successful records. All post sf_bulkops processing must be examined and rewritten to the new output:

Select * from Account_Update where Error like '%Operation Successful%'

If you require the Error column handling of the previous versions of DBAmp, there is a registry switch you can set to force DBAmp to revert to the previous behavior: LOCAL_MACHINE/SOFTWARE/DBAmp/BulkOpsCompatibility

This version of DBAmp writes the phrase Operation Successful to the Error column when the operation succeeds. Previous versions of DBAmp wrote a single blank for successful rows. If your integration code needs the previous version behavior, set BulkOpsCompatibility to 1.
Be sure to restart SQL Server after changing this setting.

- MAJOR BREAKING CHANGE: SQL 2008 and datetime2(7). On SQL 2008 systems, date and datetime fields of salesforce.com objects are now created as datetime2(7) fields in the local database. To force these fields to be created as datetime fields instead, set the Database Compatibility Level of the Salesforce backup database to 90 prior to replicating the data (step 5 above). This change applies to SQL 2008 only.

Version 2.13.4
====================================
- Fixed issue with V2.13.3 and SQL 2000
- Added SSIS direct connect support. See documentation for details.

Version 2.13.3
====================================
- Fix bug when using the BulkAPI switch of sf_bulkops.
Symptom is an erroneous"In transmitted batch" error msg in the error column.
- Fix bug when sf_bulkops is passed a link server name that contains an embedded blank

Version 2.13.2
====================================
- Full SOQL support in OPENQUERY (see next item)
- IMPORTANT: There are potentially breaking changes in this version for users of
OPENQUERY. Please review your integration and correct as needed:

* OPENQUERY now accepts full SOQL syntax. SQL syntax is no longer accepted in the OPENQUERY.
* Updates that use OPENQUERY must include the Id as a column in the column list.
* Deletes that use OPENQUERY are no longer allowed.

Version 2.13.1
====================================
- Support for API 20.0
- Fixed bug with column length changes not being detected as schema change

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