[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

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.
0
ramvbcsharp24
Asked:
ramvbcsharp24
1 Solution
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now