Post reply

Replication or DTS package wht to choose?

  • January 17, 2003 at 2:05 am

    #105611

    Hi,

    1)we have an Client Server Application having Database in SQl Server 2000 aprrox 4 G.B and growing at the rate of 1 Gb per quarter.

    2)we have developed a Website which displays reports from the same Database(only 30 % of tables were used for the site).

    We want make the server different for website and Apllication,this has to be updated twice everyday.

    i dont want to use snapshot as it deletes data every time.

    Can anyone suggest which to choose?

  • January 17, 2003 at 4:43 am

    #446604

    Replication would work fine. Since it will be read only I think transactional makes more sense for you (I'd consider merge vs trans with updating subscribers if you needed to update on the other server).

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 2 posts - 1 through 1 (of 1 total)

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