Solved

SQL Server 2008 R2 Migration

Posted on 2011-02-21
5
286 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mssql SQL query 14 45
SQL Transaction logs 8 27
CROSS APPLY 4 43
Can Unique column have more than one Null? 8 44
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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 video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now