Click here to Skip to main content
15,920,438 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi guys,
after i finish my WPF application and SQL 2008 R2 Database i need to make a package to be installed to our clients i have done that using install shield 2010 and took my database as a script to be created on our user we have done all of that the problem after we create database on our client pc and the script create it in the default path of SQL Server 2008 i found that every one can stop SQL service and copy the database and stole it so how can i prevent my database from being copied or attached to keep it safe from hackers ?
Posted

1 solution

One idea
Encrypt important data in the database and obfuscate the key within your application to make it difficult for someone to find the key string.

See TripleDESCryptoServiceProvider Class[^]
 
Share this answer
 
Comments
Yasser El Shazly 23-Feb-13 9:45am    
i want to protect my database schema not data if any one can copy and attch my database so he will be able to see my data base schema ....
Mike Meinz 23-Feb-13 10:01am    
Maybe someone smarter than me will have an answer for you. In my 40+ years of software development, I have never had this requirement and I can't think of a way to keep a schema 100% secret.
Yasser El Shazly 23-Feb-13 10:22am    
so your schema any one can steal it , that is doesn't make you wary ?
Mike Meinz 23-Feb-13 10:47am    
Only authorized individuals at each of my customer's sites have full access to the underlying database not "anyone". There is a software license that says they cannot use my designs to build their own or a competitive product. I don't worry about it.
Yasser El Shazly 23-Feb-13 10:59am    
what about a desktop application

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900