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
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
Subscribe to:
Posts (Atom)