Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Montreal, Canada

    Unanswered: SQL Reporting Change control solution

    Hello Guys.

    I am looking for a Change control guide line for moving reports from dev - test - prod and things to look out for and what not any link or suggestion will be greatly appreciated.

    Thanks guys

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    Maintain a single script of everything you do in dev for each release.
    Apply the script to your test environment as needed.
    Before applying to production, download a new copy of production into test and run your script again, and have users do final testing (actually, I prefer to maintain a separate QA and Test environments to separate these two roles).
    After successfully applying the script to production, start a new version script of dev changes.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts