Solved

Table migration into different database and different SQL Server 2008

Posted on 2013-07-01
1
394 Views
Last Modified: 2013-07-24
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
Comment
Question by:ramvbcsharp24
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 500 total points
ID: 39290685
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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question