Deploying with sql server express

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.

If you using SQL Mobile RDA or replication, you would have to implement manual sync using SQL Client as Express offers no RDA/Replication support.

|||I am using replication. Can you direct me to some reference material that can assist me in changing to manual sync?|||Also, to test with sql server express will I need to install it on my computer? I am running sql 2005 and visual studio 2005. Can I load express in addition to what I have installed. I do not want to un-install anything that I have currently. What is your suggestion?|||

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

As far as I know you can run SQL Express and SQL Server side by side, though you would need to use nonstandard port.

|||

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