<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
As in SQL, one would use MINUS or EXCEPT to return a set of results containing only differences. I would like to know how to mimic this functionality between a Notes DB and a SQL Table using LEI. <br />
<br />
Has anyone ever exported only &quot;changed documents&quot; using LEI?<br />
<br />
The reason for my question is that the exports which we currently have are full exports and are beginning to time out. These are inefficient and would appreciate advice on what surely must be common practice.<br />
<br />
Regards
</div>
</div>


Hi,

As in SQL, one would use MINUS or EXCEPT to return a set of results containing only differences. I would like to know how to mimic this functionality between a Notes DB and a SQL Table using LEI. 

Has anyone ever exported only "changed documents" using LEI?

The reason for my question is that the exports which we currently have are full exports and are beginning to time out. These are inefficient and would appreciate advice on what surely must be common practice.

Regards

LEI - MINUS/EXCEPT statement ability between Notes and SQL

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.

Lotus IBM

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.