Suljettu

Db Sync Oracle to SQLlite

We have a requirement to have offline capability on an android client.

As a start I would like to test out the SYMETRIC-DS framework ( Or other to see how they manage two way synchronization of data between the Android Client and the Oracle Server.

Goal

1. Synchronize the PROD_INST table between ORA and SQLlite

2. The PROD_INST table contains all SERIAL NUMBERS, however the SQLlite should only contain those SERIALS for that agent

Below are the fields for the PROD_INST table

Name Null Type

--------------- -------- -------------

ID NOT NULL NUMBER(20)

SUPPLIER_ID NOT NULL NUMBER(20)

PROD_ID NOT NULL NUMBER(20)

SERIAL_CODE NOT NULL VARCHAR2(100)

COST_PRICE NOT NULL NUMBER(20,4)

COMPANY_ID NUMBER(20)

SITES_ID NUMBER(20)

AGENT_ID NUMBER(20)

LOADED_DATE DATE

EXPIRY_DATE DATE

STATUS NOT NULL VARCHAR2(100)

ELOADED_DATE DATE

ACTIVATION_DATE DATE

PORTED_DATE DATE

TOT_REV NUMBER(20,6)

TOT_COMM NUMBER(20,6)

MSISDN VARCHAR2(20)

LAST_TX_DATE DATE

BOX_ID NUMBER(20)

RECYCLED_DATE DATE

The client would contain a subset of that data under his agent_id

i.e. we would only sync the stock that is listed under his/her agent_id

select * from prod_inst where agent_id = ?

Deliverable

1. Demonstrate a SQLlite database inside an Android App

that is able to bidirectionally synchronize changes in the PROD_INST table

2. The SQLlite database will only have a subset of data for that AGENT_ID

3. You should show it working with multiple agents and demonstrate that the there is a 2 way sync

A possible Frame works has been identified

[login to view URL]

You are free to choose any framework that is suitable. Ideally The framework should be open source OR; cheap enough that we can consider it

Expected Delivery Dates

1. We will prepare a database that just has PROD_INST table in, along with a backup of the table PROD_INST_TMP you can use to refresh the database

2. We would like a working demo in a few days

Taidot: Android, Java, Oracle, SQL, SQLite

Näytä lisää: android sync sqlite with mysql, sqlite oracle connection, sqlite-sync tutorial, sqlite sync github, sqlite database synchronization, oracle database mobile server, sqlite replication synchronization, sqlite-sync xamarin, WPF Windows App + (Local MySQL DB + Sync Proc, iphone db sync, virtuemart multiple product changes, oracle sql days week, aspnet event calendar multiple days, multiple oracle login firefox, answers multiple choice oracle 10g, oracle programming multiple choice question, oracle 10g sql answers multiple choice, span multiple days aspnet calendar, oracle 10g sql multiple choice answer, route planner multiple real estate agents

Tietoa työnantajasta:
( 2 arvostelua ) Blairgowrie, South Africa

Projektin tunnus: #17034143

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

R5000 ZAR 7 päivässä
(144 arvostelua)
7.5
anuragiitk

I am an IITK graduate and I have 11 years of experience in software development. I have 100% completion rate and I have finished projects with the highest level of customer satisfaction. I have a team of rock star dev Lisää

R3888 ZAR 10 päivässä
(22 arvostelua)
5.4
bhavnadixit07

Hello , I am an android developer and I have more than 4 years of experience in android . I have completed more than 30 apps successfully . I have worked on features like Google map plotting, location tracki Lisää

R2222 ZAR 7 päivässä
(4 arvostelua)
1.7
R3888 ZAR 1 päivässä
(1 arvostelu)
0.9
R5555 ZAR 3 päivässä
(0 arvostelua)
0.0
sudhirchhag

Hi, Trust you are doing good. I understand your requirements for DB Sync to SQLite Our Expertise: [login to view URL] SDK, Versions, API level [login to view URL] component like Activity, Services, Content Provider, Broadcast R Lisää

R3888 ZAR 10 päivässä
(0 arvostelua)
0.0