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.