Home Forums SQL Server 2008 SQL Server 2008 High Availability What are ways of Exporting data of Wahehouse Database from Production to Development Server? RE: What are ways of Exporting data of Wahehouse Database from Production to Development Server?

  • That's a very sweeping statement. Without any details on the environment they have you cannot definitively say that a restore will be quicker than one of the afore mentioned options. All the op has posted is that the production database is 100GB in size no mention of how much of that data is required in the development environment,if any transformation is required, whether is real time, closer to real time or can be hours/days/weeks apart.

    I work with OLTP SQL databases which are several TB's in size that we pull data from daily to source our warehouse, data marts, cubes and non production environments, those processes are hundreds of times quicker than restoring a full backup.

    MCITP SQL 2005, MCSA SQL 2012