Re: moving data between SQL Mobile and SQL server DBs
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 13 Nov 2007 22:21:40 +0000 (UTC)
(TigerFanInAtlanta@xxxxxxxxx) writes:
I have connected to both a SQL Server Mobile and a SQL Server DB in
management studio. How can I write a query that selects rows from a
table in the Mobile DB and inserts them into the server DB.
You would set up a linked server and the use four-part notation:
INSERT localtbl(....)
SELECT ...
FROM MOBILE.db.sch.tbl
WHERE ...
Here I have assumed that you have called the linked server MOBILE.
You use sp_addlinkedserver to set up a linked server. Sorry, I don't
have any examples on how to this for SQL Mobile, but there may be
examples in Books Online.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: moving data between SQL Mobile and SQL server DBs
- From: TigerFanInAtlanta
- Re: moving data between SQL Mobile and SQL server DBs
- References:
- moving data between SQL Mobile and SQL server DBs
- From: TigerFanInAtlanta
- moving data between SQL Mobile and SQL server DBs
- Prev by Date: moving data between SQL Mobile and SQL server DBs
- Next by Date: Re: copy database from web host to local?
- Previous by thread: moving data between SQL Mobile and SQL server DBs
- Next by thread: Re: moving data between SQL Mobile and SQL server DBs
- Index(es):
Relevant Pages
|
