Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: SQL Server Data Synchronization

    Hi all

    I have two SQl Server 2000 in two different location, at one point I wand to Transfer the information in one table (in Sql server 1) to the same table (in SQl server 2) using Stored Procedure.

    Can any one through some input on how to write the SP?


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    Pure stored procedure would truncate SQLServer2.database.owner.tablename and then select the rows from SQLServer1.database.owner.tablename into SQLServer2.database.owner.tablename. This will require DTC to be up and running as well as linked servers.

    You could also use bcp, DTS, or snapshot replication as well.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts