Installing DBAmp Stored Procedures


Installing DBAmp Stored Procedures


NOTE: The DBAmp stored procedures are NOT installed on the remote SQL Server Instance.

Next, create a database to run DBAmp commands. The database you create contains the DBAmp stored procedures.

To install the DBAmp Stored Procedures:

  1. Using the SQL Server Management Studio, create a new database named “Salesforce backups”. This database is used to run the DBAmp commands to push your Salesforce data to the remote database on the remote SQL Server Instance.
  2. Open the file Create DBAmp SPROCS.sql in the Query Analyzer or in Management Studio but do not execute it yet. The file is located in \ProgramFiles\CData\CData DBAmp\SQL.
  3. Make sure that default database shown on the toolbar is the Salesforce backups database (not the main database). Then press F5 to add the stored procedures to the database.