Solved

SQL Server 2008 R2 Migration

Posted on 2011-02-21
5
287 Views
Last Modified: 2012-05-11

Can some provide me some idea of what a DBA needs application developers to test for before an application is deployed from Development to Production?  
As a DBA, what can I provide the developers with, as there are no QA department and I want the application to be properly tested before deployment into production.

Any idea?

0
Comment
Question by:Favorable
  • 3
  • 2
5 Comments
 
LVL 20

Assisted Solution

by:Marten Rune
Marten Rune earned 250 total points
ID: 34943564
run a trace (profiler) and capture depreacheated statements. Will show T-SQL code not supported in the future.
Deploy to a test server locked down with the same collation and rights to test the application
Analyze to see if access to fileshares is required, if so test these from the locked down test server
Analyze jobs, if any, related to the db/app in question
save script used to migrate db to the test server, use same script to deploy in production environment

//Marten
0
 

Assisted Solution

by:Favorable
Favorable earned 0 total points
ID: 34943704
I no the process of moving it from Dev to Prod, but we want the developers to test by making sure all processes are working out as expected before deploying to prod.
My question, as a DBA what is my role in the testing process as there are no QA?  Or a list of scenario to provide developers with when testing the application.  
0
 
LVL 20

Assisted Solution

by:Marten Rune
Marten Rune earned 250 total points
ID: 34944161
Well you should test the application by moving it to a acceptance server. The acceptance server should have similar configuration and be locked down like the production server.

The script you use to move to acceptance server should be reused when deploying to prod.

The developers should provide information about the database, jobs if any and if any configuration is necessary on the server. Like a .Net for some assemblies, if the broker is used, if endpoints is needed etc etc.

Your job is to move to acc, help them figure out why something does not work as expected. Let them correct in dev, then a new test move to acceptance. Once acceptance works as designed/expected. The developers should sign that they accept the move. Now use same script to move into production.

//Marten
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 250 total points
ID: 34944268
Note:
The DBA role in a company, is administering the database servers. I e taking care of backups, deployment, rights in databases. Keeping DB Server updated, SP etc. Have disaster recovery plans in place, handy in case of emergency. Make sure you comply with SLA and or RTO.

The DBE role is another story though!

//Marten
0
 

Author Closing Comment

by:Favorable
ID: 34986453
thanks
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
email about the whoisactive result 7 35
sql query questions 2 34
SQL Server 2012 r2 Make faster Temp Table 17 103
sql how to count case when 4 14
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question