how to insert data from a table with an identity field to another with the same structure and without loosing the identity number 
Author Message
 how to insert data from a table with an identity field to another with the same structure and without loosing the identity number
does anybody know how to insert  data from a table with an identity field to
another with the same structure and without loosing the identity number.

I'm making a migration of a table but i don't know how to migrate it without
loosing the identity number using sql.



Mon, 20 Jan 2003 03:00:00 GMT
 how to insert data from a table with an identity field to another with the same structure and without loosing the identity number

SET INDENTITY_INSERT dest_table_name ON
insert into dest_table_name select * from src_table_name
Quote:

> does anybody know how to insert  data from a table with an identity field to
> another with the same structure and without loosing the identity number.

> I'm making a migration of a table but i don't know how to migrate it without
> loosing the identity number using sql.



Mon, 20 Jan 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Attempt to insert duplicate identity values in table (has identity and key fields)

2. Copying the structure of a table into a temporary table without constraint and identities

3. PLS help: Change field structure without loosing data?

4. Identity insert into another identity table

5. implement auto-number(identity) field in insert trigger?

6. BULK insert not giving sequential IDENTITY numbers to a field

7. Identity without IDENTITY

8. Generating identity values without IDENTITY keyword

9. Inserting into a table with only an identity field

10. Table Insert with IDENTITY field

11. Inserting select and a corresponding value from an identity field in another table

12. insert trigger on table with identity field


 
Powered by phpBB® Forum Software