Solved

SQL Server 2008 R2 Migration

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

733 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