StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12578017
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-09-25T07:20:06.210
FavoriteCount
0
LastActivityDate
2012-09-25T07:20:06.210
LastEditDate
LastEditorUserId
0
OwnerUserId
105929
ParentId
12574620
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<blockquote> given the same cert master key and key credentials </blockquote> There is no such concept as 'cert master key'. Do not invent your own terms, stick to the existing nomenclature so everyone understands what you're saying. There is a master key, there are certificates. If you followed good practices and you deployed a correct <a href="http://msdn.microsoft.com/en-us/library/ms189586.aspx" rel="nofollow">encryption hierarchy</a> then your data should be encrypted with one or more symmetric keys and these in turn would be encrypted with a certificate that is either encrypted with the database master key or a password. Copying data encrypted with a symmetric key between databases is possible. In order to succeed you need to follow exactly the steps described in <a href="http://technet.microsoft.com/en-us/library/ms366281.aspx" rel="nofollow">Create Identical Symmetric Keys on Two Servers</a> which will result in a pair of keys that have the same identity and the same key material. Data encrypted with either one of the two servers can be decrypted on the other server. That being said, any organization that is serious enough about data as to encrypt it in production and at the same time is willing to create a copy of the encryption key on dev machines, not to mention copy actual sensitive data to the dev boxes, is a joke imho. <a href="http://www.codinghorror.com/blog/2012/09/computer-crime-then-and-now.html" rel="nofollow">Technology is never the weak link</a>. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUsing Symmetric Keys with SQL Server on 2 different servers
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRemus Rusanu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POUsing Symmetric Keys with SQL Server on 2 different servers
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COI never mentioned anything about production. but thanks for the answer.
 singulars
 PostPostId
 PO
 UserUserId
 USdbinott

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.