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

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

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

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

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

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us