Creating requisites for transactional replication

Transactional replication involves the direct synchronization of data between two or more sites within the same intranet. The replication itself either can be table-to-table or can use the RemoteMethodCallSp stored procedure to invoke stored procedures on other sites. Transactional replication is used almost exclusively in multi-site environments.

  1. Use the Replication Categories form to verify that a replication category exists that meets your needs for replication.
    For transactional replication, you can use the Site Admin category that is provided.

    If the Site Admin category is being used already, you must create a new category.

    Caution: 
    We strongly recommend that you contact Infor Consulting Services for assistance before creating (or attempting to create) your own replication categories.

    Verify that the Replication Transfer Type field is set to IDO XML.

  2. Use the Intranets form to define the intranets that group sites that are to coexist on your network.

    For example, if you are running two sites and they are on the same LAN, define them in your application to use the same intranet, so that you can use transactional replication at run time.

    Note: 
    • Groups of databases cannot be defined in the same intranet if they are to replicate data but are not on the same version of the application.
    • If you plan to set up shared tables and a master site for an intranet, do not use these steps. Instead, see Setting Up Multi-Site Shared Tables.

    Any intranet used for transactional replication must have these specifications, at a minimum:

    Intranet
    Specify the name to identify the intranet, for example: InforTransRep
    Description
    Optionally, provide an appropriate description.
    External
    If you are using replication for table-to-table replication within the intranet, clear this check box.

    If you are using replication that involves calling stored procedures on a remote site, select this check box.

    Transport
    Select HTTP.

    Other active fields on the Intranets form are optional. For information about them and how they are used, see the help topics for the individual fields.

  3. Set up your sites:
    Each site can have a system type, or application version number, associated with it. Use the System Types form to list the system types you are using. For example, you might go to a higher version of the application for one of your sites, but still be using a lower version at another site.
    1. Use the Sites form (or Sites/Entities form) to define your sites and to determine the relationships between the sites. You could also temporarily disable replication for a site from this form, if necessary.
      At a minimum, on the System Info tab, provide these specifications:
      Time Zone
      From the drop-down list, select the appropriate time zone for this site.

      The time zone you specify for the site is independent of the time zone for the server.

      Database Name
      Provide the name of the application database to be used for the site.

      If the server name or database name contains a dash, enclose the name in brackets. For example: [SL900-DB].

      And, on the Link Info tab, provide values for these fields:

      To Site
      From the drop-down list, select the site to which the data is to be replicated.

      The list shows all sites defined in this form, including sites not in the current site's intranet.

      Linked Server Name

      Provide the name of the remote server where the application database for the To Site resides. The linked server name is usually the actual name of the database server for the To Site.

      If you are performing transactional replication between sites on different database servers, the server name is verified against the list of linked servers in the current site's SQL server master database. If you get a verification error, you must manually create a linked server definition in the SQL server master database of both the current site and the To Site. You can create a linked server definition using SQL.

    2. Optionally, use the Site Groups form to define a group of sites.
      This is usually done only when setting up a multi-site environment.
    Other active fields on the Sites form are optional. For information about them and how they are used, see the help topics for the individual fields.
  4. Set Replication Rules for each site and category where replication are to be performed.
    If you are working with multiple sites, you must have replication categories and rules defined for each site.
  5. Regenerate the replication triggers.