SQL Identity attribute drops when importing a table

rmetz · #1 (**permalink**) 12-31-03, 12:11

Hi all,

I am importing SQL 2000 tables from a developer install of SQL 2000. There are no destination tables to append just new tables being brought in.

I use the All Tasks > Import (DTS) service to do this. I have noticed that the Identity columns do not maintain the Identity attributes. I have to reset them after I import new tables. Is this normal? or is there a bug here?

I checked the MS KB with no success.
Anyone have some info on this?

Thanks.

Brett Kaiser · #2 (**permalink**) 12-31-03, 12:22

Yeah, and you wont get any contraints or RI...

Did you look at the transfer database task?

rmetz · #3 (**permalink**) 12-31-03, 12:25

Quote:

Originally posted by Brett Kaiser
Yeah, and you wont get any contraints or RI...

Did you look at the transfer database task?

Thanks for the relpy.
I'll check it out.

RM

rnealejr · #4 (**permalink**) 12-31-03, 12:28

If you want to copy the entire database you can also use the copy database wizard, backup/restore, detach/attach ... Did you use copy tables or copy objects ?

rmetz · #5 (**permalink**) 12-31-03, 12:30

Quote:

Originally posted by rnealejr
If you want to copy the entire database you can also use the copy database wizard, backup/restore, detach/attach ... Did you use copy tables or copy objects ?

Just copying tables with the wizard...