Re: Secure data in SQL Server 2005 Mobile Edition

The size is the same whether it's encrypted or not. I used the Northwind database for my tests but the larger AdventureWorks one might also make an interesting test.

I think the best way to get answers for your specific case would be to build encrypted and non-encrypted databases with the schema you need and run a few simple tests for yourself. Frankly the reason I didn't spend more time doing thorough testing was that I think if you need encryption, then you neeed it and whatever the perf hit, well that's the price you pay. Still I was pleased to find the hit was a small one in my tests.

--
Ginny


"AimlessZombie" <AimlessZombie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2B849C1A-0785-4C8B-BD52-9DFDB4359A80@xxxxxxxxxxxxxxxx
What about the database size?

"Ginny Caughey [MVP]" wrote:

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.
>>


.

Relevant Pages

  • Re: Secure data in SQL Server 2005 Mobile Edition
    ... so I suppose Mobile Edition does not support AES128 as it is ... What is the difference between encryption with and without the ... thing to try is not checking the encrypt option - the database still ... I am trying to encrypt a database on SQL Server 2005 on a desktop ...
    (microsoft.public.sqlserver.ce)
  • Re: Newbie - Is this Reasonable?
    ... because this hash is stored in the database. ... So you use PKCS5v2 to generate a key hash from a salt and the user's passphrase, then store the salt and the hash in a database. ... are even more critical in database applications because the payoff from tampering with selected fields may be much higher, fields tend to be fixed-length so it's easier to tamper with them in a meaningful way, and databases lend themselves to off-line analysis, so the attacker can marshall more resources and take more time to attack your system. ... You're using a stream cipher for encryption. ...
    (sci.crypt)
  • 2005-Problem restoring database with encrypted columns to diff ser
    ... I need to start encrypting several fields in a database and have been doing ... OPEN MASTER KEY DECRYPTION BY PASSWORD = 'testAppleA3'; ... ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY; ... encryption by certificate test; ...
    (microsoft.public.sqlserver.security)
  • Re: Protecting an Access Database
    ... because I want to make my database more secure. ... I see...So I guess that not even encryption (which I have ... I think Microsoft could have created a built-in encryption function within ...
    (microsoft.public.access.security)
  • Re: Secure data in SQL Server 2005 Mobile Edition
    ... What is the difference between encryption with and without the encrypt ... thing to try is not checking the encrypt option - the database still gets ... replicate this database on SQL Server Mobile Edition on a mobile ...
    (microsoft.public.sqlserver.ce)
Loading