Follow

Creating a Test CEO Juice Database

In order to properly set up the Connectwise integration in a test environment, we ask that you create a copy of the CEO Juice database for testing purposes. **The CEO Juice dev DB must be on the same SQL server instance as the test eAutomate DB.**

To do this, follow these steps:

1. Open SSMS, connected to the server where the production CEOJuice DB is located. Right-click on the production Juice database (normally called ceojuice) (1) and select Tasks (2)  and then Back Up... (3):

step_one.jpg

2. Make sure that you select the Backup type of Full:

step_two.jpg

3. Once you have created the backup, right-click on the server and choose Restore Database...:

step_three.jpg

4. Under source, select Device and then select the most recent backup of the CEOJuice database (1). Under Destination change the database name to CeoJuice_dev (2) **This step is very important, by default, it will restore as the same name as the source, overwriting the production DB, so make sure that the database listed in step 2 is NOT the same as the database in step 1**

updated ceojuice_de step.jpg

5. Click on the Files page and verify the Restore As files reflect the new database name. **Important!! Otherwise, you may overwrite a database!!

ceojuice_test_db_step_5.jpg

6. Click on OK to create the dev database.

Please let us know if there are any issues creating the database to use for testing by emailing help@ceojuice.com

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk