Sync SQL 2000 (remote) with SQL 2008 express (local) without WCF service RRS feed

All replies

  • how do you connect to the remote server? when you say remote, where is the server? do you connect over the internet? over vpn? etc...?

    the changes you'll make will depend on how you connect to the remote. if you are connecting directly to the remote server database, then just remove the reference to the remote proxy and use the provider directly. or you can just leave the WCF component as is.

    • Edited by JuneT Friday, April 2, 2010 1:13 PM
    Friday, April 2, 2010 3:55 AM
  • My project is for users work off line. User input data using laptop and then connect to domain to sync via vpn.

    Is it directly connecting to the remote?


    Friday, April 2, 2010 1:04 PM
  • are the clients directly connecting to your remote/server database?

    even if they are connecting via VPN, you can still use WCF. If you dont want to use WCF, just change the reference on the  remote provider in your client application to not use the remote provider proxy and use the out-of-the box sync provider.

    Friday, April 2, 2010 1:12 PM