DataSync Studio allows you to publish SQL Tables to SharePoint and keep them in sync with each other. So while I was working on a SSIS Project I thought it would be really cool to manage the Configuration Settings in SharePoint.

So the first thing is to use Data Sync Studio to Connect the SQL Table to SharePoint and define the mapping between the List Columns.

Then configure the List Synchronisation Service and get it running, next just save the Data Sync Project file into the Sync Service Monitor Directory and your done.

Now it's really easy for me to create SharePoint views for each of the SSIS Configurations that I have i.e. 'DEV', 'UAT', 'LIVE' and I can also enable Version Control and Configure who has access to update the items. Now I don't need to create an application to edit the settings or give someone instructions on how to use SQL Management Studio.

To be part of the BETA Program for DataSync Studio please drop me a line at sales[at]simego.com