Re: Merge/Replication or Syncing with Oracle

Tom,

You can install the Sync Servcies beta with VS 2005. You can also run VS 2005 side by side with VS 2008 beta 2 - I am doing that. It's up to you.

You can't directly access an Access database on the desktop from a WM 5 app, but you can sync between SQL Compact on the WM device and Access using the Access Syncronizer: http://www.microsoft.com/downloads/details.aspx?FamilyID=b967347a-5dd0-445c-8a9f-aea3db9ec4bc&displaylang=en

--
Ginny Caughey
Device Application Development MVP


"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message news:uLEDMu53HHA.536@xxxxxxxxxxxxxxxxxxxxxxx
After doing lots of research, I agree that Sync Services will be the way to go. Can I download the BETA of Sync Services and ADO.NET 3.0 and still use that with Visual Studio .NET 2005? I don't want to mess up my existing development environment?

As for the Oracle issue ... since there does not seem to be an ADOCE Driver for Oracle just yet, I may tell the client to spring for Oracle Lite 10g. This is Oracle's answer to SQL Server Compact Edition ....
Where SQL Compact Edition easily does merge/replication to SQL Server using IIS ... or where I can connect directly to SQL Server from the PDA ... Oracle Lite 10g does easy Merge/Replication with an Oracle backend.

Here is another probably easy question .... and I am not sure if I asked this before ... can the VB.NET app on the PPC (WM 5.0) open directly to an Access database???????? If not, that's ok ... I'll find another way, like copying the SDF to the desktop.

Thanks again for all the help!
Tom

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message news:D85BD52C-2C1C-4D97-91F0-936C2F68B92D@xxxxxxxxxxxxxxxx
Hi Bill,

Yep it's supposed to be anything to anything syncing in general, but since it's built on top of existing ADO.Net technology, I don't know if an Oracle sync adapter will be provided on the device.

--
Ginny Caughey
Device Application Development MVP


"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message news:O948qJv3HHA.4900@xxxxxxxxxxxxxxxxxxxxxxx
ADO.NET 3.0 sync services can sync between Oracle and SQL Ce... or so I am told.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
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)
-----------------------------------------------------------------------------------------------------------------------

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message news:B6E1AB19-0996-4E4A-8E86-00A82EF45A49@xxxxxxxxxxxxxxxx
Tom,

I believe you can do merge replication between SQL Compact, SQL Server, and then Oracle, but you have to have the SQL Server in the middle to make it work

If you're only concerning about syncing between the mobile device and Oracle is when the device is cradled, you could also consider writing a Rapi app that copies the SQL Compact sdf file to the desktop where a desktop app could then read and write to both SQL Compact and Oracle.

--
Ginny Caughey
Device Application Development MVP


"Tom Holmes Jr." <tom@xxxxxxxxxxxxx> wrote in message news:eAXpQEt3HHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Ginny and Chora .... thanks for the help, I do appreciate it.

I was hoping that Merge/Replication would work from the Compact Edition to Oracle.
I thought I saw somewhere how to do it ... albeit, it might be a transactional snapshot.
I am definitely sure there is Merge/Replication between Oracle databases and SQL Servers (on the desktop server).

In the case where I can't do Merge/Replication with Oracle (until Sync Services is released), then my alternative would be to directly connect to the Oracle backend from the PDA, provided that the PDA is in the cradle. Not even going to worry about connected over WiFi since this app will definitely run disconnected from the office.

As Ginny suggested I will check with the Oracle site and see if I can get a PDA driver from them. Ultimately, a direct connection to the backend database from the PDA (while cradled) is the best situation for me now.

Thanks!


"chora" <choracyAThotmail.com> wrote in message news:e71B0Ym3HHA.5164@xxxxxxxxxxxxxxxxxxxxxxx

I think we are talking different things here. Merge replication is about
synchronising two databases and in our case sychronizing the device's
database with a server's one in an occasionally connected scenario.

If your devices are always connected, you can update directly a server
database, no replication or similar technology required.

I do not believe you can find an ADOCE driver for Oracle, but in an
always connected scenario you can develop a desktop application, with
the tool of your preference, making sure that the screens fit the
handheld device. Then you can use Windows Mobile Terminal Services
client to execute your application from any number of connected
handhelds.



*** Sent via Developersdex http://www.developersdex.com ***






.

Relevant Pages

  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)
  • Re: Oracle vs SQL Server as a back end for Access?
    ... post -- comparing back end database engines or replacing the front end ... say that Oracle 10g is better than SQL Server 2000 without determining ... whether or not the total cost of ownership of 10g over SQL Server ... developer than Oracle 10g, in spite of its new web interface. ...
    (comp.databases.ms-access)
  • Re: Oracle licence question
    ... And no - it does not freeze anything, the backups DO NOT affect connections ... SQL Server MVP ... freeze the database and send it to the target. ... What I really wanted is something that lists features I get in Oracle ...
    (comp.databases.oracle.server)
  • Re: Wireless Synchronization
    ... desktop database and PPC database. ... Directly Querying SQL Server using SqlClient (Bit Slow while ... Web Services ... Services as the sync option. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: General Question about Performance/Tuning and scheduled Tuning
    ... I have a general question about Performance and Tuning. ... some application on a MS SQL Server, ... think that must be possible with a oracle server too. ... Database is so fast as before. ...
    (comp.databases.oracle.server)