This shows you the differences between two versions of the page.
|
integration:rdbms:sqlserver:updates [2011/04/12 16:29] doc |
integration:rdbms:sqlserver:updates [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Integration: Relational Databases ====== | ||
| - | |||
| - | ===== SQL Server ===== | ||
| - | |||
| - | [[integration:rdbms:sqlserver:home|Overview]] | | ||
| - | [[integration:rdbms:sqlserver:environments|Environments]] | | ||
| - | [[integration:rdbms:sqlserver:databases|Databases]] | | ||
| - | [[integration:rdbms:sqlserver:tables|Tables]] | | ||
| - | [[integration:rdbms:sqlserver:constraints|Constraints]] | | ||
| - | [[integration:rdbms:sqlserver:datatypes|Datatypes]] | | ||
| - | [[integration:rdbms:sqlserver:queries|Queries]] | | ||
| - | **[[integration:rdbms:sqlserver:updates|Updates]]** | | ||
| - | [[integration:rdbms:sqlserver:example|Example]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Updates ==== | ||
| - | |||
| - | Omnidex is primarily used on read-only databases; however, Omnidex can also be used on read-write databases. Omnidex supports the INSERT, DELETE and UPDATE SQL statements. There are several restrictions that administrators must be aware of before deciding whether to use Omnidex on a read-write database: | ||
| - | |||
| - | {{page>:admin:basics:updates:restrictions_insert&nofooter&noeditbtn}} | ||
| - | |||
| - | Given these restrictions, most Omnidex applications refresh the data at regular intervals such as daily, weekly, or monthly. Once the data is refreshed, the indexes are rebuilt, producing an indexed version of the new data. This data can then be deployed into production. | ||
| - | |||
| - | For applications that require online updates, applications can use INSERT, DELETE, and UPDATE statements to update the table. This approach immediately updates both the database and the Omnidex indexes. | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rdbms:sqlserver:queries|Prev]]** | | ||
| - | **[[integration:rdbms:sqlserver:example|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||