Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    26

    Unanswered: copy data from one table to another table in different data base

    Hi,
    I have two database on same machine. I want to copy from one table to another table in different database as mentioned below.
    db1---emp_table
    db2---emp_table

    Both db1 and db2 are on same machine, emp_table definition is same in both db1 and db2. I want to copy data of emp_table in db1 to same table in db2.
    Please let me know how to do it.

    Thanks
    Surjya

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    export/import?
    Dave

Posting Permissions

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