Newsletter #3, December 18, 2008

How to Convert Oracle Text statements to SQL Server 2005

Posted by admin on Dec 18, 2008 • (1)

This article overviews Oracle Text, which is Oracle integrated full-text retrieval technology, and shows the ways to emulate its functionality in Microsoft SQL Server 2005. In Oracle, the CONTEXT index type is used to index large amounts of text. Similar functionality is implemented as Full-Text Search in SQL Server and full-text indexes are used to [...]

How to Move Auditing Functionality during Oracle to SQL Server 2008 Migration

Posted by admin on Dec 18, 2008 • (4)

Standard Oracle auditing feature allows capturing many pieces of information about database events. You can track the fact that an event occurred, the time when it occurred, the user who caused the audited event, and which client machine the user was on when the event happened. An audited event can be a user login, a [...]

1