Copying data in the same DB

yaipyaip Posts: 4
I have two tables in the same DB. Table 1 has 100 rows and Table 2 has 10. I want to copy data from Table 1, Column 1 to Table 2 Column 1. How?


  • You need to setup a comparison that uses mapping to compare Table1 to Table2 in the same database. Then you can exclude all the columns that you don't want to move from the comparison.

    If the only column you are left with is the column you are using as a comparison key that should work. Although you will be generating insert statements that contain only that one column - as long as the rest of your columns have defaults this should be fine otherwise you'll have to compare all the columns (assuming they match) or set defaults for the columns not included in the comparison.

    Richard Mitchell
    Project Manager
    Red Gate Software Ltd
Sign In or Register to comment.