transfer data from one database table to another database table..

Question

0.00/5 (No votes)

See more:

hi to all.,

i have a problem with sql server.

I want to transfer TABLE_1 data of DATABSE_1 from to DATABASE_2 in TABLE_1. This is i am handling in a server. Which query i have to write transfer data from DATABASE_1 to DATABASE_2..?

help me..

thanks
- JAGADiSH
(Cheers)

Posted 12-Oct-11 3:02am

Jagadish M Vadavatti

Add a Solution

Comments

Bala Selvanayagam 12-Oct-11 9:20am

DATABASE1 & DATABASE 2, are they under the same SQL server instance (same computer) ?

If not (Seperate computers) are they in the same network (within LAN?) ?...please shed some light on how your SQL server databases are installed ?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

imaa2amha · Answer 1 · 2011-10-12T03:21:00

Solution 1

Hi try this,

SQL

SET IDENTITY_INSERT DATABASE_2.dbo.TABLE_1 ON
GO

insert into DATABASE_2.dbo.TABLE_1
select * from DATABSE_1.dbo.TABLE_1
GO
SET IDENTITY_INSERT DATABASE_2.dbo.TABLE_1 OFF
GO

Best Regards

Ab Abulubbad

Posted 12-Oct-11 3:21am

imaa2amha

kishorekke · Answer 2 · 2011-10-12T03:27:00

Solution 2

SQL

SET IDENTITY_INSERT DB2.dbo.TABLE_1 ON
INSERT INTO DB2.dbo.TABLE_1
SELECT * FROM DB1.dbo.TABLE_1
SET IDENTITY_INSERT DB2.dbo.TABLE_1 OFF
GO

Posted 12-Oct-11 3:27am

kishorekke

sravani.v · Answer 3 · 2011-10-12T03:29:00

Solution 3

Try this one

SQL

SELECT *
INTO DestinationDB..MyDestinationTable
FROM SourceDB..MySourceTable

Refer this link:

http://www.w3schools.com/sql/sql_select_into.asp[^]

Posted 12-Oct-11 3:29am

sravani.v

Updated 12-Oct-11 3:32am

v2