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:
- 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.
- 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
. - 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.