[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server 2008 R2 Migration

Posted on 2011-02-21
5
Medium Priority
?
295 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 1000 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 1000 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 1000 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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

656 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