You must enable javascript in order to view this page or you can go
here
to view the webhelp.
The DB Sync framework 5.01
Search is case-insensitive.
Use
and/or
as operators.
[word1 word2]
is like
[word1
or
word2]
Do not use quotes to group words.
Example: [datetimeedit
and
new
and
features]
Content
Search Results
Index
Loading, please wait ...
DB Sync framework purpose
What's new in DB Sync
Concepts
DB Sync framework purpose
Actors of DB Sync
DB Sync architecture
DB Sync objects
Application SQL tables
User authentication and permissions
The synchronization mechanism
Concurrent data access conflicts
Data filters
DB Sync implementation tasks
Installation
Software Requirements
Package installation
Locale settings
Set Up
Before starting with setup
Set up DB Sync with GAS/GIP
Prepare the GAS for DB Sync
Configure GIP for DB Sync
Set up the server configuration file
Set up the database schema file
Create DB Sync client apps
Create DB Sync users
DB Sync GAS/GIP setup test
Set up DB Sync in direct mode
Set up DB Sync for server-side apps
DB Sync system tables
Database maintenance
Configuration files
Server configuration file
Client configuration file
Database schema reference
SQL table definition
SQL column definition
Auto incremented columns
Relations between SQL tables
Administration consoles
Database schema editor
Schema definitions
SQL table properties
SQL column properties
Auto-incremented columns
Foreign key properties
Apps definition console
App definitions
Associating tables to apps
App/Table permissions
Defining data filters
Users definition console
User definitions
Associating apps to users
User/App/Table permissions
Data filter parameter values
Change log viewer
Implementing a DB Sync server-side app
Concepts for DB Sync server-side apps
Step-by-step DB Sync server-side app implementation
Import the DB Sync API modules
Initialize the DB Sync API
Register the schema, app and user
Connect to the central database
Registering changes in the DB Sync central change log
Clean up the DB Sync API
Implementing a DB Sync client app
Concepts for DB Sync client apps
Step-by-step DB Sync client app implementation
Import the DB Sync API modules
Initialize the DB Sync API
Declare the database schema
Initialize the SQLite local database
Register sync source parameters
User authentication in direct mode
User authenticating with GAS/SSO/GIP
Declare application SQL tables
Data changes: Row creation (INSERT)
Data changes: Row change (UPDATE)
Data changes: Row removal (DELETE)
Synchronizing with central database
Cleanup the DB Sync API
Commands reference
dbsync_tool
dbsync_schema
dbsync_setup
dbsync_server
dbsync_app_conf
dbsync_user_conf
DB Sync demos
Books demo
DB Sync API reference
dbsync_core: Core module
dbsync_core.t_dbsync_source type
dbsync_core.t_dbsync_event type
dbsync_core.t_dbsync_event_array type
dbsync_core.t_app_id type
dbsync_core.t_user_id type
dbsync_core.t_user_auth type
dbsync_core.t_user_name type
dbsync_core.t_user_status type
dbsync_core.t_user type
dbsync_core.t_user_ident type
dbsync_core.t_mtime type
dbsync_core.t_table_name type
dbsync_core.t_tabinfo type
dbsync_core.t_tabinfo_rec type
dbsync_core.enter_user_credentials()
dbsync_core.read_dbsync_source_file()
dbsync_app: Client app module
dbsync_app.apply_data_changes()
dbsync_app.cleanup()
dbsync_app.collect_local_changes()
dbsync_app.collect_local_pkeys()
dbsync_app.compact_local_changes()
dbsync_app.data_reset()
dbsync_app.data_sync()
dbsync_app.data_sync_init()
dbsync_app.data_sync_retrieve()
dbsync_app.data_sync_send()
dbsync_app.data_sync_set_full_sync()
dbsync_app.data_sync_set_return_receipt()
dbsync_app.get_database_copy()
dbsync_app.get_user_info()
dbsync_app.get_app_tables()
dbsync_app.get_result_events()
dbsync_app.initialize()
dbsync_app.is_row_referenced()
dbsync_app.new_temp_autoincr()
dbsync_app.register_dbsync_source()
dbsync_app.register_dbsync_user()
dbsync_app.register_local_change()
dbsync_app.register_local_change_cpk2()
dbsync_app.register_local_change_cpk3_s()
dbsync_app.register_local_change_s()
dbsync_app.register_local_dbschema()
dbsync_app.register_local_delete()
dbsync_app.register_local_delete_cpk2()
dbsync_app.register_local_delete_cpk3_s()
dbsync_app.register_local_delete_s()
dbsync_app.register_local_insert()
dbsync_app.register_local_insert_cpk2()
dbsync_app.register_local_insert_cpk3_s()
dbsync_app.register_local_insert_s()
dbsync_app.register_local_tables()
dbsync_app.register_local_update()
dbsync_app.register_local_update_cpk2()
dbsync_app.register_local_update_cpk3_s()
dbsync_app.register_local_update_s()
dbsync_app.send_return_receipt()
dbsync_srvapp: Server app module
dbsync_srvapp.central_change_cancel()
dbsync_srvapp.central_change_done()
dbsync_srvapp.central_change_init()
dbsync_srvapp.central_set_sync_timestamp()
dbsync_srvapp.cleanup()
dbsync_srvapp.initialize()
dbsync_srvapp.is_row_referenced()
dbsync_srvapp.register_central_app_params()
dbsync_srvapp.register_central_delete()
dbsync_srvapp.register_central_delete_cpk2()
dbsync_srvapp.register_central_delete_cpk3_s()
dbsync_srvapp.register_central_delete_s()
dbsync_srvapp.register_central_insert()
dbsync_srvapp.register_central_insert_cpk2()
dbsync_srvapp.register_central_insert_cpk3_s()
dbsync_srvapp.register_central_insert_s()
dbsync_srvapp.register_central_update()
dbsync_srvapp.register_central_update_cpk2()
dbsync_srvapp.register_central_update_cpk3_s()
dbsync_srvapp.register_central_update_s()
feedback
clear
submit