Newsletter #4, January 6, 2009

Migration of Oracle SQL*Loader Tasks to SQL Server

Posted by admin on Jan 6, 2009 • (0)

SQL*Loader is a command line utility which performs fast loading from one or more files into Oracle tables. The utility processes the source files according to the settings in a special CONTROL file. As a result of SQL*Loader execution, additional files can be created: these include BAD file, where discarded rows are saved and ERROR [...]

Noise Words and Migration from Oracle Text to SQL Server 2005

Posted by admin on Jan 6, 2009 • (1)

Oracle Text functionality can be emulated in SQL Server with Full-Text Search feature. In this article I am going to tell about some peculiarities of Full-Text Search, namely, about the noise words issue, and to provide a solution for using these words in queries to achieve the desired effect.
When using Oracle Text, we can identify [...]

1