Joe-420121 (12/21/2009)

---

The following procedure is OK?

1. Create Table [backup12212009] with BIGINT Indentity
2. using SSIS export data from old table to [backup12212009]
3. Delete old table
4. Rename backup12212009

Can do as above?

Lynn Pettis (12/21/2009)

---

Why not just use INSERT INTO? Just be sure to enable INDENTITY insert either way, and if using T-SQL, to turn it off when done.

Carlos Pereyra (12/21/2009)

---

Any reason why you're not using alter table alter column?
as in alter table mytable alter column my column bigint?

Carlos.

Joe-420121 (12/21/2009)

---

1. The table has only 4 coulmmns, no FK, constrains etc.
2. The table is used 24 hours, and about 2000 users use it all the time.
3. When I use GUI to modify data type to BIGINT, I get timeout error after 3 min.
4. Copy data to tmp table and when all done, and drop the old table and just rename it quicky.
( also I am creating the table in a new file group).
5. The size of table is about 60GB, so I feel SELECT INTO might take more time than SSIS. am I wrong?

Thanks for all your helps...

Joe-420121 (12/21/2009)

---

3. When I use GUI to modify data type to BIGINT, I get timeout error after 3 min.

homebrew01 (12/21/2009)

---

I seem to recall that you can get blocking when creating a table this way if the source table is big because system locks are held until the insert is complete. You could create the empty table tablebackup12212009 first , then insert the data.