Post reply

Copy of Production DB into Reporting DB on daily basis

  • July 19, 2011 at 8:46 am

    #241097

    Friends,

    I want the copy of Production DB into Reporting DB on daily basis. Considered that production DB is on Machine-A and Reporting DB is on Machine-B. Please give me your valuable suggestion.

    Thanks,

    JK

  • July 19, 2011 at 9:51 am

    #1354922

    There are many ways of doing that. You can use SSIS to create a package that does the restore of the backup of the production database. If you are only going to read data from the reporting database, you can use Log Shipping and running the restore job once a day. If you have any further questions please let me know.



    My blog

  • July 19, 2011 at 10:24 am

    #1354964

    You can also use Replication, especially if you only need a subset of production.

    If you can use transactional replication, then you have the option of close to real-time updates of your reporting database.

  • July 19, 2011 at 10:28 am

    #1354972

    I am doing this using the SSIS package and setup job which drops the existing tables and recreate overnight.Might be that's the option

    Thanks

  • July 19, 2011 at 10:29 am

    #1354980

    Log shipping would probably be your best option

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply