Post reply

Data transfer for reporting

  • November 10, 2006 at 8:00 am

    #115051

    Hello All,

    I am a newbie dba and need some expert advice on one of my development scenario I am currently struck with. I am in process of designing a reporting solution for my company. It is going to be a web based intranet thin client multitiered application using sql server 2000 and .net platform.

    This application basically shows the real time KPI’s or statistics in different forms of reports on an hourly basis to the senior managers to right on their desktop.  Eventually these reports will help them in decision making for the better performance of the business...

    My question here is what is the best way of transferring large chunk of data (not entire table(s)) from production server (SQL 2000) to a reporting server or staging database with an hourly refresh without stressing the production environment? 

    Is it       a) Replication preferably snapshot? Or

                b) BCP? or

                c) DTS?           

    Or do you suggest any better way of achieving this task?

    Any suggestion or tips would be greatly appreciated.

    Looking forward for your responses.

    Many Thanks,

    AK

  • November 10, 2006 at 6:23 pm

    #671198

    I think replication is the best way because it is easy to configure and need not many manage.

  • November 13, 2006 at 6:54 am

    #671310

    Thanks very much for the reply.

    Is it alright to do hourly refresh through out the day using replication method? Will there be any performance issues?

    Thanks,

    Arshad

     

     

  • November 13, 2006 at 8:36 pm

    #671486

    I would like to call reports of SQL server 2005 from vb 6.0

    its urgent pse

     

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

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