Solved

synchronizing an MS SQL Server CE database with an oracle database

Posted on 2006-07-05
5
404 Views
Last Modified: 2006-11-18
hi,

just wondering .. is there a way to sync an ms sql server ce database (residing in a pda) with a backend oracle database?

thanks & regards,
rei
0
Comment
Question by:hating_it
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 33

Expert Comment

by:hongjun
ID: 17101227
Posted a pointer question without your knowledge
http:Q_21918387.html


hongjun
0
 
LVL 33

Expert Comment

by:hongjun
ID: 17101230
Because I am also interested to know.
0
 
LVL 33

Expert Comment

by:hongjun
ID: 17101254
One more in Oracle TA
http:Q_21918389.html

hongjun
0
 
LVL 14

Accepted Solution

by:
sathyagiri earned 125 total points
ID: 17101292
From Oracle you can connect to a sql server db using remote db links with heterogeneous services.

Refer to this link for set up instructions
http://www.databasejournal.com/features/oracle/article.php/10893_3442661_1 
0
 
LVL 35

Expert Comment

by:johnsone
ID: 17102743
Using an ODBC connection you can link to Oracle from SQL Server.  I believe that way you can create a linked table.  Then you can create a DTS package to do the work on the SQL side.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question