Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SQL Express for local database cache? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

     

    This is probably a stupid question but is it possible to use SQL Express as the local database cache instead of SQL Compact? If so, are there any articles that explain how to do it as the wizard to add a local database cache in VS2008 allows SQL Compact only?

     

    Thanks in advance,

     

    Aaron

    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:13 PM forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
    Thursday, January 17, 2008 6:25 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes this is possible but we currently do not have a SQL Express client provider included with the package.  The client provider is open in that it would allow you to create your own client express provider, but we have not as yet provided one.  You would also need to implement your own change tracking mechanism with 2005 Express.  With SQL Server 2008 Express this will be a lot simpler with the integrated change tracking mechanism.

     

    We are working on a sample client provider that when doen will be posted to our sync blog.  We hope to have it soon, but as of right now I can not provide a date. 

    Thursday, January 17, 2008 7:42 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes this is possible but we currently do not have a SQL Express client provider included with the package.  The client provider is open in that it would allow you to create your own client express provider, but we have not as yet provided one.  You would also need to implement your own change tracking mechanism with 2005 Express.  With SQL Server 2008 Express this will be a lot simpler with the integrated change tracking mechanism.

     

    We are working on a sample client provider that when doen will be posted to our sync blog.  We hope to have it soon, but as of right now I can not provide a date. 

    Thursday, January 17, 2008 7:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Liam,

     

    With a name like that it sounds you are from my part of the world!

     

    Thanks for the info. We are in no particular hurry so we can continue with SQL Compact and switch to SQL Server 2008 Express when it is available. I hope I haven't read too much into your posting but I assume your upcoming sample client provider will be for SQL Express?

     

    Thanks again,

     

    Aaron

     

    Thursday, January 17, 2008 9:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Unfortunately I haven't even made it to Ireland yet.. at least I assume that is where you mean ;-)

     

    Yes it is SQL Express we are planning on creating the sample client provider for.

     

    Liam

    Friday, January 18, 2008 3:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
    May I know any update on client provider for SQL Express? I have been waiting this for months....

    Is it possible to use Sync for ADO.NET for both client and remote provider as workaround? How to do this?

    Thank you
    Friday, February 1, 2008 11:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote


    We recently started investigating Sync Services, but it is with disbelief that there are no 'Client Providers' for SQL Server 2005.

    Would it be possible to publish a 'pre-beta' release (or whatever you have so far) so customers can, at least ,start testing and decide whether Sync framework is even a viable solution for their business needs?

    Was anything announced at Mix 08?
    Wednesday, March 12, 2008 9:48 PM