Out of curiosity, I ran SQL Compare on the correct db and a copy with the wrong identity.

I don't see anywhere in SQL Compare where identities are compared?

"To a degree, what you're doing, while fully functional, is a bit of a cheat." - that's the other part of the issue.

It's vendor code, and I can't put...

Hi, gents ...

Grant, the Copy Database task does copy both structure and data (although on rereading what you wrote I think you meant that). It's only the identities that aren't...