copy data from MSDE to SQL Server

[isa]

Hello everyone,

i want to transfer/copy data from MSDE to SQL Server 2000 and from SQL Server to MSDE, through Stored Procedures , not using a "Replication", kindly tell me how i make a SP for this as both datatbases are connetec through LAN, i mean MSDE on diff machine and SQL Server on other machine i make a new registration and connect with MSDE now how can i write a SP that copy data from table of 1 Database to other table of that Database.

kindly reply me asap, its very urgent.

Thanx in Advance.

[iburyak]

Hello everyone,

i want to transfer/copy data from MSDE to SQL Server 2000 and from SQL Server to MSDE, through Stored Procedures , not using a "Replication", kindly tell me how i make a SP for this as both datatbases are connetec through LAN, i mean MSDE on diff machine and SQL Server on other machine i make a new registration and connect with MSDE now how can i write a SP that copy data from table of 1 Database to other table of that Database.

kindly reply me asap, its very urgent.

Thanx in Advance.

Try to run this on SQL Server

[PHP]SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=MSDEServerNameHere;User ID=UID;Password=PWD'
).database.dbo.some_table[/PHP]

Let me know if it worked.

[victor murage]

hi,
download dbamgr2k to detah the data from msde then attach it ti your sql

regards
victor