For DataSync Agent integrations using MSSQL Server, a configuration option is available to have dynamic database ports. The database_port directive can be nested within each task directive of the agent.xml configuration file for the Replicator Agent. Configuring your Replicator Agent in this way allows you to specify an instance name that will be compatible with dynamic MS SQL Server database ports.
Procedure
To configure dynamic database ports for your Replicator Agent integration with MS SQL Server, follow these steps:
Access agent.xml
Navigate to the directory in which your agent.xml file was saved upon installation of the DataSync Agent. Then, open the agent.xml file in a text editing application.
Add directive
Within each database_port tag, add \DATABASE_INSTANCE_NAME as this directive's value, where DATABASE_INSTANCE_NAME is the name of your MS SQL Server database instance. Your <database_port> directive will look like the following example:
<database_port>\PRODUCTION</database_port>
Save agent.xml
Save the agent.xml and start the agent.