?
Solved

How to import data from one database table to another database table, in the same sql express 2012?

Posted on 2014-11-09
3
Medium Priority
?
114 Views
Last Modified: 2014-11-10
Can this be done in sql express 2012, if so, how?
Thank you.
0
Comment
Question by:lapucca
[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
3 Comments
 
LVL 6

Accepted Solution

by:
Mandeep Singh earned 668 total points
ID: 40432008
hi

Without Identity Column
insert into test.dbo.DUMMY select * from TESTING.dbo.DUMMY

With Primary Key


set identity_insert test.dbo.dummy on
go
insert into test.dbo.DUMMY(ID,NAME,ROLLNO,CLASS) select ID,NAME,ROLLNO,CLASS from TESTING.dbo.DUMMY
go
set identity_insert test.dbo.dummy off
go
0
 
LVL 11

Assisted Solution

by:HuaMinChen
HuaMinChen earned 664 total points
ID: 40432183
Hi,
You can create the relevant table like
use schema2
go

select *
into tab2
from schema1.dbo.tab1

Open in new window

0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 668 total points
ID: 40432241
You can use the Import/Export wizard. Just right-click on the database name and chose Tasks/Import Export...
Follow the wizard and that's it.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

765 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