Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / May 2008

Tip: Looking for answers? Try searching our database.

Database Encryption

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rubens - 29 May 2008 17:20 GMT
Can someone please recommend 3rd party tools available to encrypt a database?  One of our clients has asked us to encrypt "the data at rest" and I am still trying to figure out what that means.  But perhaps some of these tools will give me an idea of what we can offer them.

The database is currently on SQL Server 2000 SP4.

Thank-you,
Rubens
David Portas - 29 May 2008 20:04 GMT
You ought to consider upgrading. If you can upgrade to SQL Server 2008 then
you could take advantage of Transparent Data Encryption, which does exactly
what the client is looking for - it encrypts the data on the disk and in
backup.

Signature

David Portas

Rubens - 29 May 2008 20:10 GMT
We definitely are.  Our upgrade to SQL 2005 is scheduled for August of this
year, but we need something before then.  There is no option to go to SQL
2008 any time soon, we have way to many Apps and not enough resources to
move it right now.

Thanks,
Rubens

> You ought to consider upgrading. If you can upgrade to SQL Server 2008
> then you could take advantage of Transparent Data Encryption, which does
> exactly what the client is looking for - it encrypts the data on the disk
> and in backup.
David Portas - 29 May 2008 20:32 GMT
> We definitely are.  Our upgrade to SQL 2005 is scheduled for August of
> this year, but we need something before then.  There is no option to go to
> SQL 2008 any time soon, we have way to many Apps and not enough resources
> to move it right now.

The good news is that upgrading to 2005 is a far bigger job than upgrading
to 2008. If you migrate your app to 2005 then you are probably 99% of the
way to having something that works on 2008 as well. Transparent Encryption
is literally what it says. No application changes needed.

Signature

David Portas

Rubens - 30 May 2008 16:19 GMT
That will be a relief, it sure would be nice to have a seamless upgrade
after from 2005 to 2008!  Our upgrade to 2005 is turning into a monster, but
we'll get there!
:-)

Rubens

>> We definitely are.  Our upgrade to SQL 2005 is scheduled for August of
>> this year, but we need something before then.  There is no option to go
[quoted text clipped - 5 lines]
> way to having something that works on 2008 as well. Transparent Encryption
> is literally what it says. No application changes needed.
John Bell - 30 May 2008 09:05 GMT
> We definitely are.  Our upgrade to SQL 2005 is scheduled for August of
> this year, but we need something before then.  There is no option to go to
[quoted text clipped - 8 lines]
>> exactly what the client is looking for - it encrypts the data on the disk
>> and in backup.

Hi

SQL 2005 also has encryption ability although not as comprehensive as SQL
2008

Anyone thinking of encryption should look at
http://blogs.msdn.com/lcris/archive/2006/11/30/who-needs-encryption.aspx

John
Rubens - 30 May 2008 16:19 GMT
Thanks for the link, I am sure it will come in useful down the road!

Rubens

>> We definitely are.  Our upgrade to SQL 2005 is scheduled for August of
>> this year, but we need something before then.  There is no option to go
[quoted text clipped - 18 lines]
>
> John
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.