SQL Server Performance

Move data from one Sql Server db to another

Discussion in 'SQL Server DTS-Related Questions' started by li, Oct 22, 2003.

  1. li New Member

    Hi,

    We need automaticlly moving a part of data from one SQL server db to another SQL server db hourly. Currently we use a Window NT Service for this task and was told that the Replication feature or DTS feature in SQL Server is the better way to go. I'm new to SQL server and will really appreciate if someone can give me more information on what is the best way to achieve this task.

    Thanks in advance.
    li
  2. satya Moderator

    You can use DTS task to move the part of data from one server to another server.

    If the second server is typically used for read-only purposes then you can adopt Log shipping, refer to this linkhttp://www.sql-server-performance.com/articles_clustering_log_shipping.asp for resources on Log shipping.

    Refer tohttp://www.sqldts.com for code examples and resources on DTS.

    Come back to the forum if any issues arises.
    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page