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

pandu sweety

17y4.1k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

pandu sweety17y ago
Hi,
Thanks for the Response.
When I executed the store procedure...it is successfully done.Means I got the "Completed successfully"message.
but,when click and refresh once the database and see the DB2->Table

There is no data exist in that.Data is not transfering to one database table to other database table.
The DB1 Table data has to move .But it is not happing with my stroe proc.
Table of data is like this

ItemID Barcode TagUID ...............................

1 0000036100 1 Why in the world? : revealing answers to searching questions about almost everything BK 10 AG195 .W59 1994 AG195 .W59 1994 01 Master False
1

So ..like that I have some 1000 Records.

The above records data has to move.
"I need the query ..how to send the values ..............I think I am missing the values along with the query.

Can you pls. suggest me and provide some sample storeproc .......by using my previous Storeproc query.

Advance Thanks for the Reply.
Blocked Account17y ago
Hi,
U are almost correct,
But what kind of error you are getting?