Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Warehouse Servers - Fitting in Dev and UAT, and data!

Answered Warehouse Servers - Fitting in Dev and UAT, and data!

  • Monday, August 27, 2012 4:32 PM
     
     
    Sign In to Vote
    0

    Hi

    I am wondering where the Development and UAT servers fit into the diagram I have below.

    What is the easiest way to get data into the development/ uat servers?  Should I just set up SSIS data feeds from the live to populate the development box?    Ideally all development work should be done in the Dev box, but my main issue is getting the data in there and the best method to do so.

    Should the dev/ uat boxes be linked to live analysis server, or should it be populated with ssis?

     

All Replies

  • Tuesday, August 28, 2012 8:55 AM
     
     Answered
    Sign In to Vote
    0

    I can describe in few words how we are working.

    First, the UA server must be the same as production one. It is very useful especially in case of complex test iterartions.

    The scheme for out systems looks like the following:

    

    Some words about how we are developing:

      • Developers have write access only to dev environment.
      • All database changes (including data modifications) are created as scripts and put into TFS and linked to Work Items.
      • We have a self-developted utility that deploy all scripts to test database and after test is OK to production as part of Work Items' changesets. This utility is run as a sequence of single steps part of our Build Machine.