README file for DBAmp/Pro WARNING: This version of DBAmp is NOT compatible with SQL 2000. Do not install if you are using SQL 2000. This version of DBAmp is also NOT compatible with Windows XP. There is one install package in this zip: DBAmpInstall.exe - this installs DBAmp on the SQL Server machine ================== INSTALLATION NOTES ================== YOU ARE NOT DONE YET. There are additional installation instructions in the DBAmp Installation Manual. Please continue the install using the procedures in Chapter 1. IF YOU ARE UPGRADING, a SQL restart is required and you must upgrade every SQL database that currently contains DBAmp stored procs with the new versions. Do this by running the Create DBAMP SPROCS.sql file. See the DBAmp Installation Documentation for more information. =============== VERSION HISTORY =============== Version 5.1.9 ============================== - Support for API 53.0 (Winter 22) - Added support for SF_Mirror being picked up in Performance Views Version 5.1.8 ============================== - Fixed bug in SF_Mirror with deleted records when specifying queryall option - Changed timeout for pushing blob Ids using SF_TableLoader to one hour Version 5.1.7 ============================== - Fixed bug when specifying table aliases with SF_BulkSOQL - Added soap header for KeepAccountTeam option - Fixed bug when specifying the IgnoreNulls option with SF_TableLoader - Fixed performance issues when using SF_Replicate and SF_Mirror with the SOAP API Version 5.1.6 ============================== - Introduced pushing blob Ids using SF_TableLoader. See the Doc for more information. - Made some changes to Serial Numbers page of the DBAmp Configuration Program. Version 5.1.5 ============================== - Fixed bug with ntext and nvarchar(max) fields with SF_Refresh and using Subset - Changed handling hard deleted rows to not timeout after 10 minutes - Support for API 51.0 (Spring 21) Version 5.1.4 ============================== - Fixed bug when using SF_Mirror and ToLabel/ConvertCurrency turned on - Fixed bug when replicating OwnerSharingRule tables - Columns are now in alphabetical order in replicated tables Version 5.1.3 ============================== - Fixed bug when replicating History tables using soap Version 5.1.2 ============================== - Changed Primary Key creation on local table in SF_Replicate to not timeout after 10 minutes - Fixed bug in SF_Generate with createable and updateable flags - Fixed bug with SF_Mirror and Daylight Savings Time Version 5.1.1 ============================== - Fixed bug with spaces in Foreign Key Lookup values when using SF_TableLoader - Fixed bug with ntext and nvarchar(max) fields with SF_Refresh Version 5.1.0 ============================== - First release for CData - Fixed bug in SF_BulkSOQL when tabs or newlines were in SOQL statement - Fixed bug in SF_Refresh for replicateable flag Version 5.0.2 ============================== - Fixed bug in DBAmpTableOptions table - Fixed issue with NewValue and History tables Version 5.0.1 ============================== - BREAKING CHANGE: DBAmp now uses bit datatype instead of varchar(5) for all boolean fields. - BREAKING CHANGE: All fields are now nullable, except for Id field on local tables. - Fixed bug with columns with trailing blanks in SF_TableLoader - Re-write of SF_Replicate/SF_ReplicateIAD/SF_BulkSOQL/SF_Metadata to use DBAmpAZ.exe internally. - SF_Mirror now preserves secondary indexes on local tables. Version 4.1.8 ============================== - Support for API 50.0 (Winter 21) - Fixed issue with DBAmpAZ.exe when using a proxy - Fixed bug in parsing table name when using SF_Mirror Version 4.1.7 ============================== - Fixed issue when using Money SQL datatype with SF_TableLoader - Re-write of SF_BulkOps to use DBAmpAZ.exe internally. Version 4.1.6 ============================== - Fixed issue with new SF_BulkOps introduced in version 4.1.5 Version 4.1.5 ============================== - Fixed bug with last refresh time when SF_Refresh is executed during an SF_Replicate run. Version 4.1.4 ============================== - Fixed bug when passing erroneous values for Date and DateTime fields with SF_TableLoader. - Fixed bug to force any tables containing Binary fields to use the SOAP API with SF_Mirror. - Fixed bug when sending boolean fields for converting leads with SF_TableLoader. - Fixed bug when getting Time Zone information from Registry. Version 4.1.3 ============================== - Deprecated SF_ReplicateTemporal, SF_RefreshTemporal, SF_BulkSOQLTemporal, and SF_BulkSOQL_RefreshTemporal. See the "Making Local Copies as Temporal Tables" section in Chapter 3 of the DBAmp Doc for more information. - Fixed bug with tables containing Binary fields with SF_Mirror. Version 4.1.2 ============================== - Fixed bug in SF_Mirror when linked server name contains hyphens. - Fixed bug with SF_Mirror and versions prior to SQL Server 2016. - Fixed bug with DBAmpClient and MinLongSize. Version 4.1.1 ============================== - Fixed bug in SF_TableLoader when writing results where locking and internal server errors occur - Added Einstein objects that need to skipped in SF_ReplicateAll, SF_RefreshAll, and SF_MirrorAll - Removed JobId option from SF_Mirror, SF_Replicate, SF_ReplicateTemporal, and SF_TableLoader Version 4.1.0 ============================== - SF_BulkOps is being deprecated. Use SF_TableLoader as a replacement. - DBAmp can no longer use Proxy Config URL. Proxy URL are still supported. - Introduced SF_Mirror and SF_MirrorAll stored procedures. See the Doc for more information - Support for table options using DBAmpTableOptions. DBAmpProcOptions is no longer used. - Fixed a bug with SF_Replicate and network keep alive timeouts. Version 3.9.3 ============================== - Fixed bug in SF_BulkSOQL_Refresh for last refresh time and time zones Version 3.9.2 ============================== - Support for API 48.0 (Spring 20) - Fixed parsing bug for SF_Generate Version 3.9.1 ============================== - Support for API 47.0 (Winter 20) - Fixed parsing bug in SF_BulkSOQL_Refresh Version 3.8.9 ============================== - Fixed bug in SF_BulkSOQL for case sensitive SOQL statement - Fixed bug in Serial Numbers page of DBAmp Configuration Program - Fixed parsing bug for error messages in SF_TableLoader when using the bulkapi - Fixed bug when using brackets around linked server in DBAmp commands Version 3.8.8 ============================== - Better error handling when receiving Integrity Check errors with SF_TableLoader Version 3.8.7 ============================== - Fixed bugs with SF_BulkSOQL_Refresh and last refresh time - Fixed bug with SysFields in SF_CheckFormulaFields Version 3.8.6 ============================== - Fixed parsing bug with SF_Replicate for Feed objects - Fixed DBAmpProcOptions bugs Version 3.8.5 ============================== - Made a few changes on how DBAmp cleans up files on errors with Replicates - Fixed bug for corrupted CSV error - Fixed bug for index out of range error on CSV files - Fixed bug when PKChunk and QueryAll are used with SF_BulkSOQL - Fixed bug with QueryAll when using SF_BulkSOQL_Refresh Version 3.8.4 ============================== - Support for API 46.0 (Summer 19) Version 3.8.3 ============================== - Added additional view to SF_CreateSysViews - Fixed bugs with Metadata Override Version 3.8.2 ============================== - Fixed bug in Create DBAmp SPROCS.sql file when Temporal tables were introduced Version 3.8.1 ============================== - Fixed bug when using the pkchunk option on LoginHistory - Fixed bug in parsing table name from SOQL Statement when using SF_BulkSOQL - Cleaned up SF_TableLoader when using certain options - Introduced making local copies as Temporal tables Version 3.7.9 ============================== - Support for table options using DBAmpProcOptions. See the Doc for more information. - DBAmp now requires .Net 4.6 or higher to install - Made a few changes when getting batch list for bulkapi replicates Version 3.7.8 ============================== - Fixed bugs with Error 1 on Attachment table - Introduced DBAmp System Views. See the Doc for more information. - Made changes to SF_Refresh and SF_RefreshIAD when using the BulkAPI option - Fixed System.NullReferenceException error when getting batch results when using BulkAPI Version 3.7.7 ============================== - SF_ReplicateLarge has been depricated. Use SF_Replicate with pkchunk/bulkapi options instead - Added AssignmentRuleId support in SF_TableLoader when using the BulkAPI Version 3.7.6 ============================== - Fixed bug where scale was set to higher number than precision when using Metadata Override - Support for API 45.0 (Spring 19) Version 3.7.5 ============================== - Fixed bug in SF_TableLoader to handle smallint and tinyint data types - Introduced The DBAmp Client. See the Doc for more information. Version 3.7.4 ============================== - Fixed bug in SF_TableLoader where failures occurred with only Id in the input table - Fixed bug with SF_TableLoader on certain input table names Version 3.7.3 ============================== - Fixed bug in SF_TableLoader to handle uniqueidentifier data type - Fixed SF_Replicate to handle Spring 19 truncation bug Version 3.7.2 ============================== - SF_Replicate now supported with no xp_cmdshell - Fixed bug in SF_TableLoader to handle date data type Version 3.7.1 ============================== - BulkAPI now supported by SF_TableLoader - Extensive performance changes to SF_TableLoader when using BulkAPI - Extensive performance changes made to MigrateAmp Version 3.6.9 ============================== - Fixed bug with SF_Replicate on certain table names - Fixed bug with SF_TableLoader when there was a global failure and ignorefailures was used Version 3.6.8 ============================== - Added logic to create unique work table names in SF_Replicate - Added SF_TableLoader view to DBAmp Performance Package - Fixed bug with SF_BulkOps with external Id Foreign Keys - Support for API 44.0 (Winter 19) Version 3.6.7 ============================== - Fixed bug in SF_TableLoader to print column name when there are invalid XML characters - Introduced SF_BulkSOQL_Refresh - Fixed bug in SF_TableLoader to clean up CSV files in Work Directory - Fixed bug in SF_Generate where not all columns were being included for custom objects Version 3.6.6 ============================== - Made performance enhancement to SF_BulkSOQL when creating _previous table - Fixed SF_TableLoader to only need an Id column in input table when using delete operation - Discontinued support for using Splunk with DBAmp Version 3.6.5 ============================== - Support for API 43.0 (Summer 18) Version 3.6.4 ============================== - Fixed bug with RecordAction table - Support for inserting into Platform Event tables - FIxed bug with SOAP headers when using SF_TableLoader Version 3.6.3 ============================== - SF_RefreshAll now skips EngagementHistory due to API restriction - Added job restart to SF_TableLoader - Fixed issue for case sensitivity on the Id column when using SF_TableLoader - Increased SQL Command Timeouts from 30 seconds to 5 minutes in SF_TableLoader Version 3.6.2 ============================== - Added support for big objects (read-only), check the doc for more information Version 3.6.1 ============================== - Fixed issue with SF_TableLoader when using foreign key references with bulkapi - Fixed issue with files not deleted in DBAmp Work directory on catastrophic failure Version 3.5.9 ============================== - Fixed issue with SF_TableLoader when there was an error on insert Version 3.5.8 ============================== - Fix for use of SF_Tableloader via CMDEXEC - Support for API 42.0 (Spring 18) - Restrict DBAmp Work,Blob,Trace directories from using Program Files Version 3.5.7 ============================== - Fix SF_Refresh for Invalid data type numeric errors - Fix issue with SF_TableLoader with upsert and id as external id - Fix issue with SF_TableLoader when no Error column exists Version 3.5.6 ============================== - Fixed issue with SF_Replicate leaving files behind after error - Fixed issue in SF_TableLoader with case insensitive column names Version 3.5.5 ============================== - Introduced SF_TableLoader - Salesforce does not send back column data when using Upsert with bulkapi2 - Fixed issue with SF_RefreshIAD when using columnsubsets Version 3.5.4 ============================== - Support for API 41.0 (Winter 18) - Removed support for SQL 2005 - Fixed SF_BulkOps when passing type as a field name - Fixed SF_Refresh for intermittent INVALID_REPLICATION_DATE errors Version 3.5.3 ============================== - Fix for SF_ReplicateHistory writing Failed for successful runs to DBAmp_Log - Fix for SF_Bulkops using global temporary tables Version 3.5.2.2 ============================== - Modified MigrateAmp to handle Pricebooks and related tables better - Fix for SF_BulkOps when handling __KA tables Version 3.5.2.1 ============================== - Fixed SF_BulkOps to correctly accept parameters with bulkapi Version 3.5.2 ============================== - Modified SF_BulkSOQL to accept SOQL statement as parameter - Fixed SF_BulkOps when passing Id as an External Id for Upsert - Fixed SF_Replicate using BulkAPI/PkChunk where Job Id was getting mangled with CipherCloud Version 3.5.1 ============================== - Code rewrite for SF_Bulkops - Fix for SF_ReplicateKAV to pull all languages - Fix SF_Replicate of LoginHistory issue - Fix for SF_Replicate when used in non-English culture Version 3.4.9 ============================== - Support for API 40.0 - Fix for SF_BulkSOQL when using nvarchar(max) - Fix for absurd formula fields values in SF_Replicate Version 3.4.8 ============================== - Fixed issue with quoted strings in SF_BulkSOQL - Fixed issue with SF_Replicate where table name had an embedded __c Version 3.4.7 ============================== - Fixed issue with datetime value prior to 2007 and daylight time - Fixed issue with files not deleted in DBAmp Work directory Version 3.4.6 =============================== - Fix 5 minute timeout issue with sf_replicate - Fix SF_Bulkops issue with InsightsExternalData tables Version 3.4.5 =============================== - Fixed bug with SF_Metadata when accessing more recent metadata types - Internal SF_Replicate code improvements - Corrected SF_Bulkops error with very small percentage fail Version 3.4.4 ================================ - Set default value of MaxBase64Size to 0 - Addedd new SF_DownloadBlobs proc Version 3.4.3.1 ================================ - Fixed issue with sf_replicate when using pkchunk Version 3.4.3 ================================ - Fixed issue with sf_replicateIAD not pulling archived rows (since V3.4.1) - Fixed issue with sf_replicate using bulkapi not returning all rows Version 3.4.2 ================================ - Support for API 39.0 (Spring 2017) Version 3.4.1 ================================ - Extensive performance changes to sf_replicate when using bulkapi or pkchunk Version 3.3.6 ================================ - Fix bug with OpportunityHistory for long running processes - Fix bug with sf_bulkops with no timezone conversion and bulkapi - DBAmp now requires .NET 4.5 or greater to install - Modified SF_Replicate to throw warning (not error) for primary key issues Version 3.3.5 ================================ - Support for API 38.0 (Winter 2017) - Fix for issues with views with same name as table - Support for skipping tables with SF_ReplicateAll using TablesToSkip - Fix for unicode file names with binary columns Version 3.3.4 ================================ - Introduction of DBAmp for Splunk - Change login API call timeout to 5 minutes Version 3.3.3 ================================ - Fix for queries against the ApexTestResultLimits - Fix SF_Refresh against CurrencyType incorrectly deleting rows - Fix for incorrect large integer values when using openquery - Fix for foreign key external referencing Version 3.3.2 ================================ - Fix for DatedConversionRate StartDate values Version 3.3.1 ================================ - Fix for querying tables with external references - Changes made to DBAmp Performance Trace option - Support for API 37.0 (Summer 2016) Version 3.2.9 ================================ - Fix for 60 second "The operation has timed out" bug Version 3.2.8 ================================ - Changes made to DBAmp Performance Package - Changes made to Trace file format - Fixed bug with bulkapi(ns) - Fixed bug with SF_Refresh of RevenueForecast table Version 3.2.7 ================================ - New MigrateAmp User Interface. See doc for details. Version 3.2.6 ================================ - Fix for issue with pkchunk and history/share tables - Fix for nodrop option to handle scale correctly Version 3.2.5 ================================ - Fix for bulkapi issue/ sf_replicateLarge Version 3.2.4 ================================ - Fix for SF_Replicate issue with LoginEvent - Fix for long hangs on login api calls - New procedure SF_ReplicateKAV - Bug fixes for MigrateAmp Version 3.2.3 ================================ - Added NoDrop option to sf_replicate - Fix for hang associated with sf_refresh Version 3.2.2 ================================ - DBAmp now requires a 64 bit OS to install - New DBAmp Configuration Program introduced Version 3.2.1 ================================ - Fixed issue with accessing EntityDefinition and FieldDefinition tables Version 3.1.9 ================================ - Support for API 36.0 (Spring 2016) - Fixed hanging bug when using PKChunk with small tables - Fix issue with MigrateAmp Campaign member Version 3.1.8 ================================ - Bug Fixes for MigrateAmp Version 3.1.7 ================================ - Multiple MigrateAmp bugs fixed Version 3.1.6 ================================ - MigrateAmp beta added to product (MigrateAmp is a paid add-on) - Fix for SQL crash when absurd formula value is passed - Altered behavior for PathOnClient column Version 3.1.5 ================================ - Support for API 35.0 (Winter 2016) Version 3.1.4 ================================ - Support for pkchunking in SF_Replicate with pkchunk option Version 3.1.3 ================================ - Fix for "unclosed token" error Version 3.1.2 ================================ - Fix issue with SF_ReplicateLarge message output - Fix issue with performance views failing Version 3.1.1 ================================ - Fix sf_bulkops bug when Error column is fixed length - Remove FieldPermissions table from ReplicateAll / RefreshAll Version 3.1.0 ================================= - Support for TLS 1.1 / 1.2 Version 2.20.11 ================================= - Fix for improper response messages from salesforce Version 2.20.10 ================================= - Second fix for access violation in SQL Server Version 2.20.9 ================================= - Fix for "Invalid column name 'name' in SF_Refresh - Fix for scrambled results when using the Sort column and sf_bulkops Version 2.20.8 ================================= - Fix for access violation in SQL Server - Support for API 34.0 Version 2.20.7 ================================= - Fixed bug with 'true' literal in select list - Added DBAmp Performance Package. See DBAmp manual for details Version 2.20.6 ================================= - Fixed issue with invalid names on sys_sfobject query - Fixed bug with SQLDefinition column in sysn_SFFields table Version 2.20.5 ================================= - Fixed bug with sf_bulkops when an UNKNOWN_EXCEPTION error occurs. Version 2.20.4 ================================= - Fixed bug with sf_bulkops using the bulkapi and setting lookup field to null Version 2.20.3 ================================= - Fixed bug with Upsert:bulkapi when using non-insertable external ids Version 2.20.2 ================================= - Support for API 33.0 Version 2.20.1 ================================= - Fixed bug with decimal rounding - Modified SF_ReplicateAll and SF_RefreshAll to skip the PlatformAction and CollaborationGroupRecord tables - Fixed SF_Metadata to correctly handle ApprovalProcess Version 2.19.9 ================================= - Fixed bug with SF_Refresh not properly cleaning up delete tables Version 2.19.8 ================================= - Fixed SF_ReplicateLarge bug that produced empty tables Version 2.19.7 ================================= - Added support for overriding metadata on string fields Version 2.19.6 ================================= - Fixed regression error with API 32.0 caused by ActionOverrides Version 2.19.5 ================================= - Support for API 32.0 (Winter 15) Version 2.19.4 ================================= - Additional fixes for hangs Version 2.19.3 ================================= - Fixed bug that caused random "Hangs" Version 2.19.2 ================================= - Added the ability to sort the load table when using sf_bulkops with bulkapi Version 2.19.1 ================================= - Fixed sf_refresh bug of not detecting deleted columns Version 2.18.9 ================================= - Support for API 31.0 (Summer 14) Version 2.18.8 ================================= - Corrected "Accessor is invalid" error with sf_bulkops and bulkapi Version 2.18.7 ================================= - Improved performance when using sf_bulkops and bulkapi - Added ability to use foreign key/external id reference when using bulkapi Version 2.18.6 ================================= - Change to adjust batchsize of sf_replicateall when chunking by parent Version 2.18.5 ================================= - Fixed bug when querying the Order table Version 2.18.4 ================================= - Support for API 30.0 (Spring 14) - Added batchsize support to sf_replicateLarge Version 2.18.3 ================================= - Fixed bug with sf_replicatelarge and the OpportunityFieldHistory table Version 2.18.2 ================================= - Fixed SF_Metadata bug with null reference msg Version 2.18.1 ================================= - Fixed bug with base64 fields and openquery - Add SF_ReplicateLarge to replicate when query timeouts occur - Added option to SF_Replicate to retrieve previous job results - Change SF_Replicate with bulkapi option to use 12 hour bulkapi status timeout Version 2.17.9 ================================= - Fixed bug when using dateme variables in a exec with a query - Added nostatus option to bulkapi sf_bulkops Version 2.17.8 ================================= - Fixed bug in sf_replicatehistory when replicating custom object history - Added pilot support for the Metadata api support - Fixed issue with hung jobs when using sf_bulkops - Added support for file names when inserting into FeedItem - Modified SF_Refresh to cleanup work tables if failed - Fixed issue with SF_Refresh when branching to sf_replicate for schema chgs Version 2.17.7 ================================= - Indicate expired serial numbers in Configuration Program - Support for API 29.0 (Winter 13) Version 2.17.6 ================================= - Performance improvements when using the bulkapi option - Increase size of the Metadata Override option Version 2.17.5 ================================= -- Significant Performance Gain (2X) for large sf_bulkops calls Version 2.17.4 ================================= - Fixed bug with picklists and nvarchar(max) Version 2.17.3 ================================= - Added ability to use _QueryAll tables in openquery and SSIS Version 2.17.2 ================================= - Added more detailed error messaging for sf_bulkops - IdeaComment table is now skipped by SF_ReplicateAll and SF_RefreshAll Version 2.17.1 ================================= - Support for API 28.0 (Summer 13) Version 2.16.8 ================================= - Modified DBAmp to handle new sandbox url convention introduced with Summer 15 Version 2.16.7 ================================= - Improved error messaging for Selects using OPENQUERY Version 2.16.6 ================================= - Fixed bug with sf_refresh when DATEFORMAT is dmy - Support for Currency Fields in sf_bulkops Version 2.16.5 ================================= - Fixed bug with sf_bulkops when using the bulkapi option and a non-empty error column Version 2.16.4 ================================= - Fixed bug when using sf_bulkops with __datacategoryselection tables - Fixed bug with openquery when returning a long text column Version 2.16.3 ================================= - Fixed bug when using sf_bulkops with __kav tables Version 2.16.2 ================================= - SF_ReplicateIAD modified to retain all deleted records in current table. - Fixed bug with SQL Delete against empty linked server table - Added ability to SF_Refresh the FeedComment table - Added Inline Help Text to sys_sffields Version 2.16.1 ================================= - Added Try-Catch logic to some of the DBAmp stored procedures - Added support for SQL Native Client 11 - Modified bulkapi options for sf_replicate and sf_refresh - Added ability to load via file name for Documents - Support for API 27.0 (Spring 2013) Version 2.15.9 ================================= - Fixed small memory leak for location fields - Changed the default for sf_bulkops when using the bulkapi to the following: batchsize of 5000 (instead of 10,000) serial execution (instead of parallel) This should reduce locking errors on the salesforce server Version 2.15.8 ================================= - Support for GeoLocation fields Version 2.15.7 ================================= - Added bulkapi polling to sf_bulkops - Improved Error Handling when Server Errors occur - Added Error msg for invalid select item expression - Fixed bug with sys_sfpicklists when the values contains / Version 2.15.6 ================================= - Fixed bug with long IN clauses and other complicated queries - Fixed bug with SQL Delete statement failing with catastrophic error Version 2.15.5 ================================= - Fixed bug with sf_replicate with dates earlier than 1753 Version 2.15.4 ================================= - Fixed bug with bulkapi option not reading the http timeout values Version 2.15.3 ================================= - Fixed bug with sf_refresh that occurs with long running queries - Fixed bug with sf_bulkops using the bulkapi option and not handling DST changes properly - Support for API 26.0 (Winter 13) Version 2.15.2 ================================= - bulkapi and batchsize options add to sf_replicate - sf_replicateIAD modified to always create primary key on Id - sf_refreshIAD correctly handles Subset option - Fixed bug when running upsert from command line Version 2.15.1 ================================= - Previous DBAmp Registry entries now survive an upgrade - Support for API 25.0 (Summer 12) - Fixed bug with SF_Logger proc when msg contains a quote Version 2.14.10 ================================= - Fixed bug with id truncation when using ConvertLead function Version 2.14.9 ================================= - Fixed bug where large negative numbers exceed the column definition - Fixed bug with DAY_ONLY function when using openquery - Corrected locking issue with SSMS when running SF_Refresh Version 2.14.8 ================================= - Added support for Converting Leads to SF_BulkOps stored procedure Version 2.14.7 ================================= - Added support for SOAP Headers in SF_BulkOps stored procedure - Created new logging stored procedure: SF_Logger Version 2.14.6 ================================= - Registry settings are now available in the DBAmp Configuration Program - By default, DBAmp does NOT download the data of Base64 columns and the value is set to NULL. Modify the "Base64 Field Maximum Size" registry setting to change this behavior. - Numerous fixes to Base64 fields (i.e. Attachments) Version 2.14.5 ================================= - DBAmp now compatible with SQL Server 2012 Version 2.14.4 ================================= - Code modified for better memory utilization - Added support for API 24.0 (SPRING 12) - Fixed issue with embedded question marks in string literals - Fixed issue with using ConvertTimezone in openquery - Fixed issue with "Invalid Numeric" when using aggregate functions in openquery Version 2.14.3 ================================= - Added bulkAPI option to sf_refresh. 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) - The Chatter Feed tables have been removed from sf_replicateall and sf_refreshall Version 2.13.7 ================================== - Fixed bug with WHERE clause evaluation 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 RecordIds 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 that occurs when an error is encountered in a query 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 implementation 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. - Fixed bug with 2 single quotes in an SQL statement ( where LastName = 'O''Dell' ) 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 erroneously, 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 occurring with sf_replicate and sf_refresh Version 2.9.11 ==================================== - Added support for multiple 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 Version 2.9.5 ==================================== -- Added support for replicating archived and deleted records via sf_replicateIAD -- Corrected processing for IN clause Version 2.9.4 ==================================== -- Added support for encrypted fields -- Fixed bug with sf_bulkops when errors occurred in a batch. Version 2.9.3 ==================================== -- Changes made to Trial Key algorithms Version 2.9.2 ==================================== -- Support for EmailHeaders via new registry switches Version 2.9.1 ==================================== -- Support for foreign key relationships when doing bulk operations -- Fixed bug with sf_replicate and large attachments Version 2.9.0 ===================================== -- Internal migration to VS 2005 from VS 2003 -- New version of Office Toolkit included in the install Version 2.8.5 ===================================== -- Added Registry switch NoTimeZoneConversion. Default value of 0 indicates that DBAmp is to do local to GMT conversions Value of 1 indicates that DBAmp is to operate in GMT time only Version 2.8.4 ===================================== -- Fixed bug with sf_replicate failing while downloading a zero byte Attachment. Version 2.8.3 ===================================== -- Fixed bug with sf_bulkops where failed row error msgs were not written to the table. Version 2.8.2 ===================================== -- New versions of sf_replicate and sf_refresh with enhanced performance. Version 2.8.1 ===================================== -- Modified code for better salesforce session management -- Modified code to handle new sandbox org id changes with Summer 07 Version 2.8.0 ===================================== -- Modified SF_Refresh and SF_RefreshAll to refresh History tables -- Bug fix: ReceiveTimout Value from registry is now correctly used when replicating Version 2.7.8 ===================================== -- Small enhancement to increase tcp utilization Version 2.7.7 ===================================== -- Bug fix for a small memory leak -- Modification to allow global temporary tables to be pass into sf_bulkops (## tables) Version 2.7.6 ===================================== -- Added a new version of replicate called SF_Replicate2. SF_Replicate2 does the initial download of data into a _Previous table, thus avoiding locking the main table for the duration of the replicate. Version 2.7.5 ===================================== Bug Fixes: - Fixed Memory Leak in DBAmp.dll Version 2.7.0 ===================================== Bug Fixes: - DBAmp modified to work correctly under SQL Server 2005 SP2 - Sf_BulkOps modified to flag invalid XML characters in the input table - Fixed Memory Leak in DBAmpReplicate.exe that affected SF_Replicate and SF_Refresh - SF_BulkOps modified to correctly handle missing ID values on insert - Support for SQL Server SP2 added New Features: - SF_BulkOps now has an Upsert option. This is particularly valuable in integration work. Version 2.4.5 ===================================== Bug Fixes: - Improved Error trapping for bulk inserts of Attachments Version 2.4.4 ===================================== Bug Fixes: - The DBAmp stored procedures have changed to retrieve the servername using SERVERPROPERTY instead of @@SERVERNAME. - The HTTP Connect and Receive timeouts can now be configured using a registry setting. Contact forceAmp support for more information. Version 2.4.3 ===================================== Bug Fixes: - Major changes to the sf_replicate and sf_refresh stored procedures to dramatically reduce the size of the SQL Transaction Log. In addition, the new procedures eliminate the need for the _Previous tables that existed in previous versions. Version 2.4.2 ===================================== Bug Fixes: - Fixed error ('OLE DB provider 'DBAmp.DBAmp.1' supplied inconsistent metadata for a column. Metadata information was changed at execution time.') that occurs when using the sf_replicate stored procedure. Version 2.4.1 ===================================== Bug Fixes: - Fixed an error that occurs when SQL INSERTing rows into the Attachment table. Version 2.4 ===================================== Important: Once again, the DBAmp Stored Procedures have changed. If you are installing version 2.4 over a previous version of DBAmp, you will need to rerun the Create DBAmp SPROCS.qry file. Previous versions of the stored procedure will not work with the new version of DBAmp. Features: - Ability to create primary and foreign keys on the local replicated tables. With this feature, you can build database diagrams of your Salesforce.com database. - Performance Improvements by eliminating some background queries to the salesforce servers. - Improved handling of multiple salesforce.com instances. The salesforce.com UserName/Password are no longer needed by the DBAmp Configuration program. These values are now picked up automatically from the SQL Linked Server definition. Version 2.3.11 ===================================== - Bug fixed when an alternate endpoint (like 7.0) is used with a permanent key Version 2.3.10 ===================================== - DBAmp can now incrementally refresh your local replicated tables. See the sf_refresh and sf_refreshall stored procedures in the documentation. Refreshing a table instead of replicating it can save significant time. - SF_Replicate now will RAISERROR if the procedure fails. This change was added to correctly denote failure when running under a job step. Previously, if the stored proc failed then the job step would report success anyway. This will, however, change the behavior of the SF_ReplicateAll stored procedure when used in a job. If an individual table fails to replicate, the job step will end at that point with failure rather than continuing on to the next table. You can alter this behavior by commenting out the RAISERROR statements at the bottom of the SF_Replicate stored procedure. - DBAmp now allows you enter proxy information if required by your network. For more information, see the documentation. Important: Once again, the SF_Replicate and SF_BulkOpts Stored Procedures have changed. If you are installing version 2.3.10 over a previous version of DBAmp, you will need to rerun the Create DBAmp SPROCS.qry file. Previous versions of the stored procedure will not work with the new version of DBAmp. DBAmp now requires V3.0.0.40 of the Office Toolkit (released 3/14/2006). Please download and install the latest version of the Toolkit from www.sforce.com/OfficeToolkit. For SQL Server 2000, you must be at Service Pack 3a or higher. Note that there is a problem with SQL Server 2000 Service Pack 4. If you are at Service Pack 4, you must obtain the hotfix from Microsoft at http://support.microsoft.com/?id=901200 . Version 2.3.9 ===================================== New in this release - Support for Upload files to Documents and Attachments (DBAmp/Pro only) - DBAmp now treats datetime values in a WHERE clause as being the local time, not UTC (as in previous versions). - Fix for table names beginning with 'Order' If you are upgrading from a previous release (other than 2.3.8), please see the information below on the SF_Replicate stored procedure changes.