Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: The database environment

    Hello, everyone:

    What is difference between testing environment and product environments for MS SQL Server? Thanks a lot.

    YTZ

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: The database environment

    It is common for organisations to have 3 environments, development, testing and production. Usually each environment consists of a completly seperate database server & database, along with seperate application & and web servers if applicable.

    This way any development can be safely performed in a seperate database as to not "break" your current production environment. Once development is complete you move your new code to a testing environment where you test your new code/application until satisfied, then migrate to production.

    Development & Testing environments in a perfect world would mirror your production environment. This is rarely the case due to cost. So they are usually cut smaller db's and less powerfull servers.

    Does this answer your question?

Posting Permissions

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