Steve,

Yes, I saw a demo of that product.  That is why I was asking if the Dynamic masking did that.

When they say they need the birthdate,...

Thank you.  I didn't see any examples that could add two months onto the birthday by using the Data Masking.  I also didn't see any way to display a masked...

You were exactly right.  I hate the time I spent reading blogs to resolve that issue.

Yes, I disabled the log backup job and the wizard was able to...

Sue,

You have the right of it.

I am very adept at scripting in SQL Server.  However, I normally only use scripting for backups when I want to...

That was my thought also, but I wanted to put the question out just in case.

I had norecovery for full backup restore as well as the log files...

That sounds awesome.

So you put in output into a column?  What datatype?  Varchar(max) I would assume.
Then you add that row to a "DBA" database that is synchronized?

I really appreciate both responses.  The logins to a table is an interesting approach.  I would like to hear more about how you go from a table to creating the...

Thanks everyone.

This discussion really helps.  Originally, I mentioned that we could change the datatype to varbinary and have the web application use a convert function to insert the...

Thanks Gail.

But the column is varchar and the manager doesn't want to change that.  The stored proc could get an encrypted value, but how would I directly place...

Management didn't want to add another column.  They asked me if I would have a stored procedure handle this.  My thought is handle what?  

The stored proc or...

The import process when you import data tier application creates a package, create a database and then does the import.

However, running sp_configure worked.  I was able to migrate all...

Well, it looks like I did a good job.  It works!

I ran some tests and it seems like everything is doing well.  I was thinking I had to...