The SQL Point - gives you the SQL view of Microsoft's SharePoint

A few pieces of helpful information:

Connecting to your database

 

Built-in SQL queries

 

Running your queries

 

Browsing table level data

If you install SQL Point on the same machine as SharePoint's SQL Server database, then a connection via the (local) alias using integrated security will be achieved automatically upon first starting the application. However, if your current windows login does not support integrated windows authentication to SQL Server, or your organisation uses SQL Server authentication, then the SQL Point application will prompt you to input your required connection parameters.

 

The current release of SQL Point comes packed with more than 50 built-in SQL queries allowing you to examine your SharePoint SQL Server database schema in dozens of interesting ways. You can get summarized document types and count reports along with document instance size and content related outputs.

Future updates to SQL Point will include more built-in SQL queries across all function groupings.

 

SQL Point includes a special function to allow you to input your own SQL queries and execute them directly against your SQL Server hosted SharePoint content database. SQL Point is a SQL Client as well as a SharePoint database browser and database explorer.

Future updates to SQL Point will include a customisable library function to allow you to store your queries for re-use, so watch this space.

 

You can right-click table nodes in a tree view listing to open each table to browse its data. Additionally, you can browse table-specific documentation that describes each field in each table to help clarify the overall data schema.

Future updates to SQL Point will include the ability to fully export table datasets, so watch this space.

SQL Point - designed by data people, for data people.

Back to downloads

Copyright Coldbeancreations Ltd 2010. Leeds, UK.