Home Forums SQL Server 2008 SQL Server Newbies how to maintain test environment RE: how to maintain test environment

  • December 5, 2013 at 6:52 am

    #1671059

    rightontarget (12/4/2013)

    Hi all,

    I was asked to create a test environment for one of our apps that is supported by 3 databases.

    I can restore latest backup of production version of each, but then I will have to edit every procedure to make sure that joins point to test instance of the database.

    I can create database script and edit it in text editor.

    I am looking for an optimal solution as number of stored procedures is growing and manual edit will become problematic with time.

    Thanks,

    You may have to clarify how you are referencing your objects.

    If you are referencing the Server name in your object naming, is there any particular reason why?

    Does "test instance" mean the Server or Database here?

    Is your test environment on its own instance of sql server?

    Either way, wouldn't the idea of changing code for this be unwieldy and prone to error?