Lynn Pettis (12/21/2009)
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?
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.
As Lynn said, I would use the INSERT INTO. It will be faster in most cases.
Also, it is very important that when you create the table that it is created to mirror the original table with the exception of the BIGINT.
I, would also not Drop the old table for several weeks. I like to keep it around as a failsafe. It is much faster to recover from that table than from backup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events