Is there any update?
Is there any update?
Any update on this? Thanks
I noticed there was an additional trigger named as <tablename>_etl_modtime_UT</tablename> only on the tables of the node that triggered initial load correctly. Is there any specific step I missed for not having that on tables of other nodes? Thanks
I attached the symmetric.log herewith. Steps done : 1. Executed create-sym-tables for each engine. 2. Set rev_initial_load_enabled=1 for each node on SYM_NODE_SECURITY in source db. 3. Updated sym_channel, sym_trigger and sym_trigger_router in source db. 4. Then started the service. sudo bin/sym_service.bat stop sudo bin/sym_service.bat uninstall sudo bin/sym_service.bat install sudo ./bin/sym.bat
Any clue on this? Thanks
Any clue on this? I noticed there was an additional trigger named as <tablename>etlmodtimeUT</tablename> only on the tables of the node that triggered initial load correctly. Is there any specific step I missed for not having that on tables of other nodes? Thanks
Any clue on this? I noticed there was an additional trigger named as <tablename>_etl_modtime_UT</tablename> only on the tables of the node that triggered initial load correctly. Is there any specific step I missed for not having that on tables of other nodes? Thanks
Any update on this?
Hi Jake & Eric, I created corp-000 as the target node and store-<dbname> as the source nodes. I added the sync.url of the target node as the registration.url of source nodes engine files as you have suggested. Then, </dbname> Executed create-sym-tables for each engine. Set rev_initial_load_enabled=1 in SYM_NODE_SECURITY in each source db. Updated sym_channel, sym_trigger and sym_trigger_router for each source db. Inserted following 4 records into SYM_TABLE_RELOAD_REQUEST table in target db for each...
I'm new to SymmetricDS. It's bit confusing for me how to configure this setup on SymmetricDS. Our requirement is like this. We have 4 MSSQL databases (DB1, DB2, DB3 and DB4). All 4 should be pointed to one target db (DB5). So I created 4 source nodes for each source databases (DB1, DB2, DB3 and DB4) and one target node for the DB5 in the same SymmetricDS installation. All the changed data and initial load in 4 source nodes should be routed to DB5 only, not the other way round. Hope this requirement...
Any update on this?
Let me explain our requirement again: We have 2 MSSQL databases (DB1 and DB2). Both should be pointed to one target db (DB3). So I created 2 source nodes for each source database(DB1 and DB2) and one target node for the DB3 in the same SymmetricDS installation. All the changed data and initial load in DB1 and DB2 should be routed to DB3 only, not the other way round. Hope this requirement is clear. I'm new to SymmetricDS. It's bit confusing for me how to configure this setup on SymmetricDS. Thank...
Let me explain our requirement again: We have 2 MSSQL databases (DB1 and DB2). Both should be pointed to one target db (DB3). So I created 2 source nodes for each source database(DB1 and DB2) and one target node for the DB3 in the same SymmetricDS installation. All the changed data and initial load in DB1 and DB2 should be routed to DB3 only. Hope this requirement is clear. I'm new to SymmetricDS. It's bit confusing for me how to configure this setup on SymmetricDS. Thank you.
Is there any update on this? Let me explain our requirement again: We have 2 MSSQL databases (DB1 and DB2). Both should be pointed to one target db (DB3). So I created 2 source nodes for each source database(DB1 and DB2) and one target node for the DB3 in the same SymmetricDS installation. All the changed data and initial load in DB1 and DB2 should be routed to DB3 only. Hope this requirement is clear. I'm new to SymmetricDS. It's bit confusing for me how to configure this setup on SymmetricDS. Thank...
I have already added that.
Any update on this?
Any update on this? Is this not possible to do with symmetricDS ?
Thank you so much for the reply. That started all the nodes as ecpected. I updated sym_trigger and sym_trigger_router tables for tablea on node mastera and for tableb on node masterb. insert into sym_trigger (trigger_id,source_table_name,channel_id,last_update_time, create_time) values('tablea','tablea','fte',current_timestamp, current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('tablea','corp to store', 100, current_timestamp,...
Thank you so much for the reply. That started all the nodes as ecpected. I updated sym_trigger and sym_trigger_router tables for tablea on node mastera and for tableb on node masterb. insert into sym_trigger (trigger_id,source_table_name,channel_id,last_update_time, create_time) values('tablea','tablea','fte',current_timestamp, current_timestamp); insert into sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) values('tablea','corp to store', 100, current_timestamp,...
Thanks for the response. I'm using Cygwin and the same commands with symadmin.bat and symservice.bat worked fine when it has one source (mssql) db and one target (H2) db. I set the absolute path to java.exe in conf/sym_service.conf. wrapper.java.command=D:\apps\java-1.8.0-openjdk\bin\java.exe I added following line to the masterb properties file. registration.url=http://localhost:31415/sync/corp-mastera Then created Sym tables on all 3 nodes using following, sudo ./bin/symadmin.bat --engine corp-mastera...
Thanks for the response. I'm using Cygwin and the same commands with symadmin.bat and symservice.bat worked fine when it has one source (mssql) db and one target (H2) db. I set the absolute path to java.exe in conf/sym_service.conf. wrapper.java.command=D:\apps\java-1.8.0-openjdk\bin\java.exe I added following line to the masterb properties file. registration.url=http://localhost:31415/sync/corp-mastera Then created Sym tables on all 3 nodes using following, sudo ./bin/symadmin.bat --engine corp-mastera...
Thanks for the response. I'm using Cygwin and the same commands with symadmin.bat and symservice.bat worked fine when it has one source (mssql) db and one target (H2) db. I set the absolute path to java.exe in conf/sym_service.conf. wrapper.java.command=D:\apps\java-1.8.0-openjdk\bin\java.exe I added following line to the masterb properties file. registration.url=http://localhost:31415/sync/corp-mastera Then created Sym tables on all 3 nodes using following, sudo ./bin/symadmin.bat --engine corp-mastera...
Thanks for the response. I'm using Cygwin and the same commands with symadmin.bat and symservice.bat worked fine when it has one source (mssql) db and one target (H2) db. I set the absolute path to java.exe in conf/sym_service.conf. wrapper.java.command=D:\apps\java-1.8.0-openjdk\bin\java.exe I added following line to the masterb properties file. registration.url=http://localhost:31415/sync/corp-mastera Then created Sym tables on all 3 nodes using following, sudo ./bin/symadmin.bat --engine corp-ftedb...
Thanks for the response. I'm using Cygwin and the same commands with symadmin.bat and symservice.bat worked fine when it has one source (mssql) db and one target (H2) db. I set the absolute path to java.exe in conf/sym_service.conf. wrapper.java.command=D:\apps\java-1.8.0-openjdk\bin\java.exe I added following line to the masterb properties file. registration.url=http://localhost:31415/sync/corp-mastera Then created Sym tables on all 3 nodes using following, sudo ./bin/symadmin.bat --engine corp-ftedb...
Hi, I'm trying to setup SymmetricDS for multiple MSSQL dbs (called A and B ) and only one target db (called C). The requirement is to replicate all DMLs of A and B master nodes to target node C. 1. Is this requirement possible? 2. Could you please suggest what I missed here. I came up with the following configurations. MASTER A engine.name=corp-mastera db.driver=net.sourceforge.jtds.jdbc.Driver db.url=jdbc:jtds:sqlserver://localhost:1433/mastera;useCursors=true;bufferMaxMemory=10240;lobBuffer=5242880...