I have a database that needs to have all of the data that is in it extracted out to a SQL Server. I have wrote and agent to do this. The only thing with the agent is that it takes atleast 2 days to run through the entire database. Does anybody know of a more efficent way of doing this through Lotus Notes. Right now I have the agent looping through each form getting all of the data on the form and then going to the next one and doing the samething. If anyone has a better idea please let me know. This is also a database that needs to be scheduled for the first of the month every month and it times out before it can complete.
Thanks for the help
Christy