Post reply

The best way to transfer data between servers?

  • October 26, 2008 at 1:35 pm

    #200021

    Hi,

    I have to SQL Servers on the same network. One is for collecting data and the other serves as a datawarehouse where the collected data is computed. So far, I have been transfering data from one to the other using linked servers. But this is really slow when we have thousands of rows to transfer.

    I tried something like this:

    select field from OPENQUERY(db123, 'select field from SOmeDB.dbo.tbl_logs where date < dateadd(mi,-15,getdate())')

    or something like this:

    select field from db123.SomeDB.dbo.tbl_logs where date < dateadd(mi,-15,getdate())')

    But that's pretty slow either way. This query is fast on the local server though.

    What could be the best strategy to transfer data between servers? Is there anything faster that linked servers?

    Thanks for any idea.

    Stephane

  • October 26, 2008 at 1:42 pm

    #889776

    Have you consider log shipping from source sql server to your datawarehouse server and then querying the database locally on your datawarehouse server?

    chrno

  • October 26, 2008 at 5:35 pm

    #889795

    No... How do you do that?

    Thanks

    Stephane

  • October 27, 2008 at 7:11 am

    #889953

    Press F1 and search Books Online for "log shipping" - for just getting the fresh data at some interval, a scheduled job with a SSIS package doing the transfer should do the trick though.

    Regards

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

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