Remove From My Forums

CAN MICROSOFT SYNC FRAMEWORK WORKS WITH SQL 2000?

Question
0

Sign in to vote

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

0

Sign in to vote

have you tried the steps here? Walkthrough: Extending the Local Database Cache to Support Bidirectional Synchronization

Friday, May 4, 2012 7:24 AM
0

Sign in to vote

Hi June

I tried ,still its not working.

Friday, May 4, 2012 8:35 AM
0

Sign in to vote

try enabling Sync Framework tracing and post back the trace here...

Friday, May 4, 2012 8:53 AM
0

Sign in to vote

HI Sorry im new to this SYnc Framework..Pls let me know how to enable the Tracing.....

Friday, May 4, 2012 9:01 AM
0

Sign in to vote

see: Tracing the Synchronization Process

Friday, May 4, 2012 10:10 AM
0

Sign in to vote

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
0

Sign in to vote
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
0

Sign in to vote

Thanks

How to: Configure N-Tier Synchronization this link is not working....

Wednesday, May 9, 2012 9:11 AM
0

Sign in to vote

updated the link

Wednesday, May 9, 2012 10:09 AM
0

Sign in to vote

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
0

Sign in to vote

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
0

Sign in to vote

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
0

Sign in to vote

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
0

Sign in to vote

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
0

Sign in to vote

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

Asked by:

CAN MICROSOFT SYNC FRAMEWORK WORKS WITH SQL 2000?

Question

All replies