--- title: "Creating a Metadata for Syniti Replicate" slug: "creating-a-metadata-for-syniti-replicate" updated: 2024-10-07T07:53:31Z published: 2024-10-07T07:53:31Z canonical: "skthelp.syniti.com/creating-a-metadata-for-syniti-replicate" --- > ## 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 Metadata for Syniti Replicate Syniti recommends creating a Syniti Replicate Metadata in Microsoft SQL Server. This article describes high-level steps to create a Metadata from scratch. Complete the following steps when you run a clean installation or upgrade Replicate from a previous version of DBMoto or Syniti Data Replication using the standard installation: 1. In your local Syniti Server, install **SQL Server** of any edition such as Express, Standard, or Enterprise. 2. Create a database in SQL Server. For example, Metadata. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-ro7lbtya.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=8OugUuNtKbSypmkVLn1jpalDllo9p86Z51M282OOwYw%3D) ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-yhqw39ye.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=jy3lTdkOKu8MleXQoogVX1TExY8yRo9Eg%2FGr67uegqY%3D) 3. Create a user in this database (for example, Metadata) and ensure that you grant full permissions to this database. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-jo590l46.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=qs9LqEZOC9ZBrLXFUP0Jl0H9Itp%2FI%2FJksppC5mK8NsY%3D) 4. In Syniti Replicate, after completing your installation or upgrade, a new server *local* appears in the Metadata Explorer. Right click **Local** and select **Add New Metadata**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-9oddtqoj.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=AhW6AInovffgZq%2Ff6AjbTMMW0I1RpHIk6Cgu3MhBUqo%3D) 5. Complete the steps in the [Metadata Connection wizard](/v1/docs/metadata-connection-wizard) to create a metadata. In this case, create a metadata named **Metadata**. 6. Enter the credential created in SQL Server to connect with the database, test the database connection, and click **Next**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-rurq9zz9.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=G3%2FdTF1Itsk%2FVw%2FthV8J2lCsqR%2BBWVbs%2BJwV2PPLYKc%3D) 7. Select the newly created database. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-zxfl3aex.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=UOcc3%2FWu4SKsPIrJjhlykM%2BiGyC8G3qCRkm%2B3TyayyU%3D) 8. You can create a new Metadata if this is a clean installation or restore a previous Metadata from a backup. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-1pzrgs7o.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=d%2FKqkFuoKpa7Wn6f4Xy8I9XwsfBqD9JPUD2TJKktdY8%3D) 9. If your metadata is already stored in a SQL Server database, select **Open existing Metadata Database** to recover your metadata from this location. 10. Once you complete the wizard, the new metadata appears in the Metadata Explorer. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/creating-a-metadata-for-syniti-replicate-image-2argj32s.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A30Z&se=2026-11-17T20%3A45%3A30Z&sr=b&sp=r&sig=jxyxFWusPhXQyTIZ%2Fuy48AuQIJeSHJT17eWogeitjPY%3D)