--- 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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=Dy7oP%2BnHTd%2FcmR9g3exP%2FkKtUmmXA8ZNQUxkTwnmDyk%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=D0Y3zaMC8gD2345r9KY1XTrii%2BEEkLAucn0ZCZajPs4%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=%2BPMOYMpXEPk0ds7%2B8KgYe6nIfUKgmNH2KvXP01jtS7I%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=Il014VqywX8h%2B4kLG74bzJ%2BTuwavrgVKD0m4AFPzsYU%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=xZ2lOUVPp%2BVHPlnxyypRXvGLrzDnhFy6EquimClhm4U%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=QFB9RwB7IIbUgrGobBEwQTigdKtREAEN07Ttpuz4eOA%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=x5j2s3O8U2hv10jU388GaJGci8kSkzbMAvB%2FKOzeg3w%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%3A30%3A00Z&se=2026-11-17T20%3A30%3A00Z&sr=b&sp=r&sig=VKTmno%2Bmt1%2Fgg41NkF270SrodI7mJpDY3mDYbvYCaYw%3D)