| Darren Shaffer 2005-04-25, 3:23 am |
| A single Sql Server CE database can be 2GB in size. It would be a mistake
to attempt to merge replicate the entire database to device. Before
exploring
alternate means to get the data to your device, first consider what the
minimum
amount of information you need on device is. Look at classifying your data
as
lookup-only, which lends itself to deployment with your actual mobile app in
a starter database, data that frequently changes on the server and must
frequently be refreshed on device, and data that can change on both ends
of the dialog.
For your initial download, you can place lookup values (postal codes,
business divisions, etc) in an SDF you deploy along with your app. You
can then use RDA or merge to manage data that is dynamic. Try to
partition the data you send to device by user or role and always take only
what you need.
SQLMobile databases can be larger, but the most compelling enhancement
for you is the ability to have multiple subscriptions in a single device
database.
This means the size of your publications on the server can be smaller and
you
can have more of them without incurring the same performance and bandwidth
impact of merge replicating a single large database.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"éric" <eric@westgen.com> wrote in message
news:OlSDSRBSFHA.3396@TK2MSFTNGP10.phx.gbl...
> How large can my sqlce database be, in theory and in real life.
> right now my DB on the desktop is 1.5GB
> Can I get all this data in sqlce?
> Can I use merge replication with this amount of data?
> What is the best (fastest) way to get the initial download?
> Should I consider sqlmobile instead of sqlce2?
> thanks
>
|