question

Murali avatar image
Murali asked

Check Points while running scripts from one db to another

Can i get any check list before running db scripts from Development Server to Testing Server and as well Testing Server to Production Server or any good documentation on this.
dba
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
- Step 1 :sure that your source follows all the database & T-SQL standards, if not work on it. - Step 2 : Make sure that you have cleared unwanted default values, columns , triggers and other objects etc. - Step 3 : Check Programmable objects like SP, Trigger function etc for any hard coded values or unnecessary comments, or missing comments. Find unused variables and temp tables if any and remove those. - Step 4 : Make sure that you have scripted all the objects the depended objects, Constraints, users, Indexes. - Step 5 : Run it on test server and make sure that all went good. - Step 6 : If step 5 fails find out the error analyze, fix it, if needed goto step 3. - Step 7 : If step 5 is a success, time to run it on production.
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Murali avatar image Murali commented ·
thank you very much cyborg ...
0 Likes 0 ·
GPO avatar image GPO commented ·
@Cyborg "...all the database & T-SQL standards..." That kind of implies that such a list of standards exists. Does it?
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
@GPO By standards i was pointing the naming conversions, Normalization etc..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.