Does 'SELECT INTO' not work in SQL Mobile?

I'm trying to programmatically create a new table that is a copy of another. The SQL statement I'm making is:

"SELECT * INTO sensor_stream_temp FROM sensor_stream"
and various combinations thereof (such as specifying the columns, etc)

The error I keep getting is:
There was an error parsing the query. [Token line number 1, Token line offset 10, , Token in error = INTO ]

Is it not possible to copy a table using this statement? *sigh*
Thanks in advance for any help.
-Dana
OK, so it looks like "INTO" is not allowed in SQL Mobile; how do I make a copy of a table?

|||

Try this:

INSERT INTO sensor_stream_temp (SELECT * FROM sensor_stream);

Note: Both sensor_stream_temp, sensor_stream MUST be of similar.

does not install SQL Query Analyzer

Hi,

I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?

cheers,

michael

Hi,

Sorry... for info I am using CS VS2005 and SQL Mobile.

Thank you.

michael

|||

Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:

<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB

or

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\

Darren

Does "SQL Server 2005 Mobile Edition" exist?

"SQL Server 2005 Mobile Edition" is a standalone software?

or

it equals "SQL Server 2005" + "SQL Server 2005 Mobile Edition Device SDK"?

Hi Raphael,

You need to download SQL Server 2005 Mobile Edition Device Device SDK which is the standalone software. You do not need SQL Server 2005 on the desktop unless you plan to sync your Mobile data to a SQL Server using Remote Data Access (RDA) or Merge replication. Otherwise you only need SQL Server 2005 Mobile Edition Device Device SDK.

Here is a sysreqs url which has all this mentioned there :

http://www.microsoft.com/sql/editions/sqlmobile/sysreqs.mspx

Hope that helps,

Amol.

|||

Amol.

Thank yor for your help!

I have seen the link you provided before and read some other articles. But too much information make me quite confused.

My situation is that I need to create a mobile application (use SQL server mobile) in the device. Also, I need to sync my mobile data to a SQL Server.

Questions:

Then I want to ask "SQL Server 2005 Mobile Edition" is a standalone software like "SQL Server 2005 Express Edition"?

Or "SQL Server 2005 Mobile Edition" is a compact database stored in device, can use "SQL Server 2005 Express Edition", "SQL Server 2005 Standard Edition",......etc to open it on server side?

|||

Hi Raphael,

SQL Server 2005 mobile edition IS a standalone software which runs by itself on the device. The data is stored with a small footprint on the device. It's like having a server and its data on the device which u carry around. As an enterprise requirement, you can connect to a SQL Server 2005 running in your enterprise and sync your device data with the server data. I believe you can also connect to a SQL Server from your device to view and work with the server data.

Regards,

Amol.

|||Thank you!|||

Hi Amol,

I am also running 2005 mobile ed. on a handheld. I'm trying to replicate the data to a PC running SQL 2005 Express then have Express replicate to an Enterprise SQL Server. I understand that Express can only be the subscriber. Is it possible although I'm synching to a PC (thru a cradle) to replicate the 2005 mobile DB to an enterprise SQL Server directly, bypassing the PC with Express?

Does "SQL Server 2005 Mobile Edition" exist?

"SQL Server 2005 Mobile Edition" is a standalone software?

or

it equals "SQL Server 2005" + "SQL Server 2005 Mobile Edition Device SDK"?

Hi Raphael,

You need to download SQL Server 2005 Mobile Edition Device Device SDK which is the standalone software. You do not need SQL Server 2005 on the desktop unless you plan to sync your Mobile data to a SQL Server using Remote Data Access (RDA) or Merge replication. Otherwise you only need SQL Server 2005 Mobile Edition Device Device SDK.

Here is a sysreqs url which has all this mentioned there :

http://www.microsoft.com/sql/editions/sqlmobile/sysreqs.mspx

Hope that helps,

Amol.

|||

Amol.

Thank yor for your help!

I have seen the link you provided before and read some other articles. But too much information make me quite confused.

My situation is that I need to create a mobile application (use SQL server mobile) in the device. Also, I need to sync my mobile data to a SQL Server.

Questions:

Then I want to ask "SQL Server 2005 Mobile Edition" is a standalone software like "SQL Server 2005 Express Edition"?

Or "SQL Server 2005 Mobile Edition" is a compact database stored in device, can use "SQL Server 2005 Express Edition", "SQL Server 2005 Standard Edition",......etc to open it on server side?

|||

Hi Raphael,

SQL Server 2005 mobile edition IS a standalone software which runs by itself on the device. The data is stored with a small footprint on the device. It's like having a server and its data on the device which u carry around. As an enterprise requirement, you can connect to a SQL Server 2005 running in your enterprise and sync your device data with the server data. I believe you can also connect to a SQL Server from your device to view and work with the server data.

Regards,

Amol.

|||Thank you!|||

Hi Amol,

I am also running 2005 mobile ed. on a handheld. I'm trying to replicate the data to a PC running SQL 2005 Express then have Express replicate to an Enterprise SQL Server. I understand that Express can only be the subscriber. Is it possible although I'm synching to a PC (thru a cradle) to replicate the 2005 mobile DB to an enterprise SQL Server directly, bypassing the PC with Express?