--- title: "Creating a Database for ADM and Migrate (ADMM) in AWS" slug: "creating-a-database-for-adm-and-migrate-in-aws" updated: 2025-08-19T15:20:21Z published: 2025-08-19T15:20:21Z canonical: "skthelp.syniti.com/creating-a-database-for-adm-and-migrate-in-aws" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # 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](/v1/docs/contact-support) to create a ticket for database creation access. ```sql -- 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](/v1/docs/managing-a-user-in-ssms) for more information on creating and managing your user account. 3. Execute the following query: ```sql 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](/v1/docs/contact-support).