Creating a Database for ADM and Migrate (ADMM) in AWS

Overview

This article is intended for Syniti Consultants to guide them in creating a database in AWS for a tenant in ADM or SAP Advanced Data Migration and Management (ADMM).

Prerequisites

Ensure that your SQL Server instance includes an Admin database by using the script below. If it does not, contact Syniti Support to create a ticket for database creation access.

-- Script to check if 'admin' database exist in the SQL Serve instance

IF EXISTS (SELECT 1 FROM sys.databases where [name]='admin')
  PRINT 'Database [admin] exists on sql server'
ELSE
  PRINT 'Please contact Syniti Support’;

Instructions

1. Connect to the required database or instance using SQL Server Management Studio (SSMS).

2. If you are unable to connect to SSMS, refer to Managing a User in SSMS for more information on creating and managing your user account.

3. Execute the following query:

   USE [admin]
   GO
   EXECUTE [dbo].[syncosp_create_userdb] @DBName='db_name'
   GO
   
   --Replace 'db_name' with the actual database name to be created.

4. You can run the above query for multiple databases as required. Wait for a brief moment (five minutes) for the database to be created.

5. Verify if the database is created successfully.

6. If the database is not created, contact Syniti Support.