I am trying to set up a synchronization model to sync my consolidated Oracle database with a remote SQL Anywhere database. I have a couple Views on the consolidated Oracle database that I want to pull into the Sql Anywhere database as tables. I want to pull them over as they touch 4-5 tables (gotta love good normalization) and only have 7-8 columns that I need read access to (i.e. I will never try to update them. I just need to pull from the consolidated to the remote db). How do I do this?
Sybase sql anywhere sync a Database view(pull from consolidated to remote)?
773 Views Asked by runxc1 Bret Ferrier At
1
There are 1 best solutions below
Related Questions in ORACLE
- How do I compile QScintilla and Eric6 on Linux?
- how to connect the signal to slot in pyqt5 and qml?
- How can QOpenGLWidget update not result in paintGL events?
- Qt platform plugin 'windows' - py2exe
- Running python code exported from qt creator and converted to python using pyqt5
- cmd/DOS window opens with GUI created with py2exe
- How to package pyqt5 program and qml into exe using cx_Freeze
- Pyqt - Add a QMenuBar to a QMainWindow which is in another class
- python3.4 + pyqt5: Getting x,y out of QMouseEvent
- QComboBox, PyQt5 - Numbers in Item strings are reordered
Related Questions in SYNCHRONIZATION
- How do I compile QScintilla and Eric6 on Linux?
- how to connect the signal to slot in pyqt5 and qml?
- How can QOpenGLWidget update not result in paintGL events?
- Qt platform plugin 'windows' - py2exe
- Running python code exported from qt creator and converted to python using pyqt5
- cmd/DOS window opens with GUI created with py2exe
- How to package pyqt5 program and qml into exe using cx_Freeze
- Pyqt - Add a QMenuBar to a QMainWindow which is in another class
- python3.4 + pyqt5: Getting x,y out of QMouseEvent
- QComboBox, PyQt5 - Numbers in Item strings are reordered
Related Questions in SQLANYWHERE
- How do I compile QScintilla and Eric6 on Linux?
- how to connect the signal to slot in pyqt5 and qml?
- How can QOpenGLWidget update not result in paintGL events?
- Qt platform plugin 'windows' - py2exe
- Running python code exported from qt creator and converted to python using pyqt5
- cmd/DOS window opens with GUI created with py2exe
- How to package pyqt5 program and qml into exe using cx_Freeze
- Pyqt - Add a QMenuBar to a QMainWindow which is in another class
- python3.4 + pyqt5: Getting x,y out of QMouseEvent
- QComboBox, PyQt5 - Numbers in Item strings are reordered
Related Questions in MOBILINK
- How do I compile QScintilla and Eric6 on Linux?
- how to connect the signal to slot in pyqt5 and qml?
- How can QOpenGLWidget update not result in paintGL events?
- Qt platform plugin 'windows' - py2exe
- Running python code exported from qt creator and converted to python using pyqt5
- cmd/DOS window opens with GUI created with py2exe
- How to package pyqt5 program and qml into exe using cx_Freeze
- Pyqt - Add a QMenuBar to a QMainWindow which is in another class
- python3.4 + pyqt5: Getting x,y out of QMouseEvent
- QComboBox, PyQt5 - Numbers in Item strings are reordered
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
MobiLink can certainly support synchronizing with views, but that isn't supported in synchronization models because views don't have primary keys (which sync models need, as outlined on the first page of the wizard), and uploading to views requires an updatable view or "instead of" triggers.
A workaround is to temporarily define a table with the same schema as the view, plus appropriate primary key definitions. It would be simplest to use the same name for the table, but for that you'd need to use a different database. Pick that database/table when loading the consolidated schema, and define that table mapping to be download only.
Then you should be able to deploy that model to the Oracle database with the view. If you had to use a different name for the table than for the view, you should deploy to file and globally replace the table name with the view name in the generated SQL file.