STEP 1: Right Click on Source database. Here you will see some Options.
STEP 2: A wizard will open. click on next button.
STEP 3: Here the Source Of data need to choose. Give the credentials and select the database.
STEP 4: Continued of step 3. Choose the Source database.
STEP 5: In this step you have to choose the destination database. Give the credentials and select the database.
STEP 6: In this step the table need to choose. From which the data will be transfer. Notice the right side is the table name which will be on the destination server.
STEP 7: Keep Click on next.
STEP 8: Here the process will be started.
STEP 9: After the process is done this screen will be showed. click on close.
Now go to the destination database server. Execute: Select * FROM theTableName