Scenario Operation Duration Lock mode Source status (min) (Source table) ALTER TABLE Drop index 4 Exclusive Offline ALTER TABLE 137 Schema Offline (TransactSQL modification statement) Index creation 61 Exclusive/Shared Offline/Online (option) Flat File bcp out 42 Shared Read only (bcp utility) Drop and <1 Exclusive Offline recreate tables BULK INSERT 79 Exclusive Offline (TransactSQL statement) Index creation 40 Exclusive/Shared Offline/Online (option) Flat File with bcp out 42 Shared Read only Staging Table (bcp utility) BULK INSERT 79 None Read only (Transact-SQL statement) Index Creation 40 None Read only Drop and <1 Exclusive Offline rename SELECT INTO SELECT INTO 18 Shared Read Only (TransactSQL statement) creation 41 None Read only Drop and <1 Exclusive Offline rename INSERT INSERT SELECT 18 Shared Read only SELECT (TransactSQL statement) Index creation 43 None Read only Drop and <1 Exclusive Offline rename
Scenario Operation Duration (min) Lock mode (Source table) Source status ALTER TABLE Drop index 4 Exclusive Offline ALTER TABLE (TransactSQL statement) 137 Schema modification Offline Index creation 61 Exclusive/Shared Offline/Online (option) Flat File bcp out (bcp utility) 42 Shared Read only Drop and recreate tables <1 Exclusive Offline BULK INSERT (TransactSQL statement) 79 Exclusive Offline Index creation 40 Exclusive/Shared Offline/Online (option) Flat File with Staging Table bcp out (bcp utility) 42 Shared Read only BULK INSERT (Transact-SQL statement) 79 None Read only Index Creation 40 None Read only Drop and rename <1 Exclusive Offline SELECT INTO SELECT INTO (TransactSQL statement) 18 Shared Read Only creation 41 None Read only Drop and rename <1 Exclusive Offline INSERT SELECT INSERT SELECT (TransactSQL statement) 18 Shared Read only Index creation 43 None Read only Drop and rename <1 Exclusive Offline
SQL_bestpract_MigrationToUnicode.docx