--- title: "Defining Multiple Table Replications" slug: "defining-multiple-table-replications" updated: 2024-03-22T17:32:12Z published: 2024-03-22T17:32:13Z canonical: "skthelp.syniti.com/defining-multiple-table-replications" --- > ## 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. # Defining Multiple Table Replications If you need to replicate all or many of the tables in one database to another database, you can define the replications using the [Multiple Replications wizard](/v1/docs/multiple-replications-wizard). This allows you to set the source database, target database and scheduling details just once for all replications involved. The wizard also creates tables in the target database if necessary. While the replications are scheduled to run together, you can optimize performance by first [creating a group](/v1/docs/creating-a-replication-group) for the replications. Follow the steps below to create a group then create multiple replications. 1. In the Management Center Metadata Explorer, select a metadata. 2. For this metadata, create a source connection and a target connection for the databases you are using in the replication. 3. Select the **Groups** item. 4. From the right mouse button menu, choose **Add New Group**. 5. In the [Replication Group Wizard](/v1/docs/replication-group-wizard), enter a name and, optionally, a description for the group. 6. Click **Next** to display the **Select Replications** screen. 7. Click **Next** to go to the Summary screen right away. 8. Click **Finish** to create the group. 9. In the Metadata Explorer, select the source connection to the database that you want to replicate. 10. From the right mouse button menu, choose **Create Multiple Replications**. 11. In the Define replication type screen, enter a base replication name to identify the table replications that will be created at the end of the wizard. Each table replication will have the base replication name followed by a sequential number to identify it. 12. Check the **Use Group** option. 13. From the drop-down list, select the group you created above. 14. Choose the [type of replication](/v1/docs/replication-types) you want to perform. 15. Click **Next** to go to the **Select source connection** screen. 16. Make sure that the correct source connection is selected. 17. Click **Next** to go to the **Select target connection** screen. 18. Select a target connection. 19. Click **Next** to go to the **Set replications** screen. All tables in the database are automatically selected for replication. 20. If you do not want to replicate all tables, double-click in the check box next to each table that you do not wish to replicate. This will remove the check mark. By default, source table fields are replicated to fields of the same name in target tables. 21. If you wish to change the source table field - target table field mapping, click in the right column of the table containing the field. 22. In the [Fields Mapping dialog](/v1/docs/fields-mapping-dialog), set the mapping to a field, an expression or no corresponding target. 23. Click **OK** in the Fields Mapping Dialog. 24. Click **Next** to go to the **Scheduling** screen. Note that if **Enable Replications** is checked and you are running the Replication Agent as a service, the replications will start automatically after they have been created at the time you have specified. If you want to hold off on running the replications, uncheck the **Enable Replications** checkbox. 25. [Set the schedule](/v1/docs/multiple-replications-wizard#scheduling) for all replications that have been defined. 26. Click **Next** to go to the **Summary** screen. 27. Review your settings, then click **Start** to create the replications. 28. Click **Finish** to close the wizard. 29. Check that all replications have been created in the Metadata Explorer by expanding the Replications node. When you have completed the wizard, you will see that a replication has been created for each table that you selected in the wizard. The replication properties are set so that the replications will occur at the same time and within a single group. **Related Topics** [Multiple Replications Wizard](/v1/docs/multiple-replications-wizard) [Creating a Replication Group](/v1/docs/creating-a-replication-group) [Replication Properties Dialog](/v1/docs/replication-properties-dialog) [Managing Multiple Concurrent Replications](/v1/docs/managing-multiple-concurrent-replications)