--- title: "Steps for Replicating Using One-way Mirroring" slug: "steps-for-replicating-with-one-way-mirroring" updated: 2024-04-24T06:35:16Z published: 2024-04-24T06:35:16Z canonical: "skthelp.syniti.com/steps-for-replicating-with-one-way-mirroring" --- > ## 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. # Steps for Replicating with One-way Mirroring One-way mirroring provides a continuous update of a replicated table based on changes to the source database that have been recorded in the database server log. Typically, this involves an initial refresh operation, as described above, to set up the target table. Then you can define the replication settings to check the transaction log on the source database at regular intervals. Any changes found in the log are applied to the target database. ## 1. Set Up Source Database Connection 1. Make sure you have [database connections via a .NET data provider](/v1/docs/creating-database-connections) to the supported databases for source database tables and target database tables. 2. Start the Management Center. You must create metadata connections in a local Microsoft SQL Server, to contain all the information needed for your replication setup. Refer to [Metadata Connection Wizard](/v1/docs/metadata-connection-wizard) for more information to create metadata. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/DefaultMetadata (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=OP8eOnjxDFA1jyVXwzZ0zL77oopYaxmQfHmv8lVoahI%3D) 1. In the Metadata Explorer, expand the metadata node to view the **Sources** and **Targets** nodes. 2. Select the **Sources** node. 3. From the right mouse button menu, choose **Add New Connection**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/AddNewSourceConnMenu (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=DwZpDyE4AjhLrEXdDm3BP6FsGpLDJgw8I8259DBners%3D) 4. In the [Add Source Connection Wizard](/v1/docs/add-source-connection-wizard), follow steps to add a connection string and test the connection to the database. Check the Supported Provider List in the [Help Center](https://support.syniti.com/hc/en-us/articles/5726157638807-Syniti-Data-Replication-and-DBMoto-Supported-NET-Providers-DBMoto-Supported-NET-Providers) before entering a value in the **Assembly** field. ![SourceConnectionWizard (2)](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/SourceConnectionWizard%20(2).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=rkw%2Fe3XI9f68oaGlqXNSV0dWqQ%2BPN5nZMZ8%2BFRMJy8Q%3D) 5. In the **Select Tables** screen, choose the tables that you plan to replicate. 6. In the **Actions** screen, check the option **Launch the Enable Transactional Setup Wizard**. 7. Complete the wizard. ## 2. Enable Transactional Replication This section assumes you have checked the Source Connection wizard option to launch the Enable Transactional Replication wizard. To open the wizard from the Management Center, choose the connection in the Metadata Explorer, then right-click to choose Transactional Setup > Enable... In the [Enable Transactional Replication wizard](/v1/docs/enable-transactional-replication-wizard): 1. Select the type of transactional replication to use. The options depend on the source database and can include [log reader, log server agent, triggers, plus log reader API](/v1/docs/choosing-a-log-type-for-transactional-replications) (for IBM Db2 for i only) ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/EnableTransLogType.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=FxRYDUxkW4PSAujQswoduQSZB5AmKs9qQNua0IQnPpo%3D) 2. Click **Next** to enter the log settings. The fields and appropriate values depend on the [database and log type](/v1/docs/enable-transactional-replication-wizard#log-settingstrigger-settings). ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/EnableTransLogSettings.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=jArev8vTbjNYVi27w54cY7niPJVlIU9rYS1zNV9QdU4%3D) 3. Click **Next** to verify your settings against the source connection to the database. If any information is missing, you will not be able to proceed. 4. In the Actions screen, check the option to launch the **Add Target Connection wizard**. 5. Click **Next** to review your changes. 6. Click **Finish** to complete the wizard. The source connection is now set up for transactional replications. ## 3. Set Up Target Database Connection This section assumes you have checked the **Enable Transactional Replication wizard** option to launch the Add Target Connection wizard. If not, to open the wizard from the Management Center, choose **Targets** in the Metadata Explorer, then right-click to choose **Add New Connection...** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/AddNewTargetConnMenu.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=fV8iWVHmZcM1NM8dcSD2%2FBmFzJjb12j%2FPH6RxBwbhO0%3D) 1. In the [Target Connection Wizard](/v1/docs/add-target-connection-wizard), follow steps to add a connection string and test the connection to the database. Check the Supported Provider List in the [Help Center](https://support.syniti.com/hc/en-us/articles/5726157638807-Syniti-Data-Replication-and-DBMoto-Supported-NET-Providers-DBMoto-Supported-NET-Providers) before entering a value in the **Assembly** field. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/TargetConnectionWizard (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=kuhdfaChaZkiWg0pV7LM%2F1RiQc3k0HHWxkmkW30urhc%3D) 2. Choose the tables to which you plan to replicate. If the table does not exist, continue to the next screen without selecting a table. [Create a target table](/v1/docs/steps-for-replicating-with-one-way-mirroring#4-create-a-target-table) once the wizard is complete. 3. Complete the wizard. ## 4. Create a Target Table If the target table does not exist, use the Create Target Table wizard to create the table. 1. In the Metadata Explorer, drag the source table to the target connection to open the Create Target Table wizard. The **Select Source Connection** screen is already filled out with the table you selected. 2. In the **Select Source Connection** screen, the source table information has already been provided. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/CreateTargetTable-SourceConn (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=yH%2FVYijCEyL58OrIOwQR4W3DO2qWaHzH4qSHsluBcgE%3D) 3. If you want more information about the table before proceeding, click **Open Table...**. 4. Click **Next** to go to the **Select Target Connection** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/CreateTargetTable-TargetConn (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=3SfdHmmAZmhJ139RVMScUlQTdgBs8Ew9Mwpv7C5lcw4%3D) 5. The target connection details have been provided. Change the table name if needed. 6. Click **Next** to go to the **Define Columns** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/CreateTargetTable-DefineCols (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=L6Z8fplT1PIvoDe2OAREyqTKyPzkAMqPT%2FlYkP5eX60%3D) 7. Review the columns that will be created in the target table. You can add or remove columns as well as designate one or more columns as a primary key. 8. When you have finished editing the target table columns, click **Next** to go to the **SQL Script** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/CreateTargetTable-SQLScript (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=UPc9GGppSWIper5uA4zHQif0naxSnhjTfslTprB1y4Y%3D) 9. If necessary, edit the SQL script that generates the table. 10. Click **Next** to display the Actions screen. 11. To create additional tables, check the **Launch Create Target Table wizard** option. This opens another Create Target Table wizard when this wizard is complete. 12. To go directly to creating a replication once this wizard is complete, check **Launch Create Replication wizard** option. This opens the [Replication wizard](/v1/docs/replication-wizard) when the Create Target Table wizard is complete. 13. Click **Next** to view a summary. 14. Click **Finish** to create the target table. 15. Note that the new table is not automatically displayed in the Metadata Explorer. Click **Yes** to add the newly created table to the list of target tables in the Metadata Explorer. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ec688be3-95e8-4231-b219-46c8768323ab.jpg?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=t4mzeZqoFRw6ksQFfBC0WAiIAbEpacJMZ%2BYLf540e3M%3D) ## 5. Define the Replication This section assumes you have checked the Create Replication wizard option to launch the Create Replication wizard. If not, to open the wizard from the Management Center, choose the table you want to replicate in the Metadata Explorer, then right-click to choose **Replication > Create New Replication...** 1. In the **Define Replication Type** screen, type a name to identify the replication. 2. Optionally provide a description of the replication. 3. In the Replication Mode area, choose **Continuous Mirroring**. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-RepType.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=I4mTDT813IQcHa7AFo3jo2xDT65EwB%2B0UQMZlQGnw5E%3D) 4. Click **Next** to go to the Select Source Connection screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-SourceConn.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=VGVrBXwLfywBoJLcTLOFfQreMVTbErJCO5jPgNjh1fw%3D) 5. Choose the source name from the drop-down list that includes all the source connections you have created. 6. Choose the table that you want to replicate from the drop-down list. 7. If you want more information about the table before proceeding, click **Open Table...**. 8. Click **Next** to go to the **Source Log Info** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-SourceConn-SetupInfo.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=PnjedToPG5RQc5VYl%2FRkpL2NY%2FyXR8w%2BeK10WX1SnvQ%3D) The first two fields on this screen depend on the source database you are using. In this explanation, we assume you are using IBM Db2 for i (iSeries or AS/400). Check the help for the [Replication Wizard](/v1/docs/replication-wizard#source-log-info) for details on the other databases. The Journal field is automatically filled in by retrieving the information from Db2 for i. The Receiver field will be automatically filled in after setting the Transaction ID. You do not need to modify these fields. However, if the library that you have specified as a source is not journaled, you will need to ask your system administrator to journal the library. 9. In the Transaction ID field, click **Read** to open the Read Point dialog. 10. Choose either the current transaction or a transaction ID based on a time and date. 11. Click **OK** to add the value to the **Source Log Info** screen. 12. Set the value of the **Read Interval** field to the frequency with which you want Syniti Replicate to check the transaction log for new events to mirror. 13. Click **Next** to go to the **Select Target Connection** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-TargetConn.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=L86h0%2FMBIiZtIm8t8mMokxOC2Gc9maL7CNmcYmbL3W4%3D) 14. Choose a target source name from the drop-down list that includes all the target connections you have created. 15. Choose the table to which you want to replicate from the drop-down list. If no tables are listed, you need to exit the wizard and add or create a target table. 16. If you want more information about the table before proceeding, click **Open Table...**. 17. Click **Next** to go to the **Set Mapping Info** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-MappingInfo.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=nM%2Bu9PAcOJCjO6bmuFlKzns0DInzFrcWHP9iHC8tDdg%3D) Source and target columns with the same name are automatically mapped. You can also map columns by dragging the source column and dropping it on the target column, or you can map a column to an expression. For more information about mapping, check the [Replication Wizard help topic](/v1/docs/replication-wizard#set-mapping-info). An alternative is to [write a script](/v1/docs/writing-scripts-in-syniti-replicate) to set mappings at runtime. 18. Click **Next** to go to the **Scheduling** screen. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ReplicationWizard-M-Scheduling.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=5%2Ba%2BrP99D%2F1cr1FnVWfxYHz%2FLYQu7yeGGfMqihqTkzw%3D) 19. Make sure the **Enable Replication** option is checked. This is required for the replication to run. 20. Set a start time for the replication. The **Start Time** field indicates the time at which the Replication Agent will begin considering the replication for execution. 21. Check the option to **Execute Refresh** if needed. If you check this option, a full replication will be performed from the source to the target table, prior to starting the mirroring process where only incremental changes will be replicated. 22. Go to the **Mirroring Schedule** tab. 23. Select how you want to run the replication: - Run Continuously: the transaction log will be checked for changes to the table using the frequency that you specified on the Set Log Info tab. Any changes will be replicated to the target table. - Schedule Interruptions: the replication process will run as above, except for interruptions specified when you click the Add button in the [Scheduler dialog](/v1/docs/scheduler-dialog). 1. Click **Next** to go to the **Summary** screen. 2. Click **Finish** to complete the wizard. ## 4. Run the Replication If you installed The Replication Agent as a service during setup, you just need to start the service using the Service Monitor program ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/13cbc988-782e-4723-b64f-ade272f303be.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=0OlUHb6xW3A8yJmYWUjWQyf5T0%2FOT0o2IR0Pkc0AUFM%3D) in the Windows Notification Area. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/DBMotoServiceMonitorMenu (1).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=AWn3Gse1KfjJYeJWkCEn4deGD63QPEi4WAHlumrTr54%3D) The replication that you have scheduled should start at the specified time. Use the [Replication Monitor](/v1/docs/replication-monitor) tab in the Management Center to track the progress of the replication. If you would like to install the Replication Agent as a service: - From the Windows Desktop menu, choose **Syniti Replicate**, then **Service Installer**. - Manage the service from the Service Monitor program (located in the Windows Notification Area ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/13cbc988-782e-4723-b64f-ade272f303be.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=0OlUHb6xW3A8yJmYWUjWQyf5T0%2FOT0o2IR0Pkc0AUFM%3D), or on the Windows menu under **Syniti Replicate**). - Use the [Replication Monitor](/v1/docs/replication-monitor) tab in the Management Center to track the progress of the replication. To run the Replication Agent interactively: - In the Windows Notification Area, select ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/13cbc988-782e-4723-b64f-ade272f303be.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A15%3A49Z&se=2026-11-17T20%3A15%3A49Z&sr=b&sp=r&sig=0OlUHb6xW3A8yJmYWUjWQyf5T0%2FOT0o2IR0Pkc0AUFM%3D) the Service Monitor icon. - From the right mouse button menu, choose **Replication Agent**, then **Start** then **Application**. The replication that you have scheduled should start at the specified time. - Use the [Replication Monitor](/v1/docs/replication-monitor) tab in the Management Center to track the progress of the replication.