If I create a database (.sdf file) on a server and set it to be encrypted, should it be able to be opened on a device or other PC? In other words, is there anything in the encryption that is machine specific? Or is it really that the password
is what lets me connect and the encryption prevents it from being read by some other tool like a hex file viewer as one post suggested.
I've read through lots of posts and documentation and I'm just trying to understand how encryption works and if there are any limitations or considerations and haven't found a good source.
View Complete Post