Skip to main content

Manual Deployment Process

:::note Table of Contents

  • Copy keycloak-client-secret-neo-dv-df from the augustus dv and add it in the sandbox keyvault
  • Copy a sql server in Azure
  • Compare two databases using sql data compare
  • Create Datalake Folders

:::


Copy keycloak-client-secret-neo-dv-df from the augustus dv and add it in the sandbox keyvault​

To Copy the respective secret and add it in the sandbox key vault follow the below steps​

Steps​

Step1: go to the augustus dv keyvault

Step2: Navigate to secrets and open the keycloak-client-secret-neo-dv-df key and copy the current version secret value

Screenshot (171).png

Step3: Now go to the sandbox key vault and navigate to secrets and add the key & value which you copied from the augustus dv key vault and hit on create (In this case my sandbox key vault is 'micah-groh-kv-001')

Screenshot (167).png

Screenshot (168).png

Now you have successfully added the Key & Value in the New sandbox. you can see it in the below image

Screenshot (170).png

Copy a sql server in Azure​

Prerequisites​

  1. Contributor and login details on both databases.

Steps​

  1. First, delete the database that is the target of the copy activity. Check with the QA team if this is fine to do. Important: Save the exact name of the database deleted.

  2. Hit the copy button at the top of the source database. Copy.PNG

  3. Fill out the form with the right database server and name. Select no for elastic pools and geo redundant storage.

  4. Finally, hit review and create.

Compare two databases using sql data compare​

Prerequisites​

A redgate sql data compare license and software installation

Steps​

  1. Open redgate sql data compare on your desktop.

  2. Select database for both options. Then select compare now. Selection of type.PNG

  3. Enter the credentials of each database. Then hit compare now. Compare details.PNG

  4. Finally, view the tables compared. identical.PNG

Create Datalake Folders​

Prerequisites​

  1. You will need Storage Account Data Contributor or Storage Blob Data Contributor on the storage account.
  2. Your IP address will need access through the storage account's firewall if that is enabled.

Steps​

  1. Navigate to the storage account and click on the containers tab. Then navigate to the maindl container. maindl.PNG

  2. In the maindl container, create a new directory called STATE_CONFIG, JOBS, DROPBOX. Then hit save. STATE_CONFIG.PNG