Re: Secure data in SQL Server 2005 Mobile Edition
- From: "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx>
- Date: Fri, 13 Jul 2007 11:05:31 -0400
I didn't test it with different schemas. The hit on the device was between 8-10% for most operations. On the desktop it was barely measurable.
--
Ginny
"AimlessZombie" <AimlessZombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:428B5E6D-B41C-428A-BC94-9BF040568FDE@xxxxxxxxxxxxxxxx
Thanks for your reply.
Not exactly that I wanted a more complicated encryption, but i was worried
about the performance hit for encrypting the whole database.
Can I ask what is the size of the database you tested with? Also, would the
performance hit be affected by the database schema?
"Ginny Caughey [MVP]" wrote:
Encryption in SQL Mobile is at the database level only. In my testing the
performance hit for using encryption is quite low, and using an encrypted
database is as easy as providing a password in the connection string, so I'm
not sure why you'd want something more complicated than that.
--
Ginny
"AimlessZombie" <AimlessZombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:721B8943-84FA-41DF-8AFB-633C0A85F1DA@xxxxxxxxxxxxxxxx
>I understand that it is possible to encrypt a database in SQL Server >2005
> Mobile Edition. But I do not want to encrypt the entire database. > Instead
> I
> just want to encrypt only selected data in the database.
>
> Can this be done in Mobile Edition? If yes, how to do it and is there > any
> reference sites?
>
> Many thanks.
.
- Prev by Date: Re: How to synchronize SQL CE 2005 with SQL Express or Standard 20
- Next by Date: Re: Secure data in SQL Server 2005 Mobile Edition
- Previous by thread: Problem Opening SDF Database on Desktop
- Next by thread: Re: Secure data in SQL Server 2005 Mobile Edition
- Index(es):
Relevant Pages
|
