Do you know an effective way how to do the following?
1. Migrate tables into diff. database into another sql server box (SQl Server 2008)?
ex. table1 is in database1 and server1, I would like to migrate table1 into database2 in server2.
Your help is very much appreaciated.