Hi,
I have a requirement of Iinserting data from one of our SharePoint Online Lists into an on-premises SQL server Rable (different environment) and vice versa. I need assistance in achieving this by using a provider-hosted App, preferably. Can anyone please help me out in this ? Thank you
Kind Regards
Mukti ranjan
Hi Vadim,
Yes SQList does exactly that. There is a fully working version you can download here:
http://www.axioworks.com/sqlist/try-sqlist/
I’ll drop you a message with regards a demo.
Kind Regards,
Paul.
By the way, drop me a message on here if you’d like me to arrange a product demo
Hi Mukti,
We have a product called SQList that will synchronise SharePoint lists and libraries to normalised SQL Server tables. It runs as a windows service and you configure replications using a UI. Once configured, the service will generate correctly typed SQL schema and keep the data synchronised. As new columns or list items get added to SharePoint they will automatically be added in SQL.
It’s also possible to run the software from the command line in order to do one-off exports and scheduling via windows task scheduler or any other enterprise scheduling system.
Other features include the ability to export similar lists across a SharePoint site collection and SQList will automatically build SQL views of all these lists. You can also use the product to archive SharePoint data to sql server (and then delete the items in SharePoint)
It works with all versions of SharePoint and SQL Server including SQL Azure so it’s possible to pull data from SharePoint online and push into SQL on-prem. It uses standard http(s) connections to SharePoint and standard SQL connections so you can install it anywhere (providing there is access to SharePoint online and SQL Server).
More information about sqlist can be found here:
http://www.axioworks.com/sqlist
You can download a fully working version here:
https://www.axioworks.com/sqlist/try-sqlist/
If you have a SQL database that is available online you can also try our free online export tool that is based on the SQList synch engine. This allows you to do one-off exports of cloud-based SharePoint lists and libraries to internet accessible SQL Server instances (or we can create one for you).
You can try the online tool here:
http://www.axioworks.com/sqlist/sqlist-online-free-sharepoint-online-to-sql-server-exports/
Regards,
Paul.
HI Paul,
I am looking to move Custom server side code that I have written for SharePoint 2010 as a custom webpart to SharePoint online. I am looking to store data in SharePoint online list but a way to display all data from SQL Azure or on-prem to SharePoint online as a gridview. I also need a feature where user can edit/modify/update rows (just like gridview) and save it back to SQL.
Do SQL List does that? can we schedule a demo if answer is yes?
Thank you!