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
111 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 167 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 166 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 50

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 167 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 eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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

705 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