Sunday, March 11, 2012

Copying database from 2005 -> 2005 - loses things like identity columns.

I am copy a database from one server to another and when I do, I lose all of
my identity column specifications. The column is still there, but it's no
longer an identity column.
Am I missing something?
TIA - Jeff.Using the Copy Database Wizard.
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45083C25.3090206@.realsqlguy.com...
> UJ wrote:
> How are you performing the copy?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

No comments:

Post a Comment