|
|
||||||
|
#1
02-18-05, 07:33 AM
|
|
|
|
|
Hi,
I am developing PPC application using SQL Server 2000 and SQL Server CE 2.0. I succeeded in getting/pulling data from handheld/sql server ce into sql server 2000 using RDA. Since all process above done on handheld application, is there any way to getting/pulling data from sql server 2000 from desktop application into handheld/sql server ce ? or is there any way to export sql server table/store procedure into .sdf format so I can copy it using explorer into handheld and vice versa ? Please help and thank you for your response. |
|
|
|
#2
02-18-05, 01:26 PM
|
|
|
|
|
SQL Server CE does not support stored procedure.
Stored procedure cant be exported/loaded into SQL CE. |
|
#3
02-18-05, 02:51 PM
|
|
|
|
|
Take a look at the Data Port line of products (www.primeworks.pt). You will
be able to export and import SQL and Access databases to SQL CE from the desktop. |
|
#4
02-19-05, 12:40 PM
|
|
|
|
|
Database tables etc can be exported.
One way is to convert data into text, xml format. transfer it to pocket pc read it and insert it in new db. or use custom component /utilities Thanks Prash "Prashant Dhingra[MSFT]" <pdhingra> wrote in message news:1564 [..] |
|
#5
02-22-05, 05:25 AM
|
|
|
|
|
Hi All,
Thank you for the response. I'll try to create an xml or text file. Regads, -ali- "Prashant Dhingra [MSFT]" wrote: [..] |
|
#6
02-22-05, 06:20 AM
|
|
|
|
|
Another solution is to setup a quick RDA pull against the table and a
corresponding table in SQL CE will be created with all the records from the server. |
|
#7
02-22-05, 07:43 AM
|
|
|
|
|
Hi Darren,
Is RDA could be run on desktop application ? as i know, RDA pull run only on handheld based on Sql Sever CE namespace not in SQL Server 2000. Regards, -ali- "Darren Shaffer" wrote: [..] |
|
#8
02-22-05, 02:31 PM
|
|
|
|
|
correct, you cannot use RDA in a desktop app, but I thought you
were trying to get a bunch of data from your SQL Server 2000 pulled down to SQL CE on device. In this case, you can use RDA, Replication with the create database option set on the subscriber, an export/import using intermediate text files, or a third party product. with the upcoming SQLMobile release, you'll be able to work with ..SDF files on the desktop as well as use DTS to move data between server and mobile databases. |
|
|
| Similar Threads | |
| Moving SQL Server 2000 to SQL Server 2005 - Need suggestions onsyncronization of data between the server Hi, Our current production database server is SQL Server 2000 and it is running on Windows 2000 server. Now as part of the upgrade we bouht a new machine and... |
|
| SQL Server 2000 - Export Data - Identity Field I am doing a simple export of tables and data from one SQL Server 2000 database to another (different servers). When I use the "Export Data" option, I have no problem... |
|
| Transfer data from SQL Server 2000 to SQL Server 2000 continuosly We have data in a Source Server (SQL Server 2000), which is growing at the rate of 50MB/min. This should be transferred to destination server (SQL Server 2000) at the same... |
|
| Unable Export Data to Excel on Win 2000 Server Hi I have a VB.Net 2003 Assembly in which I am 1 . executing a stored in a database and filling a dataset 2 . Populating the data retrieved in to an Excel Spread sheet 3 .... |
|
| Export xls data into sql server 2000 without using DTS utility I need to export .xsl file to sql server 2000 with out using DTS utility. Only through dts package or asp coding Any help would be greatly appreciated. Dilip Singh Dodiya |
|
|
All times are GMT. The time now is 12:40 PM. | Privacy Policy
|
Export data from SQL Server 2000 into SQL Server CE