I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

It depends on how you're syncing. If you're using manual implementation via SQL Client on device, that would work with properly configured SQL 2005 Express as well.

I'm not aware of any reference materials on that. The idea is very simple - you go through all records in one db and compare them with records in another db. If they are different, you'd need to synchronize them as appropriate in your particular case. For example:

Before:

SQL Mobile              SQL Express          Action

1-foo                            1-foo                       Same data, do nothing

2-bar                             2-foobar              Data changed, copy from Express to Mobile

2-some                       <nothing>              Record deleted, delete from Mobile  

                                                             (or is it added on device? - that's for you to track)

Before:

SQL Mobile              SQL Express         

1-foo                            1-foo                      

2-foobar                        2-foobar             

some honest, non-politically correct advice - I wouldn't install SQL Server 2005 and SQL Express on the same machine. it can cause you a lot of difficult issues - I'm not saying it can't be made to work, but you're asking for a day of searching newsgroups to resolve the issues that this introduces. either remove SQL Server and re-run the VS2005 setup, choosing SQL Express as an optional install component, or use a separate box to run SQL Express on.

-Darren