Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_Refresh and SF_Replicate failing after Account record types added to Salesforce

As of yesterday we have added two new Account record types.

Since these have been added we have been unable to run replicate or refresh commands from the Accounts table and this has resulted in deadlocking our SQL database which contains the Salesforce data.

Any help would be greatly appreciated

Best regards

Martin
1 person has
this problem
+1
Reply
  • Can post the entire output if the sf_replicate command? Also what version of DBAmp are you running?

    Finally, can you post a screenshot of the wIts screen from the SQL Activity monitor showing the locked process?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Hi Bill,

    Thank you for the prompt reponse.

    - Version 2.17.6

    - We have been unable to replicate the locked process

    --- Starting SF_ReplicateAll
    --- Starting SF_Replicate for AG1__Call_Planner__Share
    09:47:48: Drop AG1__Call_Planner__Share_Previous if it exists.
    09:47:48: Create AG1__Call_Planner__Share_Previous with new structure.
    09:47:48: Run the DBAmp.exe program.
    09:47:48: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:48: Populating local table AG1__Call_Planner__Share_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:47:50: DBAmp is using the SQL Native Client.
    09:47:50: Opening SQL Server rowset
    09:47:52: 484 rows copied.
    09:47:52: Drop AG1__Call_Planner__Share if it exists.
    09:47:52: Rename previous table from AG1__Call_Planner__Share_Previous to AG1__Call_Planner__Share
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:47:52: Create primary key on AG1__Call_Planner__Share
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AG1__Call_Planner__Tag
    09:47:52: Drop AG1__Call_Planner__Tag_Previous if it exists.
    09:47:52: Create AG1__Call_Planner__Tag_Previous with new structure.
    09:47:52: Run the DBAmp.exe program.
    09:47:52: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:52: Populating local table AG1__Call_Planner__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:47:53: DBAmp is using the SQL Native Client.
    09:47:53: Opening SQL Server rowset
    09:47:53: 0 rows copied.
    09:47:53: Drop AG1__Call_Planner__Tag if it exists.
    09:47:53: Rename previous table from AG1__Call_Planner__Tag_Previous to AG1__Call_Planner__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:47:53: Create primary key on AG1__Call_Planner__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AG1__Call_Planner__c
    09:47:53: Drop AG1__Call_Planner__c_Previous if it exists.
    09:47:53: Create AG1__Call_Planner__c_Previous with new structure.
    09:47:53: Run the DBAmp.exe program.
    09:47:54: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:54: Populating local table AG1__Call_Planner__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:47:54: DBAmp is using the SQL Native Client.
    09:47:54: Opening SQL Server rowset
    09:47:56: 178 rows copied.
    09:47:56: Drop AG1__Call_Planner__c if it exists.
    09:47:56: Rename previous table from AG1__Call_Planner__c_Previous to AG1__Call_Planner__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:47:56: Create primary key on AG1__Call_Planner__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Composer_Settings__Tag
    09:47:56: Drop APXTConga4__Conga_Composer_Settings__Tag_Previous if it exists.
    09:47:56: Create APXTConga4__Conga_Composer_Settings__Tag_Previous with new structure.
    09:47:56: Run the DBAmp.exe program.
    09:47:56: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:56: Populating local table APXTConga4__Conga_Composer_Settings__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:47:57: DBAmp is using the SQL Native Client.
    09:47:57: Opening SQL Server rowset
    09:47:58: 0 rows copied.
    09:47:58: Drop APXTConga4__Conga_Composer_Settings__Tag if it exists.
    09:47:58: Rename previous table from APXTConga4__Conga_Composer_Settings__Tag_Previous to APXTConga4__Conga_Composer_Settings__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:47:58: Create primary key on APXTConga4__Conga_Composer_Settings__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Composer_Settings__c
    09:47:58: Drop APXTConga4__Conga_Composer_Settings__c_Previous if it exists.
    09:47:58: Create APXTConga4__Conga_Composer_Settings__c_Previous with new structure.
    09:47:58: Run the DBAmp.exe program.
    09:47:58: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:58: Populating local table APXTConga4__Conga_Composer_Settings__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:47:58: DBAmp is using the SQL Native Client.
    09:47:58: Opening SQL Server rowset
    09:47:59: 0 rows copied.
    09:47:59: Drop APXTConga4__Conga_Composer_Settings__c if it exists.
    09:47:59: Rename previous table from APXTConga4__Conga_Composer_Settings__c_Previous to APXTConga4__Conga_Composer_Settings__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:47:59: Create primary key on APXTConga4__Conga_Composer_Settings__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Staging__Tag
    09:47:59: Drop APXTConga4__Conga_Email_Staging__Tag_Previous if it exists.
    09:47:59: Create APXTConga4__Conga_Email_Staging__Tag_Previous with new structure.
    09:47:59: Run the DBAmp.exe program.
    09:47:59: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:47:59: Populating local table APXTConga4__Conga_Email_Staging__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:00: DBAmp is using the SQL Native Client.
    09:48:00: Opening SQL Server rowset
    09:48:00: 0 rows copied.
    09:48:01: Drop APXTConga4__Conga_Email_Staging__Tag if it exists.
    09:48:01: Rename previous table from APXTConga4__Conga_Email_Staging__Tag_Previous to APXTConga4__Conga_Email_Staging__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:01: Create primary key on APXTConga4__Conga_Email_Staging__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Staging__c
    09:48:01: Drop APXTConga4__Conga_Email_Staging__c_Previous if it exists.
    09:48:01: Create APXTConga4__Conga_Email_Staging__c_Previous with new structure.
    09:48:01: Run the DBAmp.exe program.
    09:48:01: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:01: Populating local table APXTConga4__Conga_Email_Staging__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:01: DBAmp is using the SQL Native Client.
    09:48:01: Opening SQL Server rowset
    09:48:02: 0 rows copied.
    09:48:02: Drop APXTConga4__Conga_Email_Staging__c if it exists.
    09:48:02: Rename previous table from APXTConga4__Conga_Email_Staging__c_Previous to APXTConga4__Conga_Email_Staging__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:02: Create primary key on APXTConga4__Conga_Email_Staging__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Template__Tag
    09:48:02: Drop APXTConga4__Conga_Email_Template__Tag_Previous if it exists.
    09:48:02: Create APXTConga4__Conga_Email_Template__Tag_Previous with new structure.
    09:48:02: Run the DBAmp.exe program.
    09:48:02: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:02: Populating local table APXTConga4__Conga_Email_Template__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:03: DBAmp is using the SQL Native Client.
    09:48:03: Opening SQL Server rowset
    09:48:03: 0 rows copied.
    09:48:03: Drop APXTConga4__Conga_Email_Template__Tag if it exists.
    09:48:03: Rename previous table from APXTConga4__Conga_Email_Template__Tag_Previous to APXTConga4__Conga_Email_Template__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:03: Create primary key on APXTConga4__Conga_Email_Template__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Template__c
    09:48:03: Drop APXTConga4__Conga_Email_Template__c_Previous if it exists.
    09:48:03: Create APXTConga4__Conga_Email_Template__c_Previous with new structure.
    09:48:03: Run the DBAmp.exe program.
    09:48:03: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:03: Populating local table APXTConga4__Conga_Email_Template__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:04: DBAmp is using the SQL Native Client.
    09:48:04: Opening SQL Server rowset
    09:48:05: 0 rows copied.
    09:48:05: Drop APXTConga4__Conga_Email_Template__c if it exists.
    09:48:05: Rename previous table from APXTConga4__Conga_Email_Template__c_Previous to APXTConga4__Conga_Email_Template__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:05: Create primary key on APXTConga4__Conga_Email_Template__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Template__Tag
    09:48:05: Drop APXTConga4__Conga_Template__Tag_Previous if it exists.
    09:48:05: Create APXTConga4__Conga_Template__Tag_Previous with new structure.
    09:48:05: Run the DBAmp.exe program.
    09:48:05: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:05: Populating local table APXTConga4__Conga_Template__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:05: DBAmp is using the SQL Native Client.
    09:48:05: Opening SQL Server rowset
    09:48:06: 0 rows copied.
    09:48:06: Drop APXTConga4__Conga_Template__Tag if it exists.
    09:48:06: Rename previous table from APXTConga4__Conga_Template__Tag_Previous to APXTConga4__Conga_Template__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:06: Create primary key on APXTConga4__Conga_Template__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Template__c
    09:48:06: Drop APXTConga4__Conga_Template__c_Previous if it exists.
    09:48:06: Create APXTConga4__Conga_Template__c_Previous with new structure.
    09:48:06: Run the DBAmp.exe program.
    09:48:06: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:06: Populating local table APXTConga4__Conga_Template__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:07: DBAmp is using the SQL Native Client.
    09:48:07: Opening SQL Server rowset
    09:48:08: 1 rows copied.
    09:48:08: Drop APXTConga4__Conga_Template__c if it exists.
    09:48:08: Rename previous table from APXTConga4__Conga_Template__c_Previous to APXTConga4__Conga_Template__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:08: Create primary key on APXTConga4__Conga_Template__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account
    09:48:08: Drop Account_Previous if it exists.
    09:48:08: Create Account_Previous with new structure.
    09:48:08: Run the DBAmp.exe program.
    09:48:08: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:08: Populating local table Account_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:08: DBAmp is using the SQL Native Client.
    09:48:08: Opening SQL Server rowset
    09:48:49: 13492 rows copied.
    09:48:49: Drop Account if it exists.
    09:48:49: Rename previous table from Account_Previous to Account
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:49: Create primary key on Account
    09:48:49: Error occurred creating primary key for table.
    09:48:49: Error: Could not create constraint. See previous errors.
    --- Ending SF_Replicate. Operation FAILED.
    Error: SF_Replicate failed for table Account
    Error 50000, Severity 16, State 1, Line 252
    --- Ending SF_Replicate. Operation FAILED.
    --- Starting SF_Replicate for AccountContactRole
    09:48:49: Drop AccountContactRole_Previous if it exists.
    09:48:49: Create AccountContactRole_Previous with new structure.
    09:48:49: Run the DBAmp.exe program.
    09:48:49: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:49: Populating local table AccountContactRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:50: DBAmp is using the SQL Native Client.
    09:48:50: Opening SQL Server rowset
    09:48:53: 0 rows copied.
    09:48:53: Drop AccountContactRole if it exists.
    09:48:53: Rename previous table from AccountContactRole_Previous to AccountContactRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:48:53: Create primary key on AccountContactRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountHistory
    09:48:53: Drop AccountHistory_Previous if it exists.
    09:48:53: Create AccountHistory_Previous with new structure.
    09:48:53: Run the DBAmp.exe program.
    09:48:53: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:48:53: Populating local table AccountHistory_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:48:53: DBAmp is using the SQL Native Client.
    09:48:53: Opening SQL Server rowset
    09:49:00: 2334 rows copied.
    09:49:00: Drop AccountHistory if it exists.
    09:49:00: Rename previous table from AccountHistory_Previous to AccountHistory
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:00: Create primary key on AccountHistory
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountPartner
    09:49:00: Drop AccountPartner_Previous if it exists.
    09:49:00: Create AccountPartner_Previous with new structure.
    09:49:00: Run the DBAmp.exe program.
    09:49:00: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:00: Populating local table AccountPartner_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:00: DBAmp is using the SQL Native Client.
    09:49:00: Opening SQL Server rowset
    09:49:01: 0 rows copied.
    09:49:01: Drop AccountPartner if it exists.
    09:49:01: Rename previous table from AccountPartner_Previous to AccountPartner
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:01: Create primary key on AccountPartner
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountShare
    09:49:01: Drop AccountShare_Previous if it exists.
    09:49:01: Create AccountShare_Previous with new structure.
    09:49:01: Run the DBAmp.exe program.
    09:49:01: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:01: Populating local table AccountShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:02: DBAmp is using the SQL Native Client.
    09:49:02: Opening SQL Server rowset
    09:49:40: 203452 rows copied.
    09:49:40: Drop AccountShare if it exists.
    09:49:40: Rename previous table from AccountShare_Previous to AccountShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:40: Create primary key on AccountShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountTag
    09:49:40: Drop AccountTag_Previous if it exists.
    09:49:40: Create AccountTag_Previous with new structure.
    09:49:40: Run the DBAmp.exe program.
    09:49:40: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:40: Populating local table AccountTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:41: DBAmp is using the SQL Native Client.
    09:49:41: Opening SQL Server rowset
    09:49:41: 155 rows copied.
    09:49:41: Drop AccountTag if it exists.
    09:49:41: Rename previous table from AccountTag_Previous to AccountTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:41: Create primary key on AccountTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountTeamMember
    09:49:41: Drop AccountTeamMember_Previous if it exists.
    09:49:41: Create AccountTeamMember_Previous with new structure.
    09:49:41: Run the DBAmp.exe program.
    09:49:42: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:42: Populating local table AccountTeamMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:42: DBAmp is using the SQL Native Client.
    09:49:42: Opening SQL Server rowset
    09:49:46: 1596 rows copied.
    09:49:46: Drop AccountTeamMember if it exists.
    09:49:46: Rename previous table from AccountTeamMember_Previous to AccountTeamMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:46: Create primary key on AccountTeamMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account_Products__Tag
    09:49:46: Drop Account_Products__Tag_Previous if it exists.
    09:49:46: Create Account_Products__Tag_Previous with new structure.
    09:49:46: Run the DBAmp.exe program.
    09:49:46: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:46: Populating local table Account_Products__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:46: DBAmp is using the SQL Native Client.
    09:49:46: Opening SQL Server rowset
    09:49:47: 0 rows copied.
    09:49:47: Drop Account_Products__Tag if it exists.
    09:49:47: Rename previous table from Account_Products__Tag_Previous to Account_Products__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:47: Create primary key on Account_Products__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account_Products__c
    09:49:47: Drop Account_Products__c_Previous if it exists.
    09:49:47: Create Account_Products__c_Previous with new structure.
    09:49:47: Run the DBAmp.exe program.
    09:49:47: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:47: Populating local table Account_Products__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:47: DBAmp is using the SQL Native Client.
    09:49:47: Opening SQL Server rowset
    09:49:48: 0 rows copied.
    09:49:48: Drop Account_Products__c if it exists.
    09:49:48: Rename previous table from Account_Products__c_Previous to Account_Products__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:48: Create primary key on Account_Products__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AdditionalNumber
    09:49:48: Drop AdditionalNumber_Previous if it exists.
    09:49:48: Create AdditionalNumber_Previous with new structure.
    09:49:48: Run the DBAmp.exe program.
    09:49:48: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:48: Populating local table AdditionalNumber_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:49: DBAmp is using the SQL Native Client.
    09:49:49: Opening SQL Server rowset
    09:49:49: 0 rows copied.
    09:49:49: Drop AdditionalNumber if it exists.
    09:49:49: Rename previous table from AdditionalNumber_Previous to AdditionalNumber
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:49:49: Create primary key on AdditionalNumber
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__History
    09:49:49: Drop Analytical_Snapshot__History_Previous if it exists.
    09:49:49: Create Analytical_Snapshot__History_Previous with new structure.
    09:49:50: Run the DBAmp.exe program.
    09:49:50: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:49:50: Populating local table Analytical_Snapshot__History_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:49:50: DBAmp is using the SQL Native Client.
    09:49:50: Opening SQL Server rowset
    09:50:14: 89353 rows copied.
    09:50:14: Drop Analytical_Snapshot__History if it exists.
    09:50:14: Rename previous table from Analytical_Snapshot__History_Previous to Analytical_Snapshot__History
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:50:14: Create primary key on Analytical_Snapshot__History
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__Tag
    09:50:14: Drop Analytical_Snapshot__Tag_Previous if it exists.
    09:50:14: Create Analytical_Snapshot__Tag_Previous with new structure.
    09:50:14: Run the DBAmp.exe program.
    09:50:14: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:50:14: Populating local table Analytical_Snapshot__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:50:15: DBAmp is using the SQL Native Client.
    09:50:15: Opening SQL Server rowset
    09:50:16: 0 rows copied.
    09:50:16: Drop Analytical_Snapshot__Tag if it exists.
    09:50:16: Rename previous table from Analytical_Snapshot__Tag_Previous to Analytical_Snapshot__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:50:16: Create primary key on Analytical_Snapshot__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__c
    09:50:16: Drop Analytical_Snapshot__c_Previous if it exists.
    09:50:16: Create Analytical_Snapshot__c_Previous with new structure.
    09:50:16: Run the DBAmp.exe program.
    09:50:16: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:50:16: Populating local table Analytical_Snapshot__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:50:16: DBAmp is using the SQL Native Client.
    09:50:16: Opening SQL Server rowset
    09:51:12: 89353 rows copied.
    09:51:12: Drop Analytical_Snapshot__c if it exists.
    09:51:12: Rename previous table from Analytical_Snapshot__c_Previous to Analytical_Snapshot__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:12: Create primary key on Analytical_Snapshot__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexClass
    09:51:13: Drop ApexClass_Previous if it exists.
    09:51:13: Create ApexClass_Previous with new structure.
    09:51:13: Run the DBAmp.exe program.
    09:51:13: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:13: Populating local table ApexClass_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:13: DBAmp is using the SQL Native Client.
    09:51:13: Opening SQL Server rowset
    09:51:16: 82 rows copied.
    09:51:16: Drop ApexClass if it exists.
    09:51:16: Rename previous table from ApexClass_Previous to ApexClass
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:16: Create primary key on ApexClass
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexComponent
    09:51:16: Drop ApexComponent_Previous if it exists.
    09:51:16: Create ApexComponent_Previous with new structure.
    09:51:16: Run the DBAmp.exe program.
    09:51:16: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:16: Populating local table ApexComponent_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:17: DBAmp is using the SQL Native Client.
    09:51:17: Opening SQL Server rowset
    09:51:18: 3 rows copied.
    09:51:18: Drop ApexComponent if it exists.
    09:51:18: Rename previous table from ApexComponent_Previous to ApexComponent
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:18: Create primary key on ApexComponent
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexLog
    09:51:18: Drop ApexLog_Previous if it exists.
    09:51:18: Create ApexLog_Previous with new structure.
    09:51:18: Run the DBAmp.exe program.
    09:51:18: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:18: Populating local table ApexLog_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:18: DBAmp is using the SQL Native Client.
    09:51:18: Opening SQL Server rowset
    09:51:19: 60 rows copied.
    09:51:19: Drop ApexLog if it exists.
    09:51:19: Rename previous table from ApexLog_Previous to ApexLog
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:19: Create primary key on ApexLog
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexPage
    09:51:19: Drop ApexPage_Previous if it exists.
    09:51:19: Create ApexPage_Previous with new structure.
    09:51:19: Run the DBAmp.exe program.
    09:51:19: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:19: Populating local table ApexPage_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:20: DBAmp is using the SQL Native Client.
    09:51:20: Opening SQL Server rowset
    09:51:24: 91 rows copied.
    09:51:24: Drop ApexPage if it exists.
    09:51:24: Rename previous table from ApexPage_Previous to ApexPage
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:24: Create primary key on ApexPage
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTestQueueItem
    09:51:24: Drop ApexTestQueueItem_Previous if it exists.
    09:51:24: Create ApexTestQueueItem_Previous with new structure.
    09:51:24: Run the DBAmp.exe program.
    09:51:24: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:24: Populating local table ApexTestQueueItem_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:25: DBAmp is using the SQL Native Client.
    09:51:25: Opening SQL Server rowset
    09:51:25: 0 rows copied.
    09:51:25: Drop ApexTestQueueItem if it exists.
    09:51:25: Rename previous table from ApexTestQueueItem_Previous to ApexTestQueueItem
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:25: Create primary key on ApexTestQueueItem
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTestResult
    09:51:25: Drop ApexTestResult_Previous if it exists.
    09:51:25: Create ApexTestResult_Previous with new structure.
    09:51:25: Run the DBAmp.exe program.
    09:51:25: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:25: Populating local table ApexTestResult_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:26: DBAmp is using the SQL Native Client.
    09:51:26: Opening SQL Server rowset
    09:51:26: 0 rows copied.
    09:51:27: Drop ApexTestResult if it exists.
    09:51:27: Rename previous table from ApexTestResult_Previous to ApexTestResult
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:27: Create primary key on ApexTestResult
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTrigger
    09:51:27: Drop ApexTrigger_Previous if it exists.
    09:51:27: Create ApexTrigger_Previous with new structure.
    09:51:27: Run the DBAmp.exe program.
    09:51:27: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:27: Populating local table ApexTrigger_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:27: DBAmp is using the SQL Native Client.
    09:51:27: Opening SQL Server rowset
    09:51:28: 12 rows copied.
    09:51:28: Drop ApexTrigger if it exists.
    09:51:28: Rename previous table from ApexTrigger_Previous to ApexTrigger
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:28: Create primary key on ApexTrigger
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AppMenuItem
    09:51:28: Drop AppMenuItem_Previous if it exists.
    09:51:28: Create AppMenuItem_Previous with new structure.
    09:51:28: Run the DBAmp.exe program.
    09:51:28: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:28: Populating local table AppMenuItem_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:29: DBAmp is using the SQL Native Client.
    09:51:29: Opening SQL Server rowset
    09:51:30: 29 rows copied.
    09:51:30: Drop AppMenuItem if it exists.
    09:51:30: Rename previous table from AppMenuItem_Previous to AppMenuItem
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:30: Create primary key on AppMenuItem
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Approval
    09:51:30: Drop Approval_Previous if it exists.
    09:51:30: Create Approval_Previous with new structure.
    09:51:30: Run the DBAmp.exe program.
    09:51:30: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:30: Populating local table Approval_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:31: DBAmp is using the SQL Native Client.
    09:51:31: Opening SQL Server rowset
    09:51:31: 0 rows copied.
    09:51:31: Drop Approval if it exists.
    09:51:31: Rename previous table from Approval_Previous to Approval
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:31: Create primary key on Approval
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Asset
    09:51:31: Drop Asset_Previous if it exists.
    09:51:31: Create Asset_Previous with new structure.
    09:51:31: Run the DBAmp.exe program.
    09:51:31: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:31: Populating local table Asset_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:32: DBAmp is using the SQL Native Client.
    09:51:32: Opening SQL Server rowset
    09:51:33: 0 rows copied.
    09:51:33: Drop Asset if it exists.
    09:51:33: Rename previous table from Asset_Previous to Asset
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:33: Create primary key on Asset
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AssetTag
    09:51:33: Drop AssetTag_Previous if it exists.
    09:51:33: Create AssetTag_Previous with new structure.
    09:51:33: Run the DBAmp.exe program.
    09:51:33: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:33: Populating local table AssetTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:34: DBAmp is using the SQL Native Client.
    09:51:34: Opening SQL Server rowset
    09:51:34: 0 rows copied.
    09:51:34: Drop AssetTag if it exists.
    09:51:34: Rename previous table from AssetTag_Previous to AssetTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:34: Create primary key on AssetTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AssignmentRule
    09:51:34: Drop AssignmentRule_Previous if it exists.
    09:51:34: Create AssignmentRule_Previous with new structure.
    09:51:34: Run the DBAmp.exe program.
    09:51:34: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:34: Populating local table AssignmentRule_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:35: DBAmp is using the SQL Native Client.
    09:51:35: Opening SQL Server rowset
    09:51:36: 0 rows copied.
    09:51:36: Drop AssignmentRule if it exists.
    09:51:36: Rename previous table from AssignmentRule_Previous to AssignmentRule
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:36: Create primary key on AssignmentRule
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AsyncApexJob
    09:51:36: Drop AsyncApexJob_Previous if it exists.
    09:51:36: Create AsyncApexJob_Previous with new structure.
    09:51:36: Run the DBAmp.exe program.
    09:51:36: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:36: Populating local table AsyncApexJob_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:36: DBAmp is using the SQL Native Client.
    09:51:36: Opening SQL Server rowset
    09:51:37: 0 rows copied.
    09:51:37: Drop AsyncApexJob if it exists.
    09:51:37: Rename previous table from AsyncApexJob_Previous to AsyncApexJob
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:37: Create primary key on AsyncApexJob
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Attachment
    09:51:37: Drop Attachment_Previous if it exists.
    09:51:37: Create Attachment_Previous with new structure.
    09:51:37: Run the DBAmp.exe program.
    09:51:37: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:37: Populating local table Attachment_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:38: DBAmp is using the SQL Native Client.
    09:51:38: Opening SQL Server rowset
    09:51:50: 34867 rows copied.
    09:51:50: Drop Attachment if it exists.
    09:51:50: Rename previous table from Attachment_Previous to Attachment
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:50: Create primary key on Attachment
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AuthProvider
    09:51:50: Drop AuthProvider_Previous if it exists.
    09:51:50: Create AuthProvider_Previous with new structure.
    09:51:50: Run the DBAmp.exe program.
    09:51:50: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:50: Populating local table AuthProvider_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:51: DBAmp is using the SQL Native Client.
    09:51:51: Opening SQL Server rowset
    09:51:51: 0 rows copied.
    09:51:51: Drop AuthProvider if it exists.
    09:51:52: Rename previous table from AuthProvider_Previous to AuthProvider
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:52: Create primary key on AuthProvider
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Bookmark
    09:51:52: Drop Bookmark_Previous if it exists.
    09:51:52: Create Bookmark_Previous with new structure.
    09:51:52: Run the DBAmp.exe program.
    09:51:52: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:52: Populating local table Bookmark_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:52: DBAmp is using the SQL Native Client.
    09:51:52: Opening SQL Server rowset
    09:51:53: 0 rows copied.
    09:51:53: Drop Bookmark if it exists.
    09:51:53: Rename previous table from Bookmark_Previous to Bookmark
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:53: Create primary key on Bookmark
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BrandTemplate
    09:51:53: Drop BrandTemplate_Previous if it exists.
    09:51:53: Create BrandTemplate_Previous with new structure.
    09:51:53: Run the DBAmp.exe program.
    09:51:53: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:53: Populating local table BrandTemplate_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:53: DBAmp is using the SQL Native Client.
    09:51:53: Opening SQL Server rowset
    09:51:54: 4 rows copied.
    09:51:54: Drop BrandTemplate if it exists.
    09:51:54: Rename previous table from BrandTemplate_Previous to BrandTemplate
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:54: Create primary key on BrandTemplate
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BusinessHours
    09:51:54: Drop BusinessHours_Previous if it exists.
    09:51:54: Create BusinessHours_Previous with new structure.
    09:51:54: Run the DBAmp.exe program.
    09:51:54: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:54: Populating local table BusinessHours_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:55: DBAmp is using the SQL Native Client.
    09:51:55: Opening SQL Server rowset
    09:51:56: 1 rows copied.
    09:51:56: Drop BusinessHours if it exists.
    09:51:56: Rename previous table from BusinessHours_Previous to BusinessHours
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:56: Create primary key on BusinessHours
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BusinessProcess
    09:51:56: Drop BusinessProcess_Previous if it exists.
    09:51:56: Create BusinessProcess_Previous with new structure.
    09:51:56: Run the DBAmp.exe program.
    09:51:56: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:56: Populating local table BusinessProcess_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:56: DBAmp is using the SQL Native Client.
    09:51:56: Opening SQL Server rowset
    09:51:57: 2 rows copied.
    09:51:57: Drop BusinessProcess if it exists.
    09:51:57: Rename previous table from BusinessProcess_Previous to BusinessProcess
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:57: Create primary key on BusinessProcess
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Buying_Influence__Tag
    09:51:57: Drop Buying_Influence__Tag_Previous if it exists.
    09:51:57: Create Buying_Influence__Tag_Previous with new structure.
    09:51:57: Run the DBAmp.exe program.
    09:51:57: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:57: Populating local table Buying_Influence__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:58: DBAmp is using the SQL Native Client.
    09:51:58: Opening SQL Server rowset
    09:51:58: 0 rows copied.
    09:51:58: Drop Buying_Influence__Tag if it exists.
    09:51:58: Rename previous table from Buying_Influence__Tag_Previous to Buying_Influence__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:51:58: Create primary key on Buying_Influence__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Buying_Influence__c
    09:51:58: Drop Buying_Influence__c_Previous if it exists.
    09:51:58: Create Buying_Influence__c_Previous with new structure.
    09:51:58: Run the DBAmp.exe program.
    09:51:58: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:51:58: Populating local table Buying_Influence__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:51:59: DBAmp is using the SQL Native Client.
    09:51:59: Opening SQL Server rowset
    09:52:11: 1969 rows copied.
    09:52:11: Drop Buying_Influence__c if it exists.
    09:52:11: Rename previous table from Buying_Influence__c_Previous to Buying_Influence__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:11: Create primary key on Buying_Influence__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CallCenter
    09:52:11: Drop CallCenter_Previous if it exists.
    09:52:11: Create CallCenter_Previous with new structure.
    09:52:11: Run the DBAmp.exe program.
    09:52:11: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:11: Populating local table CallCenter_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:12: DBAmp is using the SQL Native Client.
    09:52:12: Opening SQL Server rowset
    09:52:14: 0 rows copied.
    09:52:14: Drop CallCenter if it exists.
    09:52:14: Rename previous table from CallCenter_Previous to CallCenter
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:14: Create primary key on CallCenter
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__Share
    09:52:14: Drop Call_Planner_2__Share_Previous if it exists.
    09:52:14: Create Call_Planner_2__Share_Previous with new structure.
    09:52:14: Run the DBAmp.exe program.
    09:52:14: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:14: Populating local table Call_Planner_2__Share_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:15: DBAmp is using the SQL Native Client.
    09:52:15: Opening SQL Server rowset
    09:52:16: 335 rows copied.
    09:52:17: Drop Call_Planner_2__Share if it exists.
    09:52:17: Rename previous table from Call_Planner_2__Share_Previous to Call_Planner_2__Share
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:17: Create primary key on Call_Planner_2__Share
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__Tag
    09:52:17: Drop Call_Planner_2__Tag_Previous if it exists.
    09:52:17: Create Call_Planner_2__Tag_Previous with new structure.
    09:52:17: Run the DBAmp.exe program.
    09:52:17: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:17: Populating local table Call_Planner_2__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:17: DBAmp is using the SQL Native Client.
    09:52:17: Opening SQL Server rowset
    09:52:18: 0 rows copied.
    09:52:18: Drop Call_Planner_2__Tag if it exists.
    09:52:18: Rename previous table from Call_Planner_2__Tag_Previous to Call_Planner_2__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:18: Create primary key on Call_Planner_2__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__c
    09:52:18: Drop Call_Planner_2__c_Previous if it exists.
    09:52:18: Create Call_Planner_2__c_Previous with new structure.
    09:52:18: Run the DBAmp.exe program.
    09:52:18: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:18: Populating local table Call_Planner_2__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:19: DBAmp is using the SQL Native Client.
    09:52:19: Opening SQL Server rowset
    09:52:21: 140 rows copied.
    09:52:21: Drop Call_Planner_2__c if it exists.
    09:52:21: Rename previous table from Call_Planner_2__c_Previous to Call_Planner_2__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:21: Create primary key on Call_Planner_2__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Campaign
    09:52:21: Drop Campaign_Previous if it exists.
    09:52:21: Create Campaign_Previous with new structure.
    09:52:21: Run the DBAmp.exe program.
    09:52:21: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:21: Populating local table Campaign_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:21: DBAmp is using the SQL Native Client.
    09:52:21: Opening SQL Server rowset
    09:52:22: 1 rows copied.
    09:52:22: Drop Campaign if it exists.
    09:52:22: Rename previous table from Campaign_Previous to Campaign
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:22: Create primary key on Campaign
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignMember
    09:52:22: Drop CampaignMember_Previous if it exists.
    09:52:22: Create CampaignMember_Previous with new structure.
    09:52:22: Run the DBAmp.exe program.
    09:52:22: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:22: Populating local table CampaignMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:23: DBAmp is using the SQL Native Client.
    09:52:23: Opening SQL Server rowset
    09:52:24: 0 rows copied.
    09:52:24: Drop CampaignMember if it exists.
    09:52:24: Rename previous table from CampaignMember_Previous to CampaignMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:24: Create primary key on CampaignMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignMemberStatus
    09:52:24: Drop CampaignMemberStatus_Previous if it exists.
    09:52:24: Create CampaignMemberStatus_Previous with new structure.
    09:52:24: Run the DBAmp.exe program.
    09:52:24: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:24: Populating local table CampaignMemberStatus_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:24: DBAmp is using the SQL Native Client.
    09:52:24: Opening SQL Server rowset
    09:52:25: 2 rows copied.
    09:52:25: Drop CampaignMemberStatus if it exists.
    09:52:25: Rename previous table from CampaignMemberStatus_Previous to CampaignMemberStatus
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:25: Create primary key on CampaignMemberStatus
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignShare
    09:52:25: Drop CampaignShare_Previous if it exists.
    09:52:25: Create CampaignShare_Previous with new structure.
    09:52:25: Run the DBAmp.exe program.
    09:52:25: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:25: Populating local table CampaignShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:26: DBAmp is using the SQL Native Client.
    09:52:26: Opening SQL Server rowset
    09:52:26: 0 rows copied.
    09:52:26: Drop CampaignShare if it exists.
    09:52:26: Rename previous table from CampaignShare_Previous to CampaignShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:26: Create primary key on CampaignShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignTag
    09:52:26: Drop CampaignTag_Previous if it exists.
    09:52:26: Create CampaignTag_Previous with new structure.
    09:52:26: Run the DBAmp.exe program.
    09:52:26: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:26: Populating local table CampaignTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:27: DBAmp is using the SQL Native Client.
    09:52:27: Opening SQL Server rowset
    09:52:28: 0 rows copied.
    09:52:28: Drop CampaignTag if it exists.
    09:52:28: Rename previous table from CampaignTag_Previous to CampaignTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:28: Create primary key on CampaignTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Case
    09:52:28: Drop Case_Previous if it exists.
    09:52:28: Create Case_Previous with new structure.
    09:52:28: Run the DBAmp.exe program.
    09:52:28: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:28: Populating local table Case_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:28: DBAmp is using the SQL Native Client.
    09:52:28: Opening SQL Server rowset
    09:52:29: 3 rows copied.
    09:52:29: Drop Case if it exists.
    09:52:29: Rename previous table from Case_Previous to Case
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:29: Create primary key on Case
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseComment
    09:52:29: Drop CaseComment_Previous if it exists.
    09:52:29: Create CaseComment_Previous with new structure.
    09:52:29: Run the DBAmp.exe program.
    09:52:29: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:29: Populating local table CaseComment_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:30: DBAmp is using the SQL Native Client.
    09:52:30: Opening SQL Server rowset
    09:52:31: 0 rows copied.
    09:52:31: Drop CaseComment if it exists.
    09:52:31: Rename previous table from CaseComment_Previous to CaseComment
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:31: Create primary key on CaseComment
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseContactRole
    09:52:31: Drop CaseContactRole_Previous if it exists.
    09:52:31: Create CaseContactRole_Previous with new structure.
    09:52:31: Run the DBAmp.exe program.
    09:52:31: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:31: Populating local table CaseContactRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:31: DBAmp is using the SQL Native Client.
    09:52:31: Opening SQL Server rowset
    09:52:32: 0 rows copied.
    09:52:32: Drop CaseContactRole if it exists.
    09:52:32: Rename previous table from CaseContactRole_Previous to CaseContactRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:32: Create primary key on CaseContactRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseHistory
    09:52:32: Drop CaseHistory_Previous if it exists.
    09:52:32: Create CaseHistory_Previous with new structure.
    09:52:32: Run the DBAmp.exe program.
    09:52:32: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:32: Populating local table CaseHistory_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:32: DBAmp is using the SQL Native Client.
    09:52:32: Opening SQL Server rowset
    09:52:33: 3 rows copied.
    09:52:33: Drop CaseHistory if it exists.
    09:52:33: Rename previous table from CaseHistory_Previous to CaseHistory
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:33: Create primary key on CaseHistory
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseShare
    09:52:33: Drop CaseShare_Previous if it exists.
    09:52:33: Create CaseShare_Previous with new structure.
    09:52:33: Run the DBAmp.exe program.
    09:52:33: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:33: Populating local table CaseShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:34: DBAmp is using the SQL Native Client.
    09:52:34: Opening SQL Server rowset
    09:52:35: 6 rows copied.
    09:52:35: Drop CaseShare if it exists.
    09:52:35: Rename previous table from CaseShare_Previous to CaseShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:35: Create primary key on CaseShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseSolution
    09:52:35: Drop CaseSolution_Previous if it exists.
    09:52:35: Create CaseSolution_Previous with new structure.
    09:52:35: Run the DBAmp.exe program.
    09:52:35: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:35: Populating local table CaseSolution_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:35: DBAmp is using the SQL Native Client.
    09:52:35: Opening SQL Server rowset
    09:52:36: 0 rows copied.
    09:52:36: Drop CaseSolution if it exists.
    09:52:36: Rename previous table from CaseSolution_Previous to CaseSolution
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:36: Create primary key on CaseSolution
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseStatus
    09:52:36: Drop CaseStatus_Previous if it exists.
    09:52:36: Create CaseStatus_Previous with new structure.
    09:52:36: Run the DBAmp.exe program.
    09:52:36: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:36: Populating local table CaseStatus_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:37: DBAmp is using the SQL Native Client.
    09:52:37: Opening SQL Server rowset
    09:52:37: 4 rows copied.
    09:52:37: Drop CaseStatus if it exists.
    09:52:37: Rename previous table from CaseStatus_Previous to CaseStatus
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:37: Create primary key on CaseStatus
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTag
    09:52:37: Drop CaseTag_Previous if it exists.
    09:52:37: Create CaseTag_Previous with new structure.
    09:52:37: Run the DBAmp.exe program.
    09:52:37: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:37: Populating local table CaseTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:38: DBAmp is using the SQL Native Client.
    09:52:38: Opening SQL Server rowset
    09:52:39: 0 rows copied.
    09:52:39: Drop CaseTag if it exists.
    09:52:39: Rename previous table from CaseTag_Previous to CaseTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:39: Create primary key on CaseTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamMember
    09:52:39: Drop CaseTeamMember_Previous if it exists.
    09:52:39: Create CaseTeamMember_Previous with new structure.
    09:52:39: Run the DBAmp.exe program.
    09:52:39: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:39: Populating local table CaseTeamMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:39: DBAmp is using the SQL Native Client.
    09:52:39: Opening SQL Server rowset
    09:52:40: 0 rows copied.
    09:52:40: Drop CaseTeamMember if it exists.
    09:52:40: Rename previous table from CaseTeamMember_Previous to CaseTeamMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:40: Create primary key on CaseTeamMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamRole
    09:52:40: Drop CaseTeamRole_Previous if it exists.
    09:52:40: Create CaseTeamRole_Previous with new structure.
    09:52:40: Run the DBAmp.exe program.
    09:52:40: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:40: Populating local table CaseTeamRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:40: DBAmp is using the SQL Native Client.
    09:52:40: Opening SQL Server rowset
    09:52:41: 0 rows copied.
    09:52:41: Drop CaseTeamRole if it exists.
    09:52:41: Rename previous table from CaseTeamRole_Previous to CaseTeamRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:41: Create primary key on CaseTeamRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplate
    09:52:41: Drop CaseTeamTemplate_Previous if it exists.
    09:52:41: Create CaseTeamTemplate_Previous with new structure.
    09:52:41: Run the DBAmp.exe program.
    09:52:41: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:41: Populating local table CaseTeamTemplate_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:42: DBAmp is using the SQL Native Client.
    09:52:42: Opening SQL Server rowset
    09:52:42: 0 rows copied.
    09:52:42: Drop CaseTeamTemplate if it exists.
    09:52:42: Rename previous table from CaseTeamTemplate_Previous to CaseTeamTemplate
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:42: Create primary key on CaseTeamTemplate
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplateMember
    09:52:42: Drop CaseTeamTemplateMember_Previous if it exists.
    09:52:42: Create CaseTeamTemplateMember_Previous with new structure.
    09:52:42: Run the DBAmp.exe program.
    09:52:42: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:42: Populating local table CaseTeamTemplateMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:43: DBAmp is using the SQL Native Client.
    09:52:43: Opening SQL Server rowset
    09:52:44: 0 rows copied.
    09:52:44: Drop CaseTeamTemplateMember if it exists.
    09:52:44: Rename previous table from CaseTeamTemplateMember_Previous to CaseTeamTemplateMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:44: Create primary key on CaseTeamTemplateMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplateRecord
    09:52:44: Drop CaseTeamTemplateRecord_Previous if it exists.
    09:52:44: Create CaseTeamTemplateRecord_Previous with new structure.
    09:52:44: Run the DBAmp.exe program.
    09:52:44: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:44: Populating local table CaseTeamTemplateRecord_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:44: DBAmp is using the SQL Native Client.
    09:52:44: Opening SQL Server rowset
    09:52:45: 0 rows copied.
    09:52:45: Drop CaseTeamTemplateRecord if it exists.
    09:52:45: Rename previous table from CaseTeamTemplateRecord_Previous to CaseTeamTemplateRecord
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:45: Create primary key on CaseTeamTemplateRecord
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CategoryData
    09:52:45: Drop CategoryData_Previous if it exists.
    09:52:45: Create CategoryData_Previous with new structure.
    09:52:45: Run the DBAmp.exe program.
    09:52:45: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:45: Populating local table CategoryData_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:46: DBAmp is using the SQL Native Client.
    09:52:46: Opening SQL Server rowset
    09:52:46: 0 rows copied.
    09:52:46: Drop CategoryData if it exists.
    09:52:46: Rename previous table from CategoryData_Previous to CategoryData
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:46: Create primary key on CategoryData
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CategoryNode
    09:52:46: Drop CategoryNode_Previous if it exists.
    09:52:46: Create CategoryNode_Previous with new structure.
    09:52:46: Run the DBAmp.exe program.
    09:52:46: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:46: Populating local table CategoryNode_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:47: DBAmp is using the SQL Native Client.
    09:52:47: Opening SQL Server rowset
    09:52:48: 0 rows copied.
    09:52:48: Drop CategoryNode if it exists.
    09:52:48: Rename previous table from CategoryNode_Previous to CategoryNode
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:48: Create primary key on CategoryNode
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Channel_Score_Card__History
    09:52:48: Drop Channel_Score_Card__History_Previous if it exists.
    09:52:48: Create Channel_Score_Card__History_Previous with new structure.
    09:52:48: Run the DBAmp.exe program.
    09:52:48: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:48: Populating local table Channel_Score_Card__History_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:48: DBAmp is using the SQL Native Client.
    09:52:48: Opening SQL Server rowset
    09:52:49: 2 rows copied.
    09:52:49: Drop Channel_Score_Card__History if it exists.
    09:52:49: Rename previous table from Channel_Score_Card__History_Previous to Channel_Score_Card__History
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:49: Create primary key on Channel_Score_Card__History
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Channel_Score_Card__Tag
    09:52:49: Drop Channel_Score_Card__Tag_Previous if it exists.
    09:52:49: Create Channel_Score_Card__Tag_Previous with new structure.
    09:52:49: Run the DBAmp.exe program.
    09:52:49: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:49: Populating local table Channel_Score_Card__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:50: DBAmp is using the SQL Native Client.
    09:52:50: Opening SQL Server rowset
    09:52:50: 0 rows copied.
    09:52:50: Drop Channel_Score_Card__Tag if it exists.
    09:52:50: Rename previous table from Channel_Score_Card__Tag_Previous to Channel_Score_Card__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    09:52:50: Create primary key on Channel_Score_Card__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Channel_Score_Card__c
    09:52:50: Drop Channel_Score_Card__c_Previous if it exists.
    09:52:50: Create Channel_Score_Card__c_Previous with new structure.
    09:52:50: Run the DBAmp.exe program.
    09:52:50: DBAmp Bulk Operations. V2.17.6 (c) Copyright 2006-2013 forceAmp.com LLC
    09:52:50: Populating local table Channel_Score_Card__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    09:52:51: DBAmp is using the SQL Native Client.
    09:52:51: Opening SQL Server rowset
    09:52:52: 2 rows copied.
    09:52:52: Drop Channel_Score_Card__c if it exists.
    09:52:52: Rename previous table from Channel_Score_Ca
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • There was a bug in that release where sf_bulkops would "hang" and cause unresponsiveness.

    Could you upgrade to the latest version using the instructions at http://www.forceamp.com/upgrade.htm and then retry the command ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Thanks Bill,

    We will give this is go

    Best regards

    Martin
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Hi Bill,

    We have updated our version of DBAmp but are still getting an error message on the replicate command:

    --- Starting SF_ReplicateAll
    --- Starting SF_Replicate for AG1__Call_Planner__Share
    08:36:49: Drop AG1__Call_Planner__Share_Previous if it exists.
    08:36:49: Create AG1__Call_Planner__Share_Previous with new structure.
    08:36:49: Run the DBAmp.exe program.
    08:36:50: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:36:50: Populating local table AG1__Call_Planner__Share_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:36:55: DBAmp is using the SQL Native Client.
    08:36:55: Opening SQL Server rowset
    08:36:59: 484 rows copied.
    08:36:59: Drop AG1__Call_Planner__Share if it exists.
    08:36:59: Rename previous table from AG1__Call_Planner__Share_Previous to AG1__Call_Planner__Share
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:36:59: Create primary key on AG1__Call_Planner__Share
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AG1__Call_Planner__Tag
    08:36:59: Drop AG1__Call_Planner__Tag_Previous if it exists.
    08:36:59: Create AG1__Call_Planner__Tag_Previous with new structure.
    08:36:59: Run the DBAmp.exe program.
    08:36:59: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:36:59: Populating local table AG1__Call_Planner__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:01: DBAmp is using the SQL Native Client.
    08:37:01: Opening SQL Server rowset
    08:37:02: 0 rows copied.
    08:37:02: Drop AG1__Call_Planner__Tag if it exists.
    08:37:02: Rename previous table from AG1__Call_Planner__Tag_Previous to AG1__Call_Planner__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:02: Create primary key on AG1__Call_Planner__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AG1__Call_Planner__c
    08:37:02: Drop AG1__Call_Planner__c_Previous if it exists.
    08:37:02: Create AG1__Call_Planner__c_Previous with new structure.
    08:37:02: Run the DBAmp.exe program.
    08:37:02: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:02: Populating local table AG1__Call_Planner__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:04: DBAmp is using the SQL Native Client.
    08:37:04: Opening SQL Server rowset
    08:37:06: 178 rows copied.
    08:37:07: Drop AG1__Call_Planner__c if it exists.
    08:37:07: Rename previous table from AG1__Call_Planner__c_Previous to AG1__Call_Planner__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:07: Create primary key on AG1__Call_Planner__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Composer_Settings__Tag
    08:37:07: Drop APXTConga4__Conga_Composer_Settings__Tag_Previous if it exists.
    08:37:07: Create APXTConga4__Conga_Composer_Settings__Tag_Previous with new structure.
    08:37:07: Run the DBAmp.exe program.
    08:37:07: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:07: Populating local table APXTConga4__Conga_Composer_Settings__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:08: DBAmp is using the SQL Native Client.
    08:37:08: Opening SQL Server rowset
    08:37:09: 0 rows copied.
    08:37:09: Drop APXTConga4__Conga_Composer_Settings__Tag if it exists.
    08:37:09: Rename previous table from APXTConga4__Conga_Composer_Settings__Tag_Previous to APXTConga4__Conga_Composer_Settings__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:09: Create primary key on APXTConga4__Conga_Composer_Settings__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Composer_Settings__c
    08:37:09: Drop APXTConga4__Conga_Composer_Settings__c_Previous if it exists.
    08:37:09: Create APXTConga4__Conga_Composer_Settings__c_Previous with new structure.
    08:37:09: Run the DBAmp.exe program.
    08:37:09: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:09: Populating local table APXTConga4__Conga_Composer_Settings__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:11: DBAmp is using the SQL Native Client.
    08:37:11: Opening SQL Server rowset
    08:37:11: 0 rows copied.
    08:37:12: Drop APXTConga4__Conga_Composer_Settings__c if it exists.
    08:37:12: Rename previous table from APXTConga4__Conga_Composer_Settings__c_Previous to APXTConga4__Conga_Composer_Settings__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:12: Create primary key on APXTConga4__Conga_Composer_Settings__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Staging__Tag
    08:37:12: Drop APXTConga4__Conga_Email_Staging__Tag_Previous if it exists.
    08:37:12: Create APXTConga4__Conga_Email_Staging__Tag_Previous with new structure.
    08:37:12: Run the DBAmp.exe program.
    08:37:12: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:12: Populating local table APXTConga4__Conga_Email_Staging__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:13: DBAmp is using the SQL Native Client.
    08:37:13: Opening SQL Server rowset
    08:37:14: 0 rows copied.
    08:37:14: Drop APXTConga4__Conga_Email_Staging__Tag if it exists.
    08:37:14: Rename previous table from APXTConga4__Conga_Email_Staging__Tag_Previous to APXTConga4__Conga_Email_Staging__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:14: Create primary key on APXTConga4__Conga_Email_Staging__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Staging__c
    08:37:14: Drop APXTConga4__Conga_Email_Staging__c_Previous if it exists.
    08:37:14: Create APXTConga4__Conga_Email_Staging__c_Previous with new structure.
    08:37:14: Run the DBAmp.exe program.
    08:37:14: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:14: Populating local table APXTConga4__Conga_Email_Staging__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:16: DBAmp is using the SQL Native Client.
    08:37:16: Opening SQL Server rowset
    08:37:17: 0 rows copied.
    08:37:17: Drop APXTConga4__Conga_Email_Staging__c if it exists.
    08:37:17: Rename previous table from APXTConga4__Conga_Email_Staging__c_Previous to APXTConga4__Conga_Email_Staging__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:17: Create primary key on APXTConga4__Conga_Email_Staging__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Template__Tag
    08:37:17: Drop APXTConga4__Conga_Email_Template__Tag_Previous if it exists.
    08:37:17: Create APXTConga4__Conga_Email_Template__Tag_Previous with new structure.
    08:37:17: Run the DBAmp.exe program.
    08:37:17: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:17: Populating local table APXTConga4__Conga_Email_Template__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:18: DBAmp is using the SQL Native Client.
    08:37:18: Opening SQL Server rowset
    08:37:19: 0 rows copied.
    08:37:19: Drop APXTConga4__Conga_Email_Template__Tag if it exists.
    08:37:19: Rename previous table from APXTConga4__Conga_Email_Template__Tag_Previous to APXTConga4__Conga_Email_Template__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:19: Create primary key on APXTConga4__Conga_Email_Template__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Email_Template__c
    08:37:19: Drop APXTConga4__Conga_Email_Template__c_Previous if it exists.
    08:37:19: Create APXTConga4__Conga_Email_Template__c_Previous with new structure.
    08:37:19: Run the DBAmp.exe program.
    08:37:19: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:19: Populating local table APXTConga4__Conga_Email_Template__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:20: DBAmp is using the SQL Native Client.
    08:37:20: Opening SQL Server rowset
    08:37:21: 0 rows copied.
    08:37:21: Drop APXTConga4__Conga_Email_Template__c if it exists.
    08:37:21: Rename previous table from APXTConga4__Conga_Email_Template__c_Previous to APXTConga4__Conga_Email_Template__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:21: Create primary key on APXTConga4__Conga_Email_Template__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Template__Tag
    08:37:21: Drop APXTConga4__Conga_Template__Tag_Previous if it exists.
    08:37:21: Create APXTConga4__Conga_Template__Tag_Previous with new structure.
    08:37:21: Run the DBAmp.exe program.
    08:37:21: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:21: Populating local table APXTConga4__Conga_Template__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:23: DBAmp is using the SQL Native Client.
    08:37:23: Opening SQL Server rowset
    08:37:24: 0 rows copied.
    08:37:24: Drop APXTConga4__Conga_Template__Tag if it exists.
    08:37:24: Rename previous table from APXTConga4__Conga_Template__Tag_Previous to APXTConga4__Conga_Template__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:24: Create primary key on APXTConga4__Conga_Template__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for APXTConga4__Conga_Template__c
    08:37:24: Drop APXTConga4__Conga_Template__c_Previous if it exists.
    08:37:24: Create APXTConga4__Conga_Template__c_Previous with new structure.
    08:37:24: Run the DBAmp.exe program.
    08:37:24: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:24: Populating local table APXTConga4__Conga_Template__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:25: DBAmp is using the SQL Native Client.
    08:37:25: Opening SQL Server rowset
    08:37:26: 1 rows copied.
    08:37:26: Drop APXTConga4__Conga_Template__c if it exists.
    08:37:26: Rename previous table from APXTConga4__Conga_Template__c_Previous to APXTConga4__Conga_Template__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:26: Create primary key on APXTConga4__Conga_Template__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AcceptedEventRelation
    08:37:26: Drop AcceptedEventRelation_Previous if it exists.
    08:37:26: Create AcceptedEventRelation_Previous with new structure.
    08:37:26: Run the DBAmp.exe program.
    08:37:26: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:26: Populating local table AcceptedEventRelation_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:28: DBAmp is using the SQL Native Client.
    08:37:28: Opening SQL Server rowset
    08:37:31: 290 rows copied.
    08:37:31: Drop AcceptedEventRelation if it exists.
    08:37:31: Rename previous table from AcceptedEventRelation_Previous to AcceptedEventRelation
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:37:31: Create primary key on AcceptedEventRelation
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account
    08:37:31: Drop Account_Previous if it exists.
    08:37:31: Create Account_Previous with new structure.
    08:37:31: Run the DBAmp.exe program.
    08:37:31: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:37:31: Populating local table Account_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:37:33: DBAmp is using the SQL Native Client.
    08:37:33: Opening SQL Server rowset
    08:38:35: 13515 rows copied.
    08:38:35: Drop Account if it exists.
    08:38:35: Rename previous table from Account_Previous to Account
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:38:35: Create primary key on Account
    08:38:35: Error occurred creating primary key for table.
    08:38:35: Error: Could not create constraint. See previous errors.
    --- Ending SF_Replicate. Operation FAILED.
    Error: SF_Replicate failed for table Account
    Error 50000, Severity 16, State 1, Line 252
    --- Ending SF_Replicate. Operation FAILED.
    --- Starting SF_Replicate for AccountContactRole
    08:38:35: Drop AccountContactRole_Previous if it exists.
    08:38:35: Create AccountContactRole_Previous with new structure.
    08:38:35: Run the DBAmp.exe program.
    08:38:35: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:38:35: Populating local table AccountContactRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:38:35: DBAmp is using the SQL Native Client.
    08:38:35: Opening SQL Server rowset
    08:38:38: 0 rows copied.
    08:38:38: Drop AccountContactRole if it exists.
    08:38:38: Rename previous table from AccountContactRole_Previous to AccountContactRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:38:38: Create primary key on AccountContactRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountHistory
    08:38:38: Drop AccountHistory_Previous if it exists.
    08:38:38: Create AccountHistory_Previous with new structure.
    08:38:38: Run the DBAmp.exe program.
    08:38:38: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:38:38: Populating local table AccountHistory_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:38:39: DBAmp is using the SQL Native Client.
    08:38:39: Opening SQL Server rowset
    08:38:46: 2373 rows copied.
    08:38:47: Drop AccountHistory if it exists.
    08:38:47: Rename previous table from AccountHistory_Previous to AccountHistory
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:38:47: Create primary key on AccountHistory
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountPartner
    08:38:47: Drop AccountPartner_Previous if it exists.
    08:38:47: Create AccountPartner_Previous with new structure.
    08:38:47: Run the DBAmp.exe program.
    08:38:47: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:38:47: Populating local table AccountPartner_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:38:48: DBAmp is using the SQL Native Client.
    08:38:48: Opening SQL Server rowset
    08:38:49: 0 rows copied.
    08:38:50: Drop AccountPartner if it exists.
    08:38:50: Rename previous table from AccountPartner_Previous to AccountPartner
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:38:50: Create primary key on AccountPartner
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountShare
    08:38:50: Drop AccountShare_Previous if it exists.
    08:38:50: Create AccountShare_Previous with new structure.
    08:38:50: Run the DBAmp.exe program.
    08:38:50: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:38:50: Populating local table AccountShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:38:51: DBAmp is using the SQL Native Client.
    08:38:51: Opening SQL Server rowset
    08:40:35: 203779 rows copied.
    08:40:35: Drop AccountShare if it exists.
    08:40:35: Rename previous table from AccountShare_Previous to AccountShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:35: Create primary key on AccountShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountTag
    08:40:36: Drop AccountTag_Previous if it exists.
    08:40:36: Create AccountTag_Previous with new structure.
    08:40:37: Run the DBAmp.exe program.
    08:40:37: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:37: Populating local table AccountTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:39: DBAmp is using the SQL Native Client.
    08:40:39: Opening SQL Server rowset
    08:40:40: 155 rows copied.
    08:40:40: Drop AccountTag if it exists.
    08:40:40: Rename previous table from AccountTag_Previous to AccountTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:40: Create primary key on AccountTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AccountTeamMember
    08:40:40: Drop AccountTeamMember_Previous if it exists.
    08:40:40: Create AccountTeamMember_Previous with new structure.
    08:40:40: Run the DBAmp.exe program.
    08:40:40: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:40: Populating local table AccountTeamMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:42: DBAmp is using the SQL Native Client.
    08:40:42: Opening SQL Server rowset
    08:40:45: 1593 rows copied.
    08:40:45: Drop AccountTeamMember if it exists.
    08:40:45: Rename previous table from AccountTeamMember_Previous to AccountTeamMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:45: Create primary key on AccountTeamMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account_Products__Tag
    08:40:45: Drop Account_Products__Tag_Previous if it exists.
    08:40:45: Create Account_Products__Tag_Previous with new structure.
    08:40:45: Run the DBAmp.exe program.
    08:40:45: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:45: Populating local table Account_Products__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:47: DBAmp is using the SQL Native Client.
    08:40:47: Opening SQL Server rowset
    08:40:48: 0 rows copied.
    08:40:48: Drop Account_Products__Tag if it exists.
    08:40:48: Rename previous table from Account_Products__Tag_Previous to Account_Products__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:48: Create primary key on Account_Products__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Account_Products__c
    08:40:48: Drop Account_Products__c_Previous if it exists.
    08:40:48: Create Account_Products__c_Previous with new structure.
    08:40:48: Run the DBAmp.exe program.
    08:40:48: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:48: Populating local table Account_Products__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:49: DBAmp is using the SQL Native Client.
    08:40:49: Opening SQL Server rowset
    08:40:50: 0 rows copied.
    08:40:50: Drop Account_Products__c if it exists.
    08:40:50: Rename previous table from Account_Products__c_Previous to Account_Products__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:50: Create primary key on Account_Products__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AdditionalNumber
    08:40:50: Drop AdditionalNumber_Previous if it exists.
    08:40:50: Create AdditionalNumber_Previous with new structure.
    08:40:50: Run the DBAmp.exe program.
    08:40:50: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:50: Populating local table AdditionalNumber_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:52: DBAmp is using the SQL Native Client.
    08:40:52: Opening SQL Server rowset
    08:40:52: 0 rows copied.
    08:40:53: Drop AdditionalNumber if it exists.
    08:40:53: Rename previous table from AdditionalNumber_Previous to AdditionalNumber
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:40:53: Create primary key on AdditionalNumber
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__History
    08:40:53: Drop Analytical_Snapshot__History_Previous if it exists.
    08:40:53: Create Analytical_Snapshot__History_Previous with new structure.
    08:40:53: Run the DBAmp.exe program.
    08:40:53: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:40:53: Populating local table Analytical_Snapshot__History_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:40:54: DBAmp is using the SQL Native Client.
    08:40:54: Opening SQL Server rowset
    08:41:32: 89353 rows copied.
    08:41:32: Drop Analytical_Snapshot__History if it exists.
    08:41:32: Rename previous table from Analytical_Snapshot__History_Previous to Analytical_Snapshot__History
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:41:32: Create primary key on Analytical_Snapshot__History
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__Tag
    08:41:32: Drop Analytical_Snapshot__Tag_Previous if it exists.
    08:41:32: Create Analytical_Snapshot__Tag_Previous with new structure.
    08:41:33: Run the DBAmp.exe program.
    08:41:33: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:41:33: Populating local table Analytical_Snapshot__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:41:34: DBAmp is using the SQL Native Client.
    08:41:34: Opening SQL Server rowset
    08:41:35: 0 rows copied.
    08:41:35: Drop Analytical_Snapshot__Tag if it exists.
    08:41:35: Rename previous table from Analytical_Snapshot__Tag_Previous to Analytical_Snapshot__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:41:35: Create primary key on Analytical_Snapshot__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Analytical_Snapshot__c
    08:41:35: Drop Analytical_Snapshot__c_Previous if it exists.
    08:41:35: Create Analytical_Snapshot__c_Previous with new structure.
    08:41:36: Run the DBAmp.exe program.
    08:41:36: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:41:36: Populating local table Analytical_Snapshot__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:41:37: DBAmp is using the SQL Native Client.
    08:41:37: Opening SQL Server rowset
    08:42:39: 89353 rows copied.
    08:42:39: Drop Analytical_Snapshot__c if it exists.
    08:42:39: Rename previous table from Analytical_Snapshot__c_Previous to Analytical_Snapshot__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:42:39: Create primary key on Analytical_Snapshot__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Announcement
    08:42:39: Drop Announcement_Previous if it exists.
    08:42:39: Create Announcement_Previous with new structure.
    08:42:40: Run the DBAmp.exe program.
    08:42:40: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:42:40: Populating local table Announcement_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:42:42: DBAmp is using the SQL Native Client.
    08:42:42: Opening SQL Server rowset
    08:42:43: 0 rows copied.
    08:42:43: Drop Announcement if it exists.
    08:42:43: Rename previous table from Announcement_Previous to Announcement
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:42:43: Create primary key on Announcement
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexClass
    08:42:43: Drop ApexClass_Previous if it exists.
    08:42:43: Create ApexClass_Previous with new structure.
    08:42:43: Run the DBAmp.exe program.
    08:42:43: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:42:43: Populating local table ApexClass_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:42:45: DBAmp is using the SQL Native Client.
    08:42:45: Opening SQL Server rowset
    08:42:48: 82 rows copied.
    08:42:48: Drop ApexClass if it exists.
    08:42:48: Rename previous table from ApexClass_Previous to ApexClass
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:42:48: Create primary key on ApexClass
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexComponent
    08:42:48: Drop ApexComponent_Previous if it exists.
    08:42:48: Create ApexComponent_Previous with new structure.
    08:42:48: Run the DBAmp.exe program.
    08:42:48: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:42:48: Populating local table ApexComponent_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:42:50: DBAmp is using the SQL Native Client.
    08:42:50: Opening SQL Server rowset
    08:42:51: 3 rows copied.
    08:42:51: Drop ApexComponent if it exists.
    08:42:51: Rename previous table from ApexComponent_Previous to ApexComponent
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:42:51: Create primary key on ApexComponent
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexLog
    08:42:51: Drop ApexLog_Previous if it exists.
    08:42:51: Create ApexLog_Previous with new structure.
    08:42:51: Run the DBAmp.exe program.
    08:42:51: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:42:51: Populating local table ApexLog_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:42:53: DBAmp is using the SQL Native Client.
    08:42:53: Opening SQL Server rowset
    08:42:54: 60 rows copied.
    08:42:54: Drop ApexLog if it exists.
    08:42:54: Rename previous table from ApexLog_Previous to ApexLog
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:42:54: Create primary key on ApexLog
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexPage
    08:42:54: Drop ApexPage_Previous if it exists.
    08:42:54: Create ApexPage_Previous with new structure.
    08:42:54: Run the DBAmp.exe program.
    08:42:54: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:42:54: Populating local table ApexPage_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:42:56: DBAmp is using the SQL Native Client.
    08:42:56: Opening SQL Server rowset
    08:43:01: 91 rows copied.
    08:43:01: Drop ApexPage if it exists.
    08:43:01: Rename previous table from ApexPage_Previous to ApexPage
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:01: Create primary key on ApexPage
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTestQueueItem
    08:43:01: Drop ApexTestQueueItem_Previous if it exists.
    08:43:01: Create ApexTestQueueItem_Previous with new structure.
    08:43:01: Run the DBAmp.exe program.
    08:43:02: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:02: Populating local table ApexTestQueueItem_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:03: DBAmp is using the SQL Native Client.
    08:43:03: Opening SQL Server rowset
    08:43:04: 0 rows copied.
    08:43:04: Drop ApexTestQueueItem if it exists.
    08:43:04: Rename previous table from ApexTestQueueItem_Previous to ApexTestQueueItem
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:05: Create primary key on ApexTestQueueItem
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTestResult
    08:43:05: Drop ApexTestResult_Previous if it exists.
    08:43:05: Create ApexTestResult_Previous with new structure.
    08:43:05: Run the DBAmp.exe program.
    08:43:05: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:05: Populating local table ApexTestResult_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:07: DBAmp is using the SQL Native Client.
    08:43:07: Opening SQL Server rowset
    08:43:08: 0 rows copied.
    08:43:08: Drop ApexTestResult if it exists.
    08:43:08: Rename previous table from ApexTestResult_Previous to ApexTestResult
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:08: Create primary key on ApexTestResult
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for ApexTrigger
    08:43:08: Drop ApexTrigger_Previous if it exists.
    08:43:08: Create ApexTrigger_Previous with new structure.
    08:43:08: Run the DBAmp.exe program.
    08:43:08: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:08: Populating local table ApexTrigger_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:09: DBAmp is using the SQL Native Client.
    08:43:09: Opening SQL Server rowset
    08:43:11: 12 rows copied.
    08:43:11: Drop ApexTrigger if it exists.
    08:43:11: Rename previous table from ApexTrigger_Previous to ApexTrigger
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:11: Create primary key on ApexTrigger
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AppMenuItem
    08:43:11: Drop AppMenuItem_Previous if it exists.
    08:43:11: Create AppMenuItem_Previous with new structure.
    08:43:11: Run the DBAmp.exe program.
    08:43:11: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:11: Populating local table AppMenuItem_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:13: DBAmp is using the SQL Native Client.
    08:43:13: Opening SQL Server rowset
    08:43:14: 29 rows copied.
    08:43:14: Drop AppMenuItem if it exists.
    08:43:14: Rename previous table from AppMenuItem_Previous to AppMenuItem
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:14: Create primary key on AppMenuItem
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Approval
    08:43:14: Drop Approval_Previous if it exists.
    08:43:14: Create Approval_Previous with new structure.
    08:43:14: Run the DBAmp.exe program.
    08:43:14: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:14: Populating local table Approval_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:16: DBAmp is using the SQL Native Client.
    08:43:16: Opening SQL Server rowset
    08:43:17: 0 rows copied.
    08:43:17: Drop Approval if it exists.
    08:43:17: Rename previous table from Approval_Previous to Approval
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:17: Create primary key on Approval
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Asset
    08:43:17: Drop Asset_Previous if it exists.
    08:43:17: Create Asset_Previous with new structure.
    08:43:17: Run the DBAmp.exe program.
    08:43:17: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:17: Populating local table Asset_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:19: DBAmp is using the SQL Native Client.
    08:43:19: Opening SQL Server rowset
    08:43:20: 0 rows copied.
    08:43:20: Drop Asset if it exists.
    08:43:20: Rename previous table from Asset_Previous to Asset
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:20: Create primary key on Asset
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AssetTag
    08:43:20: Drop AssetTag_Previous if it exists.
    08:43:20: Create AssetTag_Previous with new structure.
    08:43:20: Run the DBAmp.exe program.
    08:43:20: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:20: Populating local table AssetTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:22: DBAmp is using the SQL Native Client.
    08:43:22: Opening SQL Server rowset
    08:43:22: 0 rows copied.
    08:43:23: Drop AssetTag if it exists.
    08:43:23: Rename previous table from AssetTag_Previous to AssetTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:23: Create primary key on AssetTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AssignmentRule
    08:43:23: Drop AssignmentRule_Previous if it exists.
    08:43:23: Create AssignmentRule_Previous with new structure.
    08:43:23: Run the DBAmp.exe program.
    08:43:23: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:23: Populating local table AssignmentRule_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:24: DBAmp is using the SQL Native Client.
    08:43:24: Opening SQL Server rowset
    08:43:25: 0 rows copied.
    08:43:25: Drop AssignmentRule if it exists.
    08:43:25: Rename previous table from AssignmentRule_Previous to AssignmentRule
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:25: Create primary key on AssignmentRule
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AsyncApexJob
    08:43:25: Drop AsyncApexJob_Previous if it exists.
    08:43:25: Create AsyncApexJob_Previous with new structure.
    08:43:25: Run the DBAmp.exe program.
    08:43:25: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:25: Populating local table AsyncApexJob_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:26: DBAmp is using the SQL Native Client.
    08:43:26: Opening SQL Server rowset
    08:43:27: 0 rows copied.
    08:43:27: Drop AsyncApexJob if it exists.
    08:43:27: Rename previous table from AsyncApexJob_Previous to AsyncApexJob
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:27: Create primary key on AsyncApexJob
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Attachment
    08:43:27: Drop Attachment_Previous if it exists.
    08:43:27: Create Attachment_Previous with new structure.
    08:43:27: Run the DBAmp.exe program.
    08:43:27: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:27: Populating local table Attachment_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:43:29: DBAmp is using the SQL Native Client.
    08:43:29: Opening SQL Server rowset
    08:43:58: 35013 rows copied.
    08:43:58: Drop Attachment if it exists.
    08:43:58: Rename previous table from Attachment_Previous to Attachment
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:43:58: Create primary key on Attachment
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AuthProvider
    08:43:58: Drop AuthProvider_Previous if it exists.
    08:43:58: Create AuthProvider_Previous with new structure.
    08:43:58: Run the DBAmp.exe program.
    08:43:58: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:43:58: Populating local table AuthProvider_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:00: DBAmp is using the SQL Native Client.
    08:44:00: Opening SQL Server rowset
    08:44:01: 0 rows copied.
    08:44:01: Drop AuthProvider if it exists.
    08:44:01: Rename previous table from AuthProvider_Previous to AuthProvider
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:01: Create primary key on AuthProvider
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for AuthSession
    08:44:01: Drop AuthSession_Previous if it exists.
    08:44:01: Create AuthSession_Previous with new structure.
    08:44:01: Run the DBAmp.exe program.
    08:44:01: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:01: Populating local table AuthSession_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:03: DBAmp is using the SQL Native Client.
    08:44:03: Opening SQL Server rowset
    08:44:04: 174 rows copied.
    08:44:04: Drop AuthSession if it exists.
    08:44:04: Rename previous table from AuthSession_Previous to AuthSession
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:04: Create primary key on AuthSession
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Bookmark
    08:44:04: Drop Bookmark_Previous if it exists.
    08:44:04: Create Bookmark_Previous with new structure.
    08:44:04: Run the DBAmp.exe program.
    08:44:04: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:04: Populating local table Bookmark_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:05: DBAmp is using the SQL Native Client.
    08:44:05: Opening SQL Server rowset
    08:44:06: 0 rows copied.
    08:44:06: Drop Bookmark if it exists.
    08:44:06: Rename previous table from Bookmark_Previous to Bookmark
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:06: Create primary key on Bookmark
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BrandTemplate
    08:44:06: Drop BrandTemplate_Previous if it exists.
    08:44:06: Create BrandTemplate_Previous with new structure.
    08:44:06: Run the DBAmp.exe program.
    08:44:06: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:06: Populating local table BrandTemplate_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:08: DBAmp is using the SQL Native Client.
    08:44:08: Opening SQL Server rowset
    08:44:09: 4 rows copied.
    08:44:09: Drop BrandTemplate if it exists.
    08:44:09: Rename previous table from BrandTemplate_Previous to BrandTemplate
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:09: Create primary key on BrandTemplate
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BusinessHours
    08:44:09: Drop BusinessHours_Previous if it exists.
    08:44:09: Create BusinessHours_Previous with new structure.
    08:44:09: Run the DBAmp.exe program.
    08:44:09: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:09: Populating local table BusinessHours_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:11: DBAmp is using the SQL Native Client.
    08:44:11: Opening SQL Server rowset
    08:44:12: 1 rows copied.
    08:44:12: Drop BusinessHours if it exists.
    08:44:12: Rename previous table from BusinessHours_Previous to BusinessHours
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:12: Create primary key on BusinessHours
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for BusinessProcess
    08:44:12: Drop BusinessProcess_Previous if it exists.
    08:44:12: Create BusinessProcess_Previous with new structure.
    08:44:12: Run the DBAmp.exe program.
    08:44:12: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:12: Populating local table BusinessProcess_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:14: DBAmp is using the SQL Native Client.
    08:44:14: Opening SQL Server rowset
    08:44:15: 2 rows copied.
    08:44:15: Drop BusinessProcess if it exists.
    08:44:15: Rename previous table from BusinessProcess_Previous to BusinessProcess
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:15: Create primary key on BusinessProcess
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Buying_Influence__Tag
    08:44:15: Drop Buying_Influence__Tag_Previous if it exists.
    08:44:15: Create Buying_Influence__Tag_Previous with new structure.
    08:44:15: Run the DBAmp.exe program.
    08:44:15: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:15: Populating local table Buying_Influence__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:17: DBAmp is using the SQL Native Client.
    08:44:17: Opening SQL Server rowset
    08:44:17: 0 rows copied.
    08:44:17: Drop Buying_Influence__Tag if it exists.
    08:44:17: Rename previous table from Buying_Influence__Tag_Previous to Buying_Influence__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:17: Create primary key on Buying_Influence__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Buying_Influence__c
    08:44:18: Drop Buying_Influence__c_Previous if it exists.
    08:44:18: Create Buying_Influence__c_Previous with new structure.
    08:44:18: Run the DBAmp.exe program.
    08:44:18: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:18: Populating local table Buying_Influence__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:19: DBAmp is using the SQL Native Client.
    08:44:19: Opening SQL Server rowset
    08:44:33: 1982 rows copied.
    08:44:33: Drop Buying_Influence__c if it exists.
    08:44:33: Rename previous table from Buying_Influence__c_Previous to Buying_Influence__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:33: Create primary key on Buying_Influence__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CallCenter
    08:44:33: Drop CallCenter_Previous if it exists.
    08:44:33: Create CallCenter_Previous with new structure.
    08:44:33: Run the DBAmp.exe program.
    08:44:33: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:33: Populating local table CallCenter_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:34: DBAmp is using the SQL Native Client.
    08:44:34: Opening SQL Server rowset
    08:44:35: 0 rows copied.
    08:44:35: Drop CallCenter if it exists.
    08:44:35: Rename previous table from CallCenter_Previous to CallCenter
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:35: Create primary key on CallCenter
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__Share
    08:44:35: Drop Call_Planner_2__Share_Previous if it exists.
    08:44:35: Create Call_Planner_2__Share_Previous with new structure.
    08:44:35: Run the DBAmp.exe program.
    08:44:35: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:35: Populating local table Call_Planner_2__Share_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:37: DBAmp is using the SQL Native Client.
    08:44:37: Opening SQL Server rowset
    08:44:39: 338 rows copied.
    08:44:39: Drop Call_Planner_2__Share if it exists.
    08:44:39: Rename previous table from Call_Planner_2__Share_Previous to Call_Planner_2__Share
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:39: Create primary key on Call_Planner_2__Share
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__Tag
    08:44:39: Drop Call_Planner_2__Tag_Previous if it exists.
    08:44:39: Create Call_Planner_2__Tag_Previous with new structure.
    08:44:39: Run the DBAmp.exe program.
    08:44:39: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:39: Populating local table Call_Planner_2__Tag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:41: DBAmp is using the SQL Native Client.
    08:44:41: Opening SQL Server rowset
    08:44:41: 0 rows copied.
    08:44:41: Drop Call_Planner_2__Tag if it exists.
    08:44:41: Rename previous table from Call_Planner_2__Tag_Previous to Call_Planner_2__Tag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:41: Create primary key on Call_Planner_2__Tag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Call_Planner_2__c
    08:44:41: Drop Call_Planner_2__c_Previous if it exists.
    08:44:41: Create Call_Planner_2__c_Previous with new structure.
    08:44:42: Run the DBAmp.exe program.
    08:44:42: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:42: Populating local table Call_Planner_2__c_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:43: DBAmp is using the SQL Native Client.
    08:44:43: Opening SQL Server rowset
    08:44:46: 141 rows copied.
    08:44:46: Drop Call_Planner_2__c if it exists.
    08:44:46: Rename previous table from Call_Planner_2__c_Previous to Call_Planner_2__c
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:46: Create primary key on Call_Planner_2__c
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Campaign
    08:44:46: Drop Campaign_Previous if it exists.
    08:44:46: Create Campaign_Previous with new structure.
    08:44:46: Run the DBAmp.exe program.
    08:44:46: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:46: Populating local table Campaign_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:48: DBAmp is using the SQL Native Client.
    08:44:48: Opening SQL Server rowset
    08:44:49: 1 rows copied.
    08:44:49: Drop Campaign if it exists.
    08:44:49: Rename previous table from Campaign_Previous to Campaign
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:49: Create primary key on Campaign
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignMember
    08:44:49: Drop CampaignMember_Previous if it exists.
    08:44:49: Create CampaignMember_Previous with new structure.
    08:44:49: Run the DBAmp.exe program.
    08:44:49: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:49: Populating local table CampaignMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:51: DBAmp is using the SQL Native Client.
    08:44:51: Opening SQL Server rowset
    08:44:52: 0 rows copied.
    08:44:52: Drop CampaignMember if it exists.
    08:44:52: Rename previous table from CampaignMember_Previous to CampaignMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:52: Create primary key on CampaignMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignMemberStatus
    08:44:52: Drop CampaignMemberStatus_Previous if it exists.
    08:44:52: Create CampaignMemberStatus_Previous with new structure.
    08:44:52: Run the DBAmp.exe program.
    08:44:52: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:52: Populating local table CampaignMemberStatus_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:54: DBAmp is using the SQL Native Client.
    08:44:54: Opening SQL Server rowset
    08:44:55: 2 rows copied.
    08:44:55: Drop CampaignMemberStatus if it exists.
    08:44:55: Rename previous table from CampaignMemberStatus_Previous to CampaignMemberStatus
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:55: Create primary key on CampaignMemberStatus
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignShare
    08:44:55: Drop CampaignShare_Previous if it exists.
    08:44:55: Create CampaignShare_Previous with new structure.
    08:44:55: Run the DBAmp.exe program.
    08:44:55: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:55: Populating local table CampaignShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:57: DBAmp is using the SQL Native Client.
    08:44:57: Opening SQL Server rowset
    08:44:57: 0 rows copied.
    08:44:57: Drop CampaignShare if it exists.
    08:44:57: Rename previous table from CampaignShare_Previous to CampaignShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:44:57: Create primary key on CampaignShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CampaignTag
    08:44:57: Drop CampaignTag_Previous if it exists.
    08:44:57: Create CampaignTag_Previous with new structure.
    08:44:58: Run the DBAmp.exe program.
    08:44:58: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:44:58: Populating local table CampaignTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:44:59: DBAmp is using the SQL Native Client.
    08:44:59: Opening SQL Server rowset
    08:45:00: 0 rows copied.
    08:45:00: Drop CampaignTag if it exists.
    08:45:00: Rename previous table from CampaignTag_Previous to CampaignTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:00: Create primary key on CampaignTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for Case
    08:45:00: Drop Case_Previous if it exists.
    08:45:00: Create Case_Previous with new structure.
    08:45:00: Run the DBAmp.exe program.
    08:45:00: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:00: Populating local table Case_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:02: DBAmp is using the SQL Native Client.
    08:45:02: Opening SQL Server rowset
    08:45:03: 3 rows copied.
    08:45:03: Drop Case if it exists.
    08:45:03: Rename previous table from Case_Previous to Case
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:03: Create primary key on Case
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseComment
    08:45:03: Drop CaseComment_Previous if it exists.
    08:45:03: Create CaseComment_Previous with new structure.
    08:45:03: Run the DBAmp.exe program.
    08:45:03: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:03: Populating local table CaseComment_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:05: DBAmp is using the SQL Native Client.
    08:45:05: Opening SQL Server rowset
    08:45:06: 0 rows copied.
    08:45:06: Drop CaseComment if it exists.
    08:45:06: Rename previous table from CaseComment_Previous to CaseComment
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:06: Create primary key on CaseComment
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseContactRole
    08:45:06: Drop CaseContactRole_Previous if it exists.
    08:45:06: Create CaseContactRole_Previous with new structure.
    08:45:06: Run the DBAmp.exe program.
    08:45:06: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:06: Populating local table CaseContactRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:08: DBAmp is using the SQL Native Client.
    08:45:08: Opening SQL Server rowset
    08:45:09: 0 rows copied.
    08:45:09: Drop CaseContactRole if it exists.
    08:45:09: Rename previous table from CaseContactRole_Previous to CaseContactRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:09: Create primary key on CaseContactRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseHistory
    08:45:09: Drop CaseHistory_Previous if it exists.
    08:45:09: Create CaseHistory_Previous with new structure.
    08:45:09: Run the DBAmp.exe program.
    08:45:09: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:09: Populating local table CaseHistory_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:10: DBAmp is using the SQL Native Client.
    08:45:10: Opening SQL Server rowset
    08:45:11: 3 rows copied.
    08:45:11: Drop CaseHistory if it exists.
    08:45:11: Rename previous table from CaseHistory_Previous to CaseHistory
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:11: Create primary key on CaseHistory
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseShare
    08:45:11: Drop CaseShare_Previous if it exists.
    08:45:11: Create CaseShare_Previous with new structure.
    08:45:11: Run the DBAmp.exe program.
    08:45:12: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:12: Populating local table CaseShare_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:13: DBAmp is using the SQL Native Client.
    08:45:13: Opening SQL Server rowset
    08:45:14: 6 rows copied.
    08:45:14: Drop CaseShare if it exists.
    08:45:14: Rename previous table from CaseShare_Previous to CaseShare
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:14: Create primary key on CaseShare
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseSolution
    08:45:15: Drop CaseSolution_Previous if it exists.
    08:45:15: Create CaseSolution_Previous with new structure.
    08:45:15: Run the DBAmp.exe program.
    08:45:15: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:15: Populating local table CaseSolution_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:16: DBAmp is using the SQL Native Client.
    08:45:16: Opening SQL Server rowset
    08:45:18: 0 rows copied.
    08:45:18: Drop CaseSolution if it exists.
    08:45:18: Rename previous table from CaseSolution_Previous to CaseSolution
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:18: Create primary key on CaseSolution
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseStatus
    08:45:18: Drop CaseStatus_Previous if it exists.
    08:45:18: Create CaseStatus_Previous with new structure.
    08:45:18: Run the DBAmp.exe program.
    08:45:18: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:18: Populating local table CaseStatus_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:19: DBAmp is using the SQL Native Client.
    08:45:19: Opening SQL Server rowset
    08:45:21: 4 rows copied.
    08:45:21: Drop CaseStatus if it exists.
    08:45:21: Rename previous table from CaseStatus_Previous to CaseStatus
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:21: Create primary key on CaseStatus
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTag
    08:45:21: Drop CaseTag_Previous if it exists.
    08:45:21: Create CaseTag_Previous with new structure.
    08:45:22: Run the DBAmp.exe program.
    08:45:22: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:22: Populating local table CaseTag_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:23: DBAmp is using the SQL Native Client.
    08:45:23: Opening SQL Server rowset
    08:45:24: 0 rows copied.
    08:45:24: Drop CaseTag if it exists.
    08:45:24: Rename previous table from CaseTag_Previous to CaseTag
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:24: Create primary key on CaseTag
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamMember
    08:45:24: Drop CaseTeamMember_Previous if it exists.
    08:45:24: Create CaseTeamMember_Previous with new structure.
    08:45:25: Run the DBAmp.exe program.
    08:45:25: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:25: Populating local table CaseTeamMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:26: DBAmp is using the SQL Native Client.
    08:45:26: Opening SQL Server rowset
    08:45:27: 0 rows copied.
    08:45:27: Drop CaseTeamMember if it exists.
    08:45:27: Rename previous table from CaseTeamMember_Previous to CaseTeamMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:27: Create primary key on CaseTeamMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamRole
    08:45:27: Drop CaseTeamRole_Previous if it exists.
    08:45:27: Create CaseTeamRole_Previous with new structure.
    08:45:27: Run the DBAmp.exe program.
    08:45:28: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:28: Populating local table CaseTeamRole_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:29: DBAmp is using the SQL Native Client.
    08:45:29: Opening SQL Server rowset
    08:45:31: 0 rows copied.
    08:45:31: Drop CaseTeamRole if it exists.
    08:45:31: Rename previous table from CaseTeamRole_Previous to CaseTeamRole
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:31: Create primary key on CaseTeamRole
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplate
    08:45:31: Drop CaseTeamTemplate_Previous if it exists.
    08:45:31: Create CaseTeamTemplate_Previous with new structure.
    08:45:31: Run the DBAmp.exe program.
    08:45:31: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:31: Populating local table CaseTeamTemplate_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:33: DBAmp is using the SQL Native Client.
    08:45:33: Opening SQL Server rowset
    08:45:34: 0 rows copied.
    08:45:34: Drop CaseTeamTemplate if it exists.
    08:45:34: Rename previous table from CaseTeamTemplate_Previous to CaseTeamTemplate
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:34: Create primary key on CaseTeamTemplate
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplateMember
    08:45:34: Drop CaseTeamTemplateMember_Previous if it exists.
    08:45:34: Create CaseTeamTemplateMember_Previous with new structure.
    08:45:34: Run the DBAmp.exe program.
    08:45:34: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:34: Populating local table CaseTeamTemplateMember_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:35: DBAmp is using the SQL Native Client.
    08:45:35: Opening SQL Server rowset
    08:45:36: 0 rows copied.
    08:45:36: Drop CaseTeamTemplateMember if it exists.
    08:45:36: Rename previous table from CaseTeamTemplateMember_Previous to CaseTeamTemplateMember
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:36: Create primary key on CaseTeamTemplateMember
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CaseTeamTemplateRecord
    08:45:36: Drop CaseTeamTemplateRecord_Previous if it exists.
    08:45:36: Create CaseTeamTemplateRecord_Previous with new structure.
    08:45:36: Run the DBAmp.exe program.
    08:45:36: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:36: Populating local table CaseTeamTemplateRecord_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:38: DBAmp is using the SQL Native Client.
    08:45:38: Opening SQL Server rowset
    08:45:39: 0 rows copied.
    08:45:39: Drop CaseTeamTemplateRecord if it exists.
    08:45:39: Rename previous table from CaseTeamTemplateRecord_Previous to CaseTeamTemplateRecord
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:39: Create primary key on CaseTeamTemplateRecord
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CategoryData
    08:45:39: Drop CategoryData_Previous if it exists.
    08:45:39: Create CategoryData_Previous with new structure.
    08:45:39: Run the DBAmp.exe program.
    08:45:39: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:39: Populating local table CategoryData_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:41: DBAmp is using the SQL Native Client.
    08:45:41: Opening SQL Server rowset
    08:45:42: 0 rows copied.
    08:45:42: Drop CategoryData if it exists.
    08:45:42: Rename previous table from CategoryData_Previous to CategoryData
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:42: Create primary key on CategoryData
    --- Ending SF_Replicate. Operation successful.
    --- Starting SF_Replicate for CategoryNode
    08:45:42: Drop CategoryNode_Previous if it exists.
    08:45:42: Create CategoryNode_Previous with new structure.
    08:45:42: Run the DBAmp.exe program.
    08:45:42: DBAmp Bulk Operations. V2.18.4 (c) Copyright 2006-2014 forceAmp.com LLC
    08:45:42: Populating local table CategoryNode_Previous , FIPSQL01\SQL01 / Salesforce_Live .
    08:45:44: DBAmp is using the SQL Native Client.
    08:45:44: Opening SQL Server rowset
    08:45:45: 0 rows copied.
    08:45:45: Drop CategoryNode if it exists.
    08:45:45: Rename previous table from CategoryNode_Previous to CategoryNode
    Caution: Changing any part of an object name could break scripts and stored procedures.
    08:45:45: Create primary key on CategoryNode
    --- Ending SF_Replicate. Operation succ
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • You can find the error by searching for the word "error" in the output:

    08:38:35: Create primary key on Account
    08:38:35: Error occurred creating primary key for table.
    08:38:35: Error: Could not create constraint. See previous errors.

    It appears that all tables replicated fine but DBAmp could not create a primary key on the Id field of the Account table. Can you try the following command and report any errors:

    ALTER TABLE [Account] ADD CONSTRAINT [PK_Account_Id] PRIMARY KEY NONCLUSTERED
    (
    [Id] ASC
    )
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • Hi Bill,

    Thanks for your reply, I tried to run the above script and was presented with the below message:

    Msg 2714, Level 16, State 5, Line 4
    There is already an object named 'PK_Account_Id' in the database.
    Msg 1750, Level 16, State 0, Line 4
    Could not create constraint. See previous errors.

    Best regards

    Martin
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned

  • So DBAmp cannot create the primary key he wants because you have another object in the database with the same name.

    All DBAmp tables should use the dbo schema. Do you have multiple Account tables in the database with different schemas ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated indifferent, undecided, unconcerned