I have a report with a date/time picker defined. When I run the report, if I enter the date/time by hand (such as 2022-04-10 06:00) I get an error if there is more than one space between the date and time. This seems unnecessarily fragile.
I have a situation where I'm trying to use SymmetricDS to move data between two databases on the same Postgres server. My dataases are called Production and Reporting. Each has 3 schemas - bi_reporting, symmds, and public. I have created a user (symmds) to be the owner of the objects and processes that move data from Production.bi_reporting to Reporting.bi_reporting. I have executed the following: alter user symmds set search_path to symmds; grant create on schema symmds to symmds; In each of the...
I have a situation where I'm trying to use SymmetricDS to move data between two databases on the same Postgres server. My dataases are called Production and Reporting. Each has 3 schemas - bi_reporting, symmds, and public. I have created a user (symmds) to be the owner of the objects and processes that move data from Production.bi_reporting to Reporting.bi_reporting. I have executed the following: alter user symmds set search_path to symmds; grant create on schema symmds to symmds; In each of the...
I have a situation where I'm trying to use SymmetricDS to move data between two databases on the same Postgres server. My dataases are called Production and Reporting. Each has 3 schemas - materials, symmds, and public. It pretty much looks like this: POSTGRES (server) | |-Databases | |-Production | |-Schemas | |-bi_reporting |-symmds |-public |-Reporting | |-Schemas | |-bi_reporting |-symmds |-public I have created a user (symmds) to be the owner of the objects and processes that move data from...
In Postgres I created a new schema (symmds) and role ( also symmds) to own my SymmetricDS schema and objects. I performed "alter user symmds set search_path to symmds;" and I schema-qualified all of the sql statements in my insert_whatever.sql file. When I execute "symadmin --engine birep-prod create-sym-tables' I get the following error: [birep-prod] - ClientExtensionService - Found 7 extension points from spring that will be registered [birep-prod] - AbstractSymmetricEngine - Initializing SymmetricDS...
In Postgres I created a new (symmds) role ( also symmds) to own my SymmetricDS schema and objects. I performed "alter user symmds set search_path to symmds;" and I schema-qualified all of the sql statements in my insert_whatever.sql file. When I execute "symadmin --engine birep-prod create-sym-tables' I get the following error: [birep-prod] - ClientExtensionService - Found 7 extension points from spring that will be registered [birep-prod] - AbstractSymmetricEngine - Initializing SymmetricDS database...
Currently we support Postgres and MS Sql Server.
Ok - I am now able to save scheduled jobs. Thank you for all your help. Regards