Solved

SQL Server 2008 R2 Migration

Posted on 2011-02-21
5
291 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

695 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