Table migration into different database and different SQL Server 2008

Hi Folks,

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.

Thank you.
ramvbcsharp24Asked:
Who is Participating?
 
Kyle AbrahamsSenior .Net DeveloperCommented:
Right click on the destination database, tasks -> import data
Follow the wizard
You can edit the mappings on the tables you want
Drop and re-create destination tables
enable identity inesrt should also be checked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.