moving data between SQL Mobile and SQL server DBs

From: TigerFanInAtlanta@xxxxxxxxx
Date: Tue, 13 Nov 2007 08:25:43 -0800

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.

.

Follow-Ups:
- Re: moving data between SQL Mobile and SQL server DBs
  - From: Erland Sommarskog

Prev by Date: Re: Unsuccessful Restore Leaving Database in 'Loading' State
Next by Date: Re: moving data between SQL Mobile and SQL server DBs
Previous by thread: Re: Unsuccessful Restore Leaving Database in 'Loading' State
Next by thread: Re: moving data between SQL Mobile and SQL server DBs
Index(es):
- Date
- Thread

Relevant Pages

Re: Mobile Only? Why?
... Engine Query as one of the choices? ... Microsoft, SQL Server Books Online ... > I've just finished installing the workstation tools from the SQL Server ... > When I start the Management Studio, connect to a server (doesn't matter ...
(microsoft.public.sqlserver.tools)
Re: SqlServerCe on the desktop
... You're right that SqlCe 3 (officially know as SQL Server Mobile Edition) ... >> Lloyd Dupont, Software Architect ...
(microsoft.public.dotnet.framework.compactframework)
Re: SqlServerCe on the desktop
... You're right that SqlCe 3 (officially know as SQL Server Mobile Edition) ... >> Lloyd Dupont, Software Architect ...
(microsoft.public.sqlserver.ce)
RE: Native Exception
... This query appears to work OK with SQL ... Mobile in SQL Server 2005 Management Studio. ... This posting is provided "AS IS" with no warranties, ...
(microsoft.public.sqlserver.ce)
Re: Why Sql Server Mobiles RDA.Pull error ??
... The code below run successful use RDA from SQL CE 2.0 to SQL Server 2000, ... but use SQL Server Mobile it report error about IIS request faild!! ... strInternetUrl, strRemoteConnString As String ...
(microsoft.public.sqlserver.ce)