SQL Server Performance Forum – Threads Archive
Move data from one Sql Server db to anotherHi, 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.
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.