QA environment frequently needs Database refresh and hence
space on its disks. QA Database is refreshed from Production followed by a data
purge, which leaves a lot of free space in the database. In order to release
the free space, we follow database shrink command, a lengthy & single
thread I / O operation, also cause high data fragmentation.
To avoid this resource & time consuming activity, we do
a Refresh Database with manual scripts, in which, we create a new database,
transfer tables, data & other objects via scripts.
The Generate Scripts option of a database generates script
for the complete database and transfers data (using Insert into command, highly
logged), to avoid this we do a Select * into, to transfer table definition
& data (minimal logged & fast, being a bulk operation) & then
generate Table Objects (Keys, Constraints, Triggers, Indexes) via manual
scripts & other database objects (Views, Stored Procedures, Functions,
Users, Roles, Schemas) via generate scripts.
Sounds interesting ? Want to download the complete document ? Download Link
Please post back your review in the comment section here.
-- Hemantgiri S. Goswami (http://www.sql-server-citation.com )
