---
title: "Set up DataSync Agent to share to MS SQL Server or MS Azure SQL"
canonical: "https://docs.perspectium.com/space/Krypton/720915/Set%20up%20DataSync%20Agent%20to%20share%20to%20MS%20SQL%20Server%20or%20MS%20Azure%20SQL"
format: markdown
---
You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to a Microsoft SQL Server database or a Microsoft  Azure SQL  database by changing some additional  configurations in your  agent.xml  file . Since Azure SQL is Microsoft's cloud database service of SQL Server, the DataSync Agent configurations are the same as configuring to connect to a SQL Server database you host.   NOTE :  A DataSync Agent configured to share to a MS SQL Server database or a Microsoft Azure SQL Server database will create large fields (fields defined with a size of 251+ characters) with a searchable  nvarchar(max)  data type. Prerequisites  First, you will need to  install DataSync Agent .  You will also need to  create a ServiceNow dynamic share/bulk share .   Make sure to  stop running your DataSync Agent  before making any Agent configuration changes.   Finally, you will need to create a database in the server you choose, MS SQL Server or MS Azure SQL Server, that will store data replicated via the DataSync Agent. Procedure To set up your DataSync Agent to share application data to a MS SQL Server database or MS Azure SQL Server database, follow these steps: