Export data to SQL

[sabavno]

Hi,

I am looking for the best solution to export the Notes data to SQL tables.

Could you please describe some of the ways already used.

Thanks in advance.

 

[brownie124]

If you are talking about a 1 time export of data then the best, fastest and easiest way to do this is to build a view and then from the view, do File-Export. Then on the SQL server (I am speaking from the MS SQL vantage point now) do the import into the table you want of the text file that was created on the export.

If it is something that needs to be ongoing and more interactive, you will have to look at the ODBC classes in LotusScript to see how to do this.

- Brownie

 

[jalsa]

The most common way to do data exchanges is with notespump, or now called LEI (Lotus Enterprise Integrator, I think). You set that up on the server, then you can move data back and forth in "real-time".