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
109 Views
Last Modified: 2014-11-10
Can this be done in sql express 2012, if so, how?
Thank you.
0
Comment
Question by:lapucca
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 10

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 48

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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

829 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