Asked by:
CAN MICROSOFT SYNC FRAMEWORK WORKS WITH SQL 2000?

Question
-
HI,
Im developing a offline application,in which client should be able to work in offline and later when connected to network should update the changes to server.My Server is SQL 2000 with service pack 3.
I created a localdatabase cache using wizard,i can load the data from server to client...when i make some changes in the client,i cant sync back to the database. I change the sync direction of the table to bidirectonal,there is no conflict since its only 1 client.
I did the same steps with sql2008 its working fine. Pls let me know if i need to do any set up in server side to make it work in SQL 2000.
Friday, May 4, 2012 7:11 AM
All replies
-
have you tried the steps here? Walkthrough: Extending the Local Database Cache to Support Bidirectional Synchronization
Friday, May 4, 2012 7:24 AM -
Hi June
I tried ,still its not working.
Friday, May 4, 2012 8:35 AM -
try enabling Sync Framework tracing and post back the trace here...
Friday, May 4, 2012 8:53 AM -
HI Sorry im new to this SYnc Framework..Pls let me know how to enable the Tracing.....Friday, May 4, 2012 9:01 AM
-
Friday, May 4, 2012 10:10 AM
-
Hi JuneT,
Thanks i managed to sync my data with sql 2000..... Now i want to do the same using webservices or WCF.....(through internet without using network or VPN)
Pls share with is there is any sample for how to do this....
Thanks
Karthik
Wednesday, May 9, 2012 8:34 AM -
see: How to: Configure N-Tier Synchronization for the concepts
follow steps here, except the part for creating mobile app, replace that with your app: Walkthrough- Creating an Occasionally Connected Smart Device Application
for more advance serialization, see: Sync Framework WCF-based Synchronization for Offline scenario – Using custom dataset serialization
- Edited by JuneT Wednesday, May 9, 2012 10:09 AM
Wednesday, May 9, 2012 9:02 AM -
Thanks
How to: Configure N-Tier Synchronization this link is not working....
Wednesday, May 9, 2012 9:11 AM -
updated the linkWednesday, May 9, 2012 10:09 AM
-
Hi,
IS there any other Step by Step tutorial avaialble for how to use sync framework with WCF?
Monday, May 21, 2012 7:01 AM -
this link Walkthrough- Creating an Occasionally Connected Smart Device Application i provided you above already uses WCF... you just have to change the client project to be an non-smart device project...
Monday, May 21, 2012 7:09 AM -
Hi,
I have Created OCA application with WCF...I have deployed WCF service in IIS.This holds the sdf file.
How about the client application,WE have to place the sdf file in the client system also???
If not how to use the connecting string of SDF file in Server.
Thanks
Wednesday, June 6, 2012 8:53 AM -
you might want to explain in detail what is it exactly that you are trying to achieve.
If you are creating an OCA, why do you have the WCF Service having the SDF file? so where is your sql server?
where exactly are your clients?
Wednesday, June 6, 2012 9:12 AM -
My Requirement is:
Clients are located in different palces ,they are not connected to network or Internet always. So they should be able to work with the application offline and able to sync with the main database when they get connected to network or internet.So i thought if the sync happens through internet it will cover both Network and internet sync.So i went for Sync framework with WCF.Now it will helpful for me ,if i know how to deploy this clients.does sdf file is also need to be copied to each client?
Thanks
Karthik
Thursday, June 7, 2012 12:26 AM -
if you followed the tutorial above, the SDF is on the client side. the WCF service is the one connecting to SQL Server.
if you dont deploy the SDF to the client side, where will they save their data?
Thursday, June 7, 2012 1:30 AM