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)?
800 Views Asked by runxc1 Bret Ferrier At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in SYNCHRONIZATION
- How to avoid concurrent access to a resource?
- Multiple jQuery slideshows won't stay in sync
- How to ensure data synchronization across threads within a "safe" area (e.g not in a critical section) without locking everything
- Multiple locks of one method from multiple objects
- laravel sync() equivalent for OneToMany relation
- git - Why reset --hard seems to be always needed
- LDAP Directory Synchronization Tools
- Migrating Nexus repository manager
- Implement two way syncing with Mysql In Iphone
- spin_lock before writing status register
- What's the best way to implement a single consumer, multiple producer scenario using Python?
- Why only mark() and reset() method are synchronized in java.io.InputStream?
- Any tools available for auto syncing the .js files
- Order of execution of Threads waiting for a synchronised block
- No Synchronize Model with Database in Mysql Workbench
Related Questions in SQLANYWHERE
- How To DROP auto increment from a column in sybase
- Entity Framework with Sybase SQL Anywhere 16 crashes Visual Studio
- Failed to generate type library for iAnywhere.Data.SQLAnywhere
- Use wildcards in ado.net sybase parameter
- Entity Framework connection factory not working
- Sybase SQL anywhere 11 Grant/Revoke on column views
- node.js sqlanywhere compilation/update errors
- SQLAnywhere PHP extension errors on Apache restart
- SQL Anywhere pass row as parameter to stored procedure
- SqlAnywhere, Ruby and macOS Sierra. DBCAPI libraries couldn't be loaded
- Sybase Sql Anywhere Backup
- connecting sybase by using DSN + SQLAnywhere
- OUTPUT TO csv file - SQL Anywhere using pyodbc gives error
- Deleting row from table c#
- Mssql query exec returns error
Related Questions in MOBILINK
- How to setup a mobilink client and server and test the synchronisation?
- Sybase Mobilink Hardware requirements
- Sybase sql anywhere sync a Database view(pull from consolidated to remote)?
- SyBase SQL anywhere check if Synchronization is needed?
- SQLE_NOT_PUBLIC_ID Sybase mobilink error
- Mobilink with MySQL on Linux
- MobiLink synchronization scripts generation
- UltraLiteJ Error[-1305]: MobiLink communication error -- code: 201, parameter: 128, system code: 0 Error
- Sync failed:-857 The remote database identified by remote ID '%1' is already synchronizing or the database connection is unusable:
- MobiLink Profiler fails to start on ONE instance of SQL Anywhere. Error seems to indicate that it's not finding the Java folder
- MySQL mobilink synchronization with SQL Anywhere
- Mobilink error with Syncing to Production Oracle DB Options
- How do you get Mobilink to synchronize tables so that the most recent updated table is not overwritten?
- Registering Mobilink with Mobile Device Center on Vista has errors
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 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.