Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    15

    Unanswered: How to Merge Sql2000 & SQL2005 Table Data

    How can merge fields from a SQL2000 Table to fields from a SQL2005 using DTS processing or some other automatic programmatic processing?

    For example,

    SQL2000 Table - Customer
    SQL2000 Table fields - Customer_ID, Customer_Name

    SQL2005 Table - PaymentTbl
    SQL2005 Table fields - Customer_ID, Payment_Amt

    Result Data

    SQL2005 Environment
    Customer_ID, Customer_Name, Payment_Amt

    or

    SQL2000 Environment
    Customer_ID, Customer_Name, Payment_Amt

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Create a linked server.
    Write a query joining the two tables using four part naming (server.database.schema\owner.tablename)
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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