We are upgrading from DBAMP v.4.1.8 to v.22. Because we are restricted from using xp_cmdshell, most of our SQL Server Agent jobs run sf_replicate. If I’m understanding the documentation correctly, we won’t be able to call sf_replicate directly on v.22.
The CMDEXEC looks like this on 4.1.8: ‘“C:\Program Files\DBAmp\DBAmpNet2.exe” replicate pkchunk,batchsize(25000) Account MyServerName MyDatabase SALESFORCE’
Will the call have to look something like this on v.22?
As you already know a good amount of DBAmp’s stored procedures make use of xp_cmdshell. DBAmp normally uses xp_cmdshell to run the stored procedures, which usually requires sysadmin. Indeed there is an option to run the DBAmp stored procedures without xp_cmdshell by calling the DBAmp app directly from the command line and that is available in v22 as well.
This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media.
Review section III of our Privacy Policy for more information on cookies.
To opt out of “sale” or “sharing” of non-cookie data, visit our Privacy Rights Request Form.