I need to transfer dbf file to sql server 2005 express edition with some periodic interval. Can any one please recommend which is the easiest and efficient method to do?. Like polling every 5 to 10 seconds transfer data to sql server 2005 ex edition.
Is it recommend to do it visual basic program?, how to do it. pls help
In SQL 2005 you can set up a linked server, a stored procedure, and a recurring job to run the stored procedure. I'm assuming you want to import only new or changed rows from the DBF and the stored procedure would allow you to do this before you update your main table.
I don't usually work with SQL Express, and I see that you can set up a linked server, but SQL Server Agent is not available to set up the recurring job. However, you could write an external program (such as in VB) to call the stored procedure at the desired intervals.