Announcing SQList V3 with SharePoint Online Support

/in /by

Now also supports SharePoint Online in Office365!

We are pleased to announce version 3 of our SQList product, a lightweight Windows Service that can be installed anywhere and will replicate SharePoint lists, libraries and files from SharePoint (Online and OnPremise) to a normalised set of SQL Server tables that are built dynamically.

Features include:

  • Support for SharePoint 2007, 2010, 2013 and SharePoint Online in Office365
  • Exports all the lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database;
  • Selective replication: precisely control the lists and files you wish to replicate;
  • Parallel list sychronisation: replicate multiple sites and lists in parallel for enchanced performance;
  • Continuously updates the target SQL tables (data and structure) as your SharePoint site changes, every few seconds, or on a schedule you define;
  • Builds an indexed SQL table for each list or library on the fly;
  • Exports attachments and documents, as well as list data, and stores them as binary objects in the target SQL database
  • Runs as a lightweight Windows service that can be hosted on almost any Windows server or desktop PC;
  • Leverage the low cost, rapid assembly and advanced UI, workflow, document management, collaboration features and access control of SharePoint to manage content, data, and documents for your application

Using SSIS to Export Lists from SharePoint to SQL Server – An Alternative Approach

/in /by

If you are looking at exporting SharePoint List data to SQL server then one of the most common approaches is to use SQL Server Integration Services or SSIS to get the job done the steps are something like:

THIS IS A LONG AND PAINFUL PROCESS!
 
What’s more you will need to make changes every time your SharePoint list schema changes.
THERE MUST BE AN EASIER WAY? YES THERE IS!
What if I could show you how to set up continuous export of SharePoint list and library data including all blobs and attachments from MULTIPLE SharePoint lists and libraries in 5-10 minutes?  What if I told you this could also keep the SharePoint lists and library schemas up to date in sql server in normalised SQL Server database tables.
Take a look at AxioWorks SQList which is a lightweight windows service that requires no changes to your SharePoint infrastructure. It works with SharePoint 2007, 2010, 2013 and SharePoint online in Office365.  It will selectively replicate lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database.
Below is a demo of how you can get your SharePoint lists, libraries, files and attachment into normalised sql server databases and continuously replicate them in just a few minutes:

Continuously Exporting SharePoint Online and SharePoint OnPremise Data to SQL Server – A Demo

/in , , /by
In this demo video I will explain how we can use AxioWorks SQList to continuously replicate SharePoint OnPremise and SharePoint Online list and library data to normalised SQL Server tables. 

I’ll show how easy it is to set up this continuous replication, how we can install AxioWorks SQList anywhere and how we don’t need to make any changes to our SharePoint farm as well as showing some of the ways we can use our SharePoint data form SQL Server.

Please feel free to download a 30 day fully functional trial of AxioWork SQList which will allow you to replicate your own SharePoint data to SQL Server.

Visit us at SharePoint Saturday UK!

/in /by

We are pleased to announce that we will be launching SQList v3 at SharePoint Saturday UK on November.

SQList v3 will make it possible to continuously synchronise lists and documents from Office 365 SharePoint Online to normalised SQL databases. Think about the possibilities!

What is SharePoint Saturday UK?

SharePoint Saturday UK is a FREE one day conference about SharePoint and Office 365. The event is open to the public and is your local chance to immerse yourself in the SharePoint and Office 365 platform.

SharePoint Saturday UK is dedicated to educating and engaging members of the local SharePoint and Office 365 community. SharePoint Saturday UK draws upon the expertise of local and international SharePoint IT professionals, developers, architects, and users who come together to share real world experiences, lessons learned, best practices and general knowledge with other individuals.

Where and When will SharePoint Saturday UK be held?

Hinckley Island Hotel

Hinckley
A5 Watling Street
Burbage
Leicestershire
LE10 3JA

View the event location on a map

Saturday, November 29th​, 2014

Who Should Attend?
SharePoint Saturday UK is open to the public! Local Administrators, Architects, Designers, Developers, End Users, Project Managers, Business Analysts and Business Users are encouraged to attend. Anyone interested in learning more about SharePoint and Office 365 and growing their knowledge should register!

How much does it cost to attend?
Have we mentioned that SharePoint Saturday UK is FREE? Well It is and it’s open to the public and is your local chance to immerse yourself in SharePoint and Office 365! A light breakfast (coffee, tea, muffins, pastries) and lunch (sandwiches and salad) as well as light refreshments throughout the day will be provided to all attendees, speakers and sponsors for FREE!

Please note that SharePoint Saturday UK is free to attendees due to our generous sponsors who support our event, please help us to keep putting on these events by opting in to sponsor contact and by visiting sponsors websites and their booths on the day – thanks!.

Questions / Comments / Contact Info​
General Email: spsaturdayuk@gmail.com