@CSantil the MS SQL Server for HubSpot app syncs data one way (from HubSpot to a SQL Server database in Azure). The SQL database is included with the app subscription.
If you want to sync data one way from HubSpot to your own SQL Server database (cloud hosted), there is another app called Database Sync for HubSpot that you can use. Both of these apps are available through the HubSpot App Marketplace.
However, if you want to sync data the other direction (from your own SQL database TO HubSpot), we recommend using the Census or Hightouch apps. Both are in the HubSpot App Marketplace and both have free service tiers.
Finally, if you want to sync data both directions (between HubSpot and SQL) a service like Skyvia would be more appropriate.
DM me if you have any questions about the above.