Add the <skip_database_creation/> directiveLocate the <task> directive(s) in your <subscribe> directive, nest the following directive: | Directive | Description |
|---|
| <skip_database_creation/> | Bypasses the dynamic creation of the replicated database  NOTE: This directive is added for an MS SQL Server replication scenario with the DataSync Agent, as you must create the database used for replication in MS SQL Server before configuring your DataSync Agent
|
Your agent.xml file should look similar to the example shown below: | Code Block |
|---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances="4">
<task_name>servicenow_to_mssqlserver</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.test" use_basic_consume="false" user="exampleuser">https://example.perspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="test.user">https://myinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>sqlserver</database_type>
<database_server>localhost</database_server>
<database_port>1433</database_port>
<database_user>perspectium</database_user>
<database_password>perspectium123</database_password>
<database_paramsparms/>
<database_column_max_size>251</database_column_max_size>
<database>psp_repl</database>
<skip_database_creation/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config> |
| 
First, you will need to install a DataSync Agent.