Phil Parkin (6/21/2013)

---

No doubt it's too late to change this, but have you thought about using NewId rather than identity as your (nonclustered) PK in the various tables?

As far...

DiverKas (6/20/2013)

---

William Plourde (6/20/2013)

---

Yep, that is correct. Assuming 6 dbs out in the future. A person...

Yes, they are killing me. I...

Yep, that is correct. Assuming 6 dbs out in the future. A person (and all their...

sjimmo (6/20/2013)

---

If the data is going one way, from DB A to DB B and not going the other way the change the tables using identity fields by dropping the...

Phil Parkin (6/20/2013)

---

I would suggest that you need to change the design of the target database so that you do not have identity columns as PKs there. Just make them...

The process is...

I follow you. If not for the encryption this data would be in a single table and I would not even consider splitting it vertically into two tables. I just...

ok, I think I understand that. So if fetching the 'common' un enc data just make sure I use the appropriate field list in the query. And if I need...

Sorry if I was not clear. My data is such that I will have encrypted and un encrypted columns for a given table, both in development and production.

Our apps will...

Thanks but the Microsoft book has poor reviews on amazon.com and I don't see any obvious alternatives. Has anybody actually used this book ?

opc.three (3/5/2012)

---

You may be re-inventing the wheel a bit. Depending on how unique your situation is you may be able to leverage some built-in features of SQL Server. Have you...

oops, sorry for the duplicate response. Pesky page 2 link. doh !

We do have a similar table arrangement. We have a history table for each base table. The base...

We also have one history table for each base table that we require versioned data on. Our base table(s) generally only have a few Ids with all or most of...

Thank you all for the information. FWIW this system already exists. Without going into detail we store every version of every row for our primary entities. We also use...