Questions tagged [database]

A usually large collection of data organized especially for rapid search and retrieval (as by a computer).

Filter by
Sorted by
Tagged with
2
votes
0answers
611 views

Best way to create a Relational Database App in SharePoint 2010

I have a company using SharePoint 2010 wanting a SharePoint based database and UI with about 10 tables, all linked with foreign key relationships. My preference would be to simply write a normal ASP....
0
votes
1answer
822 views

Using DataBase First Approach with EF in SharePoint?

I have seen here and there that Entity framework and Linq works with SharePoint. But can we use Entity framework Database first approach in SharePoint? http://cdn.rssbus.com/help/RS3/ado/...
0
votes
1answer
107 views

How to make web database that will collect data from sharepoint calendar in real time?

I want to make database out of data users' input in project calendar. Basically every user types in working hours in project calendar (how many hours each day they had worked on that specific project) ...
1
vote
0answers
112 views

Using a InterSystem Caché database in SharePoint? [closed]

I have searched for any kind of database compatible with SharePoint and at this point I haven't found anything. I've searched on google and msdn. Google gave me this only thread about my question : ...
0
votes
1answer
102 views

Moving content and service databases

We have 2 environments: one for production and one for testing. These two environments are not in sync. I have been given the task to copy content from production to test environment, and also to ...
0
votes
1answer
611 views

Using SharePoint to hold a Leaderboard for a game

We are creating a very simple game (Flash based) that we wish to host in a SharePoint environment. We want to get score details from the Game to display a Leaderboard of high scores within the ...
0
votes
1answer
50 views

WebPart/General Database access performance best practice

I'm looking for a way to improve my to access the database from WebParts. Right now, each and every single time i need to get/set some data from the database (either with linq or with System.Data....
1
vote
1answer
1k views

What's the best way to extract data from Sharepoint to SQL server database?

The source data are from MS Project on SharePoint. The business would like to see the updates of MS project near real time. We have the reports pulling the MS project data off SQL server database. ...
0
votes
2answers
611 views

SQL initial Size and Autogrowth

We want to use SharePoint for document and workflow management, for now we have about 200 GB document, pictures, videos on file server that is used by user in there daily works and must be accessible ...
0
votes
0answers
242 views

Site Collection does not exist in database. Site collection will not be moved

I am trying to move the site collection http://<webapp>/dealers/1020 from content database WSS_Content_2 to WSS_Content_7 I run the command: Move-SPSite http://<webapp>/dealers/1020 -...
3
votes
1answer
915 views

Restore/Import Managed Metadata from another SP 2013 Farm

My situation: SP2013 Farm A: Managed Metadata Service Application with database named "ManagedMetadataDB" SP2013 Farm B: Managed Metadata Service Application with database named "ManagedMetadataDB" ...
1
vote
1answer
127 views

How to write data to a MySQL or SQL database?

I want to crypt a string and then store the result in a MySQL or SQL database with Sharepoint (so I can later take that value and use it inside a PHP application). Can I connect to a database and ...
2
votes
2answers
4k views

How do I access data in SQL via Sharepoint 2013?

I'm not a SharePoint developer, but I have developed some small ASP/VB.net web pages. Basically, prior to using SharePoint, I have developed a basic portal that pulls data (VB.Net) and sends it to ...
2
votes
0answers
2k views

SharePoint 2013: Event ID 2: Session “SharePointDiagnostics” failed to start with the following error: 0xC0000035

We're on 2013 CU 3/15 and I'm seeing this error once/twice a day on one of our front end servers. Event ID 2: Session “SharePointDiagnostics” failed to start with the following error: 0xC0000035 I'...
0
votes
2answers
549 views

Is it possible to run/ install sharepoint on MySQL

as in the title you can read, I wonder if it is possible to install and run SharePoint (does not matter what version) on an other SQL-Platform than Microsoft? For example: MySQL, Oracle SQL, etc. ...
2
votes
2answers
6k views

Increase number of content database for one site collection

I am using SharePoint 2013. Is there any way to create more than one content database for one site collection? Is there a way to increase the size limit of a content database using RBS or any ...
0
votes
1answer
584 views

Content Database(Size) when using RBS

When using RBS what is the total size limit that can be uploaded to SharePoint? Is there any size limitation concerning the data? When I right click on my content database that enable RBS it shows ...
2
votes
0answers
617 views

How SharePoint works with Infopath and an Access database?

I have a database already created in Access. It has a form which uses queries with macros to export an excel with the information chosen from the form. SharePoint would be the perfect tool to share ...
0
votes
1answer
2k views

A Web Application, multiple Site Collections and multiples databases

It's possible have a Web Application with many Site Collections and multiple databases? One database per Site Collection? All this in a existing SharePoint 2013 Thank you guys.
0
votes
2answers
38 views

Architecting and SharePoint 2007 Upgrade to 2010

I'm planning a migration/upgrade to SharePoint 2010 from 2007 for our intranet. I'm researching best practices for information architecture to best optimize performance and organization. The farm is ...
0
votes
2answers
3k views

How to retrieve Sharepoint List in Sharepoint App? “List does not exist at site with URL”

I have my app and my list in my site contents like so: From my app, I'd like to read, write, and manipulate the data from TestList. The contents of TestList are like so: I've been trying to read ...
0
votes
1answer
117 views

My site and properties from external sources

We have an on premise SharePoint 2013 farm. In setting up mysite, we will only retrieve username and picture from AD, all other properies for profiles we need to get from another database that is ...
1
vote
0answers
247 views

Migrate Workflow Manager 2013

Anyone can provide an official article / good resource on how to migrate SharePoint 2013 workflows from one farm to another?
1
vote
1answer
379 views

How do I create a column that auto generates a number in sequence?

There are multiple users key-ing information regarding candidates on our Recruitment Database. However, I want a "Candidate number" field automatically generated every time a new line item is created. ...
2
votes
2answers
7k views

SharePoint 2013 content database size for single site collection

We have a web application with single site collection and one document library, mainly used for uploading supporting business documents (.pdf, .doc and .xml). Current content DB size is 160 GB with ...
0
votes
2answers
312 views

Ms Access Web DB (Access Services) GotoControl functionality broken

I am developing a web database in Access 2010 and uploading it to our Sharepoint 2010 server. I found a bug in a simple macro command that only exists in SharePoint. The command is "Gotocontrol" in ...
0
votes
0answers
109 views

Simplest way to connect a Visual Studio SharePoint App to my external Database

Hi all new to developing for SharePoint. As the title indicates I want to connect my Visual Studio SharePoint App that I have created to my external database. I have created the app and it works in ...
1
vote
1answer
76 views

List Employee Certifications

My company has about 30 employees and I'm trying to create an easily-accessible method for everyone to view each other's certifications (type, cert #, exp. date, etc.) but I'm not really sure what the ...
1
vote
2answers
1k views

How to get config database server programatically?

I would like to use C# to get the server name and instance (e.g. myserver/instance1) where configuration database of the local farm resides. I don't want to use PowerShell. Is there a way to do this ...
1
vote
3answers
436 views

Sharepoint 2010 and 2013 on same SQL Server

We have a Sharepoint 2013 installed with SQL database Cluster and our old Sharepoint 2010 databases should also be moved to the new SQL database Cluster but not migrated to Sharepoint 2013. I have ...
1
vote
3answers
3k views

Restoring the config database

So, restoring the config database is not recommended, but what happens if you do it anyway? In theory, things could be out of sync, but in actuality, what exactly could get out of sync? So, for ...
1
vote
1answer
4k views

How to bring down/reduce the SharePoint DB Server memory usage?

For our SharePoint 2013 application, we are using 2 Web Servers 2 APP 2 DB One of the DB server memory usage is about 78%. (Windows Server 2012 with 16 GB RAM, where sqlserver.exe takes upto 9 GB) ...
0
votes
1answer
1k views

Database is in compatibility range and upgrade is recommended

In my farm I installed the SharePoint 2013 directly, and I didn't had any older SP system in the farm. I am not sure why i get the following error message : The following databases have versions ...
1
vote
1answer
138 views

SharePoint_Config_Log fast increase in size

the SharePoint_Config_Log size is taking a lot of space really fast i need to make stop at least make go slower. am i missing anything?
0
votes
1answer
6k views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
0
votes
2answers
618 views

confused about database attach upgrade from 2010 to 2013

I am in the process of a test upgrade from 2010 to 2013. I have set up a new test farm and I want to start attaching databases to the test farm but I have a few questions I can't figure out. What ...
0
votes
1answer
413 views

Is it possible to deploy a Sharepoint Foundation content database to Azure SQL Services?

We are starting a new project and to be costly effective we need to use Sharepoint Foundation 2013. We are planning to deploy both Sharepoint and Database to cloud. For Sharepoint we will use a ...
1
vote
1answer
6k views

Does sharepoint online support external Data sources

We are looking to migrate to sharepoint online from our current on premise installation and currently have one question that is still unanswered. We use custom WebParts (which we will need if we ...
2
votes
1answer
54 views

Is reading from SP Databases supported through Open Specifications?

Microsoft has documented certain things as part of their Open Specification. This includes SharePoint, like MS-UPSSDSP (PDF) which is documented as Specifies the User Profile Social Data Stored ...
0
votes
1answer
434 views

SharePoint Foundation 2010 with SQL Server 2008 R2 SP2 - compatibility?

I have to upgrade SharePoint Foundation 2010 databases SQL Server 2008 R2 to SP2. If SharePoint Foundation 2010 is full compatibility with SQL Server 2008 R2 SP2?
0
votes
1answer
85 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is unavailable/...
1
vote
1answer
106 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
0
votes
1answer
91 views

Playing with SP Database, will it break SP directly?

I am ready about SharePoint databases and what could happen if someone messes with them, all I've seen is that they can affect the upgrade of SharePoint because messing with them could change the ...
1
vote
1answer
389 views

Infopath Form does not work in Sharepoint

I have a form that has 3 Data Connections. Main Data Source (Active Directory) Secundary Data Source (SOAP Web Service) Secundary Data Soruce (SQL Database) I fetch data from AD, from a Web Service ...
1
vote
1answer
159 views

Can multiple MS-Access 2007 front ends be linked to an SQL Server 2008 backend on Sharepoint?

I have several computers at different locations, each with their own copy of an MS-Access 2007 front end. Each copy links to an SQL-Server 2008 back end on a server. I would like to migrate the back ...
3
votes
1answer
139 views

SharePoint 2010 Form Integration with iPad App

This might be an odd question and honestly I don't know if it is possible or not. I have a client that is wanting an iPad App form which we developed to be synced/integrated with a SharePoint 2010 ...
3
votes
1answer
167 views

How to check whether Content Database is read-only or not?

How to check whether Content Database is read-only or not using client context ? we can easily get using server object model but how to do this with Client Object Model
2
votes
3answers
4k views

How to clear WSS_UsageApplication content?

We've been using Sharepoint 2013. My question / problem is : The database is about 35 Gb and a shrink db on an SQL level didnt help. How to clear WSS_UsageApplication content?
0
votes
3answers
984 views

What is best way manage SharePoint webpart access to database?

I have my custom webpart, which have access to database. I need to configure data source, catalog, username and password, which allows webpart a access database. I don't want that users can see, what ...
1
vote
1answer
80 views

Is it Possible for data to flow thusly?: Infopath form to Access database to Sharepoint list

We have a department that could solve their issue with a post-it. Instead, they would like a form where people could enter data, and the data would pass to an Access DB, which would be tied a SP 2010 ...