Hot answers tagged

5

This is completely unsupported! Do not read or write data to SharePoint databases. You need to go through the SharePoint Object Model, namely using SPWeb.EnsureUser which will add the entry if it does not exist.


4

Nico, I found a source that may help you immensely. The following link walks you through how to use a PowerShell script to import a list of users from Excel and create them for FBA. Importing and Exporting Data in Extranet Collaboration Manager (ExCM) 2010 You can also download the PowerShell source code from this link. It looks like the code creating ...


3

Depending on your specific requirements, the easiest way is probably to use BCS to create external content types that link to your MySQL data. Your SharePoint hosted app can then read/write that data more or less as if it was a standard SharePoint list. The benefit of this approach is that it is quite quick and easy to set up. The downside is that it may be ...


3

Do not remove the site collection from the database! Just remove it via the GUI (Site settings -> Delete site) or use the PowerShell cmdlet Remove-SPSite (outlined here). This will make sure it is deleted the right way


2

If your database is SQL, then there is a built in feature to achieve this. Follow the link For other databases you have to write a custom wcf web service. see here


2

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a regular table. My understanding is that if the View is update-able as defined here, you will also be able to add Update controls to it. To add a view as an ECT ...


2

SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too. Also look at the accepted answer in this question . The answer is in PowerShell.


2

You can use the script to give specific users the db_owner role. Don't forget to dd all users to users.txt. [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | out-null $Users = get-content c:\users.txt Foreach ($User in $Users){ $InstanceName = "" $NewOwnerLoginName = $user; $smosvr = New-Object ...


2

Has nothing to do with SharePoint. If you configure the server your MYSQL database runs on to accept Cross Origin requests you can access it from any environment. A https connection is preferred, but not required when you manually instruct your browser to allow mixed content. A REST middle-tier like ArrestDB in your stack simplifies access. You are ...


2

It is not possible. You need Microsoft SQL Server. More info in Hardware and software requirements for SharePoint 2013. Technet.


1

It is not possible to run it using MySQL server. You can use express edition for simple tasks but if your databases go more than 4GB I suggest you use many web apps instead (divide the work). For big companies it will be impossible to use SQL express edition so you would have to buy SQL Server. MySQL is not an available solution.


1

Yes it is possible, here is a basic example: protected void Page_Load(object sender, EventArgs e) { const string ConnectionString = @"Persist Security Info=False; Integrated Security=SSPI; Server=hercules\sqlexpress;Connect Timeout=30;Database=TestDB;"; SqlConnection con = new SqlConnection(ConnectionString); SqlCommand cmd = new ...


1

I was in a similar situation, and what I did was to use Nintex Workflow to do an "execute SQL" action to write new form submissions out to a database I use purely for reporting purposes. If you don't have Nintex Workflow, ilovesharepoint has an "Execute SQL" SPD add-in for SP2010. The only issue I found is, because of how workflows work; you cannot easily ...


1

Pre-Requisites You must be a member of the Farm Administrators SharePoint group. You must be a member of the Administrators group. On the database server you must be a member db_backupoperator fixed database role and db_owner fixed database role Steps Close all open SharePoint Management Shell windows. Stop all services that are related to SharePoint ...


1

SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface ...


1

You can use Powershell script to export External list to Sql on nightly basis(Task Scheduler) Please look into following URL which will be helpful to you for getting power shell scripts http://www.terrymarshall.com.au/Blog/tabid/162/EntryId/165/SharePoint-2010-Exporting-Lists-To-SQL-Server-Part-2.aspx ...


1

There are many ways how to add items to SharePoint lists and the approach that you want to take is definitely not on the list. Using C# (server object model) - code needs to be run on SP server. Using C# (Client object model) - add items to SharePoint List using CSOM. SharePoint PowerShell. SharePoint Web Services (jQuery). Query Ajax function is used to ...


1

User profiles must be created initially from an LDAP (or other approved directory) this does not include SQL. You have to have a domain account to match the Profile to. This can also happen when a user hits a SharePoint site for the first time. Once the Profile is created you can update it in a number of different ways. If you want to use a SQL data source ...


1

You can use the stored procedures with BCS, so instead of a single table, you can gather information (Read only) from a result of a query. You need to create the stored procedure in SQL first, then connect to BCS through SHarePoint Designer, then you will be able to create a External Content Type based on that stored procedure. Here is an article that ...



Only top voted, non community-wiki answers of a minimum length are eligible