Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Wednesday, July 24, 2013

Multi Database Management Tool

Multi Database Management Tool supports Microsoft Access, Excel, SQLite, Firebird, dBase, FoxPro, OData, Generic OLEDB, Generic ODBC, SQL Server, LocalDB, SQL Server Compact, SQL Azure, MySQL, Oracle, IBM DB2, IBM Informix, PostgreSQL, Sybase ASE. It can be used to SharePoint 2013 OData queries. Check this link: http://fishcodelib.com/Database.htm

Sunday, June 29, 2008

SharePoint Databases

Configuration Database (configdb)
WSS creates configdb at the time of installation. There will be only one configdb per server farm. configdb is used to store settings for Sites, Databases, Servers, Web Application

Content Databases
You can have one content database per web application, but you can span sites across multiple content databases. Content Databases is used to store site collection and its content.
Site Details, Structure Details, User Content, Files, Security Information

Shared Services Provider (SSP) Database
One SSP database created per Shared Service Provider. It is used to store User Profiles, Audience Data, Business Application Data, Excel Services Function, Site Usage Data,Infopath Foms Services session state information

Search Database
MOSS 2007 uses separate search database to store search data. It is separate from SSP database. One search database is created per SSP. Search database is used to store Search Data, History Log, Search Log, Crawl Statistics, Links tables