Need advice on getting SQL CE Server data to the desktop using VB.Net2005 CF 2.0

[Loogie]

Hello

I am using SQL Server CE VB.Net 2005 compact framework 2.0

So I have my data on the device now I need to use it on the desktop. I
do not care what format the desktop database is in as long as I can
access it using VB.Net 2005 code.

I will be creating an application for the desktop that will take the
data collected on the device and process it on the desktop.

I do not require replication, in fact I prefer not to have it. So how do
I proceed? What is the most practical way to proceed? This app will be
used by people without access to SQL Server. It would be excellent if
this could be done stand-alone but I do not know the best course to take.

Please provide advice.

Thanks

:L

 

[Maciej Wolniewicz]

Hi,

you can use in your application SQL Server Compact Edition( I'm not sure but
I think it is SQL Server CE 3.0, please correct me if I'm wrong), it can be
used both in CF2 and also on desktop, so the same database file can be used
on device and on desktop. You can simply copy database from device to
desktop or replicate them somehow to desktop.
More information about SQL Compact Edition you will fimnd on Microsoft site.

Regards,
Maciej Wolniewicz

 

[Loogie]

Hi,

you can use in your application SQL Server Compact Edition( I'm not sure but
I think it is SQL Server CE 3.0, please correct me if I'm wrong), it can be
used both in CF2 and also on desktop, so the same database file can be used
on device and on desktop. You can simply copy database from device to
desktop or replicate them somehow to desktop.
More information about SQL Compact Edition you will fimnd on Microsoft site.

Regards,
Maciej Wolniewicz

I think it is now called SQL Server 2005. I have just downloaded it and
am installing.

Thanks

:L

 

[Loogie]

I think it is now called SQL Server 2005. I have just downloaded it and
am installing.

Thanks

:L

erm make that SQL Compact Server 2005 DOH!

:L

 

[William \(Bill\) Vaughn]

Actually, it's "SQL Server 2005 Compact" or "SQL Server 2005 Compact
Edition". Yes, I think you're on the right track but I found the MS
documentation a bit thin. I would take a look at my EBook on the subject.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------