Re: Merge/Replication or Syncing with Oracle

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)