pandu sweety

pandu sweety

  • NA
  • 10
  • 12.2k

One database tables data transfering to other database tables using Store Procedure in sql server 2005 having windows authentication

Jul 23 2009 10:56 PM
Hi,
I have the problem with ,One database tables data transfering to other database tables.where the tables and procedures all structures are same.

I have DB1 and DB2 Databases.

In DB1->Table 1
table 2
tabl3  means upto 15 tables have .

In DB2 - the above same Tables and same datatypes and structures.

I need to transfer the DB1 Tables data to DB2 Tables.

"
I used the following command for shift table be table but ..it is failing.

-SELECT * INTO DB2.dbo.RFmaster FROM ILS.db1.RFmaster 

INSERT INTO [DB2].[dbo].[Table1] (ItemID,Barcode,

TagUID ,

ItemTitle ,

MediaTypeCode ,

BranchCode ,

BibliographicCode ,

BibliographicRef ,

SortingCode ,

LocationCode ,

Tagstatus,

Volume )

SELECT * FROM DB1.dbo.Table1


Like that I have to do......

:My problem is to resolve this.....using by StoreProcedure concept only.
 
If Ia m doing wrong .....please provide the correct sample StoreProcedure.



Advance thanks for the best reply.


Answers (2)