Mirroring, Replication or SSIS package RRS feed

  • Question

  • Im wanting to build a staging server for the ETL work to be carried out on my databases before extracting into my Datawarehouse.

    Whats the best way to get a nightly copy my source database onto my staging server.

    I don't need everything in the source databases, a lot of the tables are redundant so I would like the option of only pulling across the tables I need.

    Mirroring looks like I need to mirror the full database, replication seems a bit of a sledge hammer for what I need, and ETL process has a bit of work but this may be the best.

    I may be wrong on these any you guys recommend whats the best tool.


    Friday, January 31, 2014 5:28 PM


All replies