.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

2 way sync with SQL DB

Posted By:      Posted Date: October 16, 2010    Points: 0   Category :SharePoint

Does anyone know if there is built in functionality or a 3rd party product that would allow me to display information from an SQL DB in a SharePoint list while also giving me the ability to update the SQL DB by modifying the information displayed in the SharePoint List?

An example would be:  Our company uses an issue tracking system to track time spent on client issues.  This system uses a SQL back end.  We also use SharePoint to store important client info.  I would like people to be able to update the status of an issue from the client's information page in SharePoint so they do not need to switch between the 2 apps.  Is this posisble?

View Complete Post

More Related Resource Links

In Sync: Creating Synchronization Providers with the Sync Framework


The Sync Framework can be used to build apps that synchronize data from any data store using any protocol over a network. We'll show you how it works and get you started building a custom sync provider.

Joydip Kanjilal

MSDN Magazine August 2010

Sync Up: Manage Your Data Effectively With The Microsoft Sync Framework


Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.

James Yip

MSDN Magazine April 2009

How to sync between UpdateListItems() and GetListItems() web services

I am using Javascript to call the UpdateListItems() webservice through SOAP to add an entry to a list then I am using the GetListItems() webservice to query the number of items in that list. I am successful in adding an new entry in the list, but when I query the GetListItems(), it does not return the number of entries (items) in the list unless it was entered via the SharePoint GUI, not the UpdateListItems() routine I have written. I will add the source code for your reference and help.: var response; function SOAPUtilForHitCount(data,action,listName,listPath) { this.data = data; this.listName = listName; this.listPath = listPath; this.SOAPHeader =  function() { var stack = []; stack.push("<?xml version='1.0' encoding='utf-8'?>"); stack.push("<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'>"); return (stack.join("")); } this.SOAPBody =  function() { var stack = []; if(action=="count") { stack.push("<soap:Body>"); stack.push("<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'>"); stack.push("<listName>" + this.listName + "</listName><query><Query xmlns=''><Where><Eq><Fie

SQL server 2008 r2 Data sync question???

Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally?  I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does that have to do with a sync functionality that runs locally to keep my db's sync'd?   Thanks, SL

Sharepoint 2010: User Profile Sync with Person attributes

Sorry for opening another post following this, but I think this case is quite concrete: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/2fa02093-630e-4131-bdc7-0b979067f601 When trying to configure in Sharepoint 2010 - User Profile Application, an additional sync source from BDC (as at least, one LDAP Profile is required). The first approach was to create a straightforward SQL Connection with SP Designer, and it seemed everything ok, except I'm not able to setup synchronization of "Manager" property, which is great in order to see Silverlight Organization Explorer Webpart. As I have read in the previous post, someone pointed to setup a BDC with Visual Studio 2010, so one attribute is of type: Microsoft.SharePoint.SPUser. It seamed very logical, and so I tried to do such task. Once I have deployed correctly a BDC with this strong type (SPUser), the result is that I'm still unable to see any attribute when trying to synchronize Manager attribute. In Sharepoint 2007 this was possible, but not able in SP 2010. Any idea of how to do it? Just a bug? I have one very dirty workaround: setup a Timer job to run after Sync, so I can setup this field by code. But, for doing this, I would not need to run Sync process with BDC anymore.    Evotec Consulting

sync your shairpoint data with your file server

is it posseble to sync al the files on my file server to my shairpoint server.   now its done with shairpoint workspace. bath when a employee makes a new file on the file server it wont sync

Sharepoint calendar sync with personal outlook calendar

Hello I want our users to be able to make meetings in sharepoint and see it directly in their personal calendar, also when other users subscribe and unsubcribe it should be seen in their personal calendar. I know its possible to "Link/Connect with outlook" but this makes a new "Other Calendar" which u can put side to side with your own calender. I would like to have it directly imported into my personal outlook calendar.  Is there any known information , links about this?

How to add Microsoft Sync Framework to Prerequisites Dialog Box

Hello everyone. I created a setup project in Visual Studio 2008 and I need to add microsoft sync framework as a prerequisite. But microsoft sync framework option is not in the Prerequisites Dialog Box. How can I add microsoft sync framework as a prerequisite to my project?

Sync calendar events between two web applications

Hi, I wanted to check if it is possible to sync calendar events between two different web applications in WSS 3.0. Both web applications are in the same farm. I want to know if it is possible to design such workflow in SharePoint Designer 2007 or do I need to use Visual Studio?Thank you.

Can ASP.NET be used in sync with RDP to create a remote desktop manager ?

Hello all,      I am new to .NET but is in a circumstance were i need to submit a project in .NET ( not necessarily a web application - even a client server one would suffice ). I need this application to be able to : 1. Connect to remote client from my server computer2. See client computer's screen and work on it from my server to fix problems there3. Drag and drop files between my local server's screen and the screen on my computer displaying the remote client's screen4. Should be able to start a chat session ( text/audio) with this remote client's user to help fix him/her the problem5. If i am installing any s/w in the client - then i should get back this control over the client computer even after i do a system restart of the client computer from the serverMy doubt is : 1. Can i build a remote desktop control manager application as described above using .NET be it asp.net/winforms ?2. If so what all technologies do i need to use and which all protocols will i be using ideally - like ASP.NET, ADO, Winforms - RDP, FTP, HTTP etc ?3. If at all feasible - how complex is this project on a level of 1 to 10, 10 being the highest ?I am sorry if i am totally out of place or wrong. I am a novice and is new to .NETThanking you all in advance for your valuable help and suggestions.                 

SQL 2008 R2 Report Server - what sync method should I use?

Setting up a report server inside the same network for accounting to run reports on. Data can  be 1 day behind and would like to be able to add more indexes than the original server.  No data will be written back to the original  (pub) server.  I have about 5 databases on the sql server that I'll be replicating. In reading the book, seem Transactional is the best choice. Any ideas or new features I should try instead?  

User Profile Sync not starting anymore

Hi! http://www.harbar.net/articles/sp2010ups.aspx Followed this guide to enable User Profile syncronization excluded the creation of the two Web applications and User Profile Service. I had these already setup by default when I installed SharePoint Server 2010. The first time I started Syncronization service it did succesfully started the Forefront services in windows and the sync service, but when I began configuring import connection settings I got connection to AD and saw all the users in AD groups, but never got it done because a error that said something about "??? WA"...don't remember anymore. I figured out that it was just because that I didn't do "IIS reset" nor the  system restart. So I did IIS reset and also restarted the system just incase. When system got back up ForeFront Manager Service was down, cause everyone told that you shouldn't mess around Service.msc so I figured that I could just stop sync service and start it again. And here I am figuring out why nothing will come back on. Both ForeFronts are in disabled state and sync service stopped. When I try to start sync service it tries a while, "ForeFront sync service" -startup change to automatic but returns to disabled state and in SharePoint sync service comes back to stopped state. Yes SharePoint farm account is in local admin group! Any suggestion

Trying to SYNC Project Professional to Sharepoint 2010 - what template do I use?

I want to use Sharepoint 2010 to sync, and track/record changes initiated from my Project Professional 2010 projects.  The intent is to have a web view (ideally editable) for my team to track work progress. Documentation is light right now for Sharepoint 2010/Project 2010.  Does anyone know: 1) Can Project Pro 2010 be sync'd with only the generic TASKS list template, or can it (should it) be sync'd with one of the other templates - like PROJECT TASKS, ISSUES LIST, or STATUS LIST? 2) Are there any Microsoft mapping diagrams showing what MS Project 2010 fields are mapped to Sharepoint 2010 fields? Since this jumps between 2 platforms, please let me know if I need to address this on the MS Project Pro 2010 forum.  Thanks. 

User Profile Sync - Profile Picture Export to AD Problem

To start, I think I've read every post/blog/etc there is on this subject.  Currently I have user profile import to Sharepoint 2010 working.  It imports profile data just fine.  Everything in the FIM Synchronization manager show success even.  Its the export from Sharepoint to AD of the user profile picture that isn't working at all.  I've gone thru the steps of adding the thumbnailphoto export under the picture properties.  I can see the export inside of the FIM manager.  I notice though that in FIM there is there a DS_EXPORT of the objects.  I've looked into the SyncDB and noticed in the metaverse table the SPS_MV_OctetString_PictureURL never gets updated with the information from the PictureURL column of the ProfileDB.  It is always Null.  Actually in FIM it only shows one person with an update, and keep showing the PictureURL property as being not applied, which is probably because it is showing it as blank only.  In the connector for the object in FIM, I get the error that I've seen in some blog posts where it says PictureURL (String) is not compatible with SPS_MV_OctetString_PicutreURL (binary), but that seems to be how Sharepoint builds the connection even though FIM finds it invalid.  I've had that created, deleted several times, so I guess that is ordinary, and not sure that is even the problem.

a bit confuse with the requirements of the user profile sync

Hi,   I'm setting up a SP 2010 farm environment, where I want to configure the user profile synchronization (AD based). After some difficulties resolved, I finally was able to make it works.   After that, the health analyser tells me it's bad to have services running with a user in the local administrator group. However, the setup guide tells me to add the user to the group.   In order to clarify, can you tell me what are the exact prerequisites of the user account for : * the service User profile synchronization service (same as farm admin service) ? On my farm, domain\spadmin by now * the instance of the user profile synchronization application ? On my farm, domain\spusersync   I've granted on the domain (w2K3 domain) all required permissions to write properties on both accounts (spadmin and spuser).   What are the next steps ? as my profile synchronization is set up, can I simply remove the user from the local admin group ?   thanks for clarifications, steve  Paying back the community for its help by writing articles : Have a Nice Day.Net Blog

How to sync main thread and new opened window

Hi all, I need to halt the main thread until some workflow is completed on the opened Window, the opened window has a user control content in which the user enter some data and click the button "next" . how can i halt the main thread and signal it to continue after the next button has been clicked? I've tryed using AutoRestEvent but the main thread get stucked and the window is frozen. ShowDialog wont help me, because i want to keep the window visible after the next button is clicked.     public void SomeMethod() { AppWizardStep2 step2 = new AppWizardStep2(ref myParams); Window myWin = new Window(); myWin.Content = step2; myWin.Show(); //Halt here // ...some logic that needs to continue after user workflow is completed on step2 user control }      

MS Sync Framework INSERT Trigger

Hello, Due to the sync framework insert trigger my business logic was broke. I was getting resulted in a StaleStateException (-1 rows affected, expected 1). error. I looked at the sync insert trigger and found a strange thing. There is an update call before inserting to the tracking table. This update call joins with the tracking table for inserted record. How it is going update the record which really do not exists! I removed the UPDATE call and it works fine now. However I am not sure the reason behind the presence of the UPDATE call withing the INSERT trigger. Here is the sample trigger: ALTER TRIGGER MYTABLE_insert_trigger] ON MYTABLE FOR INSERT AS UPDATE [side] SET [sync_row_is_tombstone] = 0, [local_update_peer_key] = 0, [restore_timestamp] = NULL, [update_scope_local_id] = NULL, [last_change_datetime] = GETDATE(), [ID] = [i].[ID] FROM [sync].[MYTABLE_tracking] [side] JOIN INSERTED [i] ON [side].[PrimaryKey1] = [i].[PrimaryKey1] AND [side].[PrimaryKey2] = [i].[PrimaryKey2] INSERT INTO [sync].[MYTABLE_tracking] ([i].[PrimaryKey1], [i].[PrimaryKey2], [create_scope_local_id], [local_create_peer_key], [local_create_peer_timestamp], [update_scope_local_id], [local_update_peer_key], [sync_row_is_tombstone], [last_change_datetime], [restore_timestamp], [i].[ID]) SELECT [i].[PrimaryKey1], [i].[PrimaryKey2], NULL, 0, @@DBTS+1, NULL, 0, 0, GETDATE(), NULL, [i].[ID] FR
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend