Hot answers tagged database
8
As James mentions it's not a valuable comparison as it's two completely different tools. No "SharePoint is not a database" and no "SQL is not a collaboration, document management, ... platform".
But to answer your question only point 7 and 8 has been changed (fixed) in SP2013.
For more information: Here is my take on the eight points:
Primary and foreign ...
6
James is so right, it's not SharePoint vs SQL Server, it's a matter of using the right tool for the right business needs but to go deeper in these assumptions
Cascading Delete / Primary & Foreign Keys are available since SP2010 and handled through built-in features like :
Unique Column policy
Joins between lists
Projected Fields
Relational ...
6
Apologies if this doesn't directly answer your questions, but I think the main point to be made here is that SQL databases and Microsoft SharePoint solve two completely different issues.
Can you store documents and collaborate with people using SQL out of the box?
Can you find colleagues with similar skills, interests who have uploaded documents you are ...
5
In terms of technology opportunities and capabilities you could :
1. Create your own Visual Studio BDC Model where you could create your own Entities, with relationships mirroring your configurations - additionally you could rely on Stored Procedures for various operations not available otherwise, e.g. Updates across multiple tables, View selecting from ...
5
SharePoint will store the full copy of any document/page for each version of that document/page. In some cases (as with Wiki pages), SharePoint will highlight content to show what changed from version to version, but with documents and pages, the entire file is stored in the content database. This is why storing multiple different versions of large documents ...
5
SharePoint always stores the full file. It never tries to do diffs.
I haven't seen it documented regarding Site pages anywhere but if you ON A DEV BOX tries this:
Create a new Team site with relative url "Team"
Modify Home.aspx in SharePoint Designer
Turn on Major/minor versioning of "Site Pages"
Check out Home.aspx
Modify Home.aspx in SharePoint Designer
...
3
It's make me to laugh sometime when i look at SharePoint the way programmed.
My scenario really sucks, We have a huge 1.3 Tera (single) content database, and we thought we need reduce the size the share point be faster,
We planned to create a custom to archive old content/documents to the separate record center and it's archived, here comes the truth the ...
2
You'll likely want the SharePoint Products and Technologies Protocol Documentation. These contain descriptions about the database structure, including table schema, sprocs, and so forth... Along with a lot of other information. And as everyone else has noted, making changes is, for the most part, unsupported. Check out KB841057 for more information on ...
2
That's not something which is simple in SharePoint
Without code your only option is to create a workflow on the second list which on create/update of items find the corresponding entry in the first list and updates the dates left. But it'll not add them back again if the entry is deleted.
If you extend your arsenal to include code, then you have the ...
2
This should not be hard, here is pseudocode:
Connect to this database and retrieve all the rows in this table
Connect to the desired SharePoint Site Collection (SPSite)
Foreach row in rows
Add a web site under SPSite.RootWeb.Webs using Add method
For more details check SPSite, SPWeb, SPWebCollection objects and SPWebCollection.Add methods.
2
I had a similar issue with an application I was working on at work. I tried customizing the BCS input pages, writing my own BCS data access components (makes the data access overly complex), and a few other options including LINQ to SQL in a custom web part.
Ultimately, what I ended up doing was creating an external (WCF) web service hosted outside of ...
2
Depending on how much if any of the external list / content type features you are looking to use I would be on board with Marius as far as avoiding InfoPath and the BCS goes.
In a situation like this I would create a custom web part and use plain old ASP.NET combined with the data access type of your choice (Entity Framework, LINQ to Entities, SQL / Stored ...
2
The procedure described in these articles should work just fine. I've done this multiple times.
You don't need to install the SQL Management or Client Tools on every SharePoint server. Just us the cliconfg.exe program to setup the alias. You can find more information on my blog at:
http://thomasvochten.com/archive/2009/03/using-sql-aliases-with-sharepoint/
...
2
Yes it is possible. (based on readings, I never done it myself)
You will need to create WCF web services and then use them as external content in your BCS to create an external list in your SharePoint environment (which I assume is SP 2010).
Or you can utilize StreamAccessor as explained in article below,
Accessing BLOB Data from External Systems Using ...
1
step by step guide:
In this walkthrough we will demonstrate how to integrate DB2 database
with Microsoft SharePoint 2010 through ODBC and display DB2 data on
SharePoint 2010 page. In order to do that we will describe how to
create a new external content type by means of BCS Meta Man.
1.Prerequisites:
1.Microsoft SharePoint Server 2010
...
1
try the following to fix the last error and then do the psconfig command again:
1.stsadm -o setproperty -pn command-line-upgrade-running -pv No
2.IISReset
3.Restart the Windows SharePoint Timer
4.psconfig –cmd upgrade –inplace b2b –wait –force
...
1
If you aren't able to write the script yourself, it may be time to hire a consultant. Otherwise you're looking at a manual process.
The method that would take the least amount of clicks in a manual move would be:
1) Open the file share in Explorer in one window.
2) Browse to the destination document library in SharePoint in your browser.
2007: ...
1
I havent done this before and would like to know how it goes and your solution. The solution i found sounds a bit long winded but solves the problem... if you read through there are two solutions you could try.
I wish i could help you more but im no system admin but here is what iv found:
solution 1:
I think you many change the default server from ...
1
the best way to do this is to configure BCS (Business Connectivity Service) to fetch data from external database to SharePoint and than work on the lists and libraries SharePoint.
Here are some articles to read:
http://zimmergren.net/technical/sp-2010-getting-started-with-business-connectivity-services-bcs-in-sharepoint-2010
...
1
The databases will exist, you're just looking in the wrong place, or they might be named something different or something unique to your environment. The Site Content DB is normally WSS_Content_[GUID]. The fact that you were able to create the site in Central Admin confirms this.
Make sure you can visit the site in the browser, and that you have access to ...
1
You are on the right tracks with two lists and a parent-child relationship.
The tricky part is to keep track of the number of days left. You could have a workflow update the count, but what if the request later gets deleted? Workflows don't run on deleted items, so you're stuck. A workaround is to disable item deletion, and have a choice field for ...
1
In researching for a similar problem, I've come across two different ways to get usage data from the MOSS 2007 Shared Services Database (db where the ANL* tables are located). They both query the database but in different ways:
The SharePoint is not enough blog provides a sample query against the 'ANL' tables on how to view the most popular documents in a ...
1
I usually see this error message when the Windows Firewall is blocking access to SQL Server. Did you open the correct port?
You can check if you can reach your SQL Server via an alias by using a little trick I describe on my blog ("Testing Your Alias" at the bottom of the article):
http://thomasvochten.com/archive/2011/06/sql-aliases-in-the-real-world/
If ...
1
I had this issue - a 15Gb Sharepointxxx_log.LDF file despite not using Sharepoint. To reset it to the initial default size (Windows will recreate it):
Stop the Service "Windows Internal Database (MICROSOFT##SSEE)"
Delete the .LDF file in 'C:\windows\SYSMSI\MSSQL.2005\MSSQL\Data'
Restart the service
I also deleted the other large file in there - forget ...
1
Why not simply using Central Admin... :-)
(works even if you do NOT have access to either the physical server (console) or databases server.
Central Admin -> Upgrade and Migration -> Review Database Status.
By pasting /_admin/DatabaseStatus.aspx at your CA url.
Rgds, Arjan Vos
Only top voted, non community-wiki answers of a minimum length are eligible
