No you will always have to have some sort of Internet connection when working with salesforce's API, that is a given

It depends on what type of database you are using, I have two tutorials, one uses Oracle and one uses MySQL >Salesforce – PHP To MySQL Database Replication Script


I think I remember reading somewhere that you are using MS Sql, if that is true, ADOdb works with that, you would just need to create your tables in your local MS SQL database or use MySQL (it's free)

I dont work with MS SQL at all and never have, but it cannot be too hard to setup a script to work

Hope that helps

I am leaving on vacation tomorrow for 15 days, I wont be around to answer stuff after tomorrow morning (my time, -6 GMT)

Sorry if that is not enough and I do really appreciate you participating in my little community

I hope that I have been some help with your work

All the best,
Mike