By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,983 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,983 IT Pros & Developers. It's quick & easy.

copy data from MSDE to SQL Server

P: 1
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.
Jan 26 '07 #1
Share this Question
Share on Google+
2 Replies


iburyak
Expert 100+
P: 1,017
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.
Jan 26 '07 #2

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

regards
victor
Jan 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.