I have mobile application, so i dont want to send/receive whole changes in tables..Just some data, that meets some filter terms. Is it possible to achieve with SF; if it is, please provide some resources to read about it, because i found almost nothing.
Thank You.
views:
107answers:
2
+2
A:
It's definitely possible with SQL Server Replication Services (SSRS). You can select which tables, fields, and even apply filters to the publication. I'm not familiar with Sync Framework but SSRS subscriptions appear in the Sync Center, so my assumption is that Sync Framework uses SSRS.
Jamie Ide
2010-01-13 12:54:47
Thank You for the answer, but can you provide some documentation on HOW to do that(sorry, but this is my first time hearing about SSRS)? I'd searched for it myself, but its urgent and if you know where the documentation is, please help once again. thank you
nihi_l_ist
2010-01-13 13:00:11
SSRS is a fairly complex technology. Actually any replication is, and I'd be very nervous about implementing it with urgency. This link is for SQL 2000 but has screenshots: http://www.mssqlcity.com/Articles/Replic/SetupSR/SetupSR.htm. There's a wealth of info in SQL Server BOL: http://technet.microsoft.com/en-us/library/ms151198.aspx
Jamie Ide
2010-01-13 13:05:05
Thank you for responses!..hmm..may be THIS: http://msdn.microsoft.com/en-gb/library/bb726003.aspx is the solution i need?..
nihi_l_ist
2010-01-13 13:09:26
That looks right to me. Hopefully I pointed you in the right direction even if I didn't answer the question.
Jamie Ide
2010-01-13 13:26:39
+1
A:
Yes its possible. For example you might only want to sync the records relating to a specific store, rather than all the changes in the store table.
You do this by adding a parameter to the SyncParameters collection. e.g.
m_SyncAgent.Configuration.SyncParameters.Add("@ParamName", paramValue)
This will pass the parameter data to the serverside of the Sync process, which you can then use to sync only the data you want to include.
JohnnyJP
2010-02-07 21:10:39
but if understood you right-i should change the queries in cache.designer file too(to use the parameter). but after "refreshing" sync dependancies-ill have to manually add these parameters back, because the file will be regenerated by VS...am i right? thank you for the help!
nihi_l_ist
2010-02-08 11:08:25
nihi_I_ist, thats right. I tend to use the sync designer to come up with the initial cache designer, then modify by hand, using a partial class to override the one proc that I need to change to include the parameter.
JohnnyJP
2010-02-08 12:24:47
By the way did the thing ;) Managed to pass the parameters from cs(not designer file) so i had no need to add them by hand every time the designer was rebuilt by the IDE
nihi_l_ist
2010-05-21 13:56:30