View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002260 | SymmetricDS | Improvement | public | 2015-04-09 08:30 | 2023-05-31 17:00 |
| Reporter | dlauwers | Assigned To | emiller | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.10 | ||||
| Target Version | 3.14.8 | Fixed in Version | 3.14.8 | ||
| Summary | 0002260: Also sync the stored procedures with the schema | ||||
| Description | When a stored procedure is created/changed on a central Master DB, these stored procedures should be updates on the different nodes so all the stored procedures are always in sync with a central master DB. Symmetric DS could monitor those changes (or via a manual command) and put the needed SQL statements automatically in a data event to be executed at the node. A check to see if the stored procedure should be created or altered on the specific node should be includes so that in all circumstances the stored procedure is created/updated correctly. | ||||
| Tags | ddl/schema | ||||
|
SymmetricDS: 3.14 0a8f84e9 2023-05-31 16:46:03 evan-miller-jumpmind Details Diff |
0004151: Detected and prevented some errors when syncing DDLand an object is unexpectedly missing or present (also covers issue 0002260) |
Affected Issues 0002260, 0004151 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/AbstractSqlTemplate.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/ISqlTemplate.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/sql/JdbcSqlTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-04-09 08:30 | dlauwers | New Issue | |
| 2019-04-23 17:10 | elong | Tag Attached: ddl/schema | |
| 2019-10-27 16:05 | elong | Relationship added | related to 0004109 |
| 2023-05-31 16:40 | emiller | Relationship added | related to 0004151 |
| 2023-05-31 16:46 | emiller | Assigned To | => emiller |
| 2023-05-31 16:46 | emiller | Status | new => resolved |
| 2023-05-31 16:46 | emiller | Resolution | open => fixed |
| 2023-05-31 16:46 | emiller | Fixed in Version | => 3.14.8 |
| 2023-05-31 17:00 | Changeset attached | => SymmetricDS 3.14 0a8f84e9 | |
| 2023-07-19 12:58 | admin | Status | resolved => closed |