Problem solve Get help with specific problems with your technologies, process and projects.

Is it possible to schedule SQLs written for a paradox database?

Is it possible to schedule SQLs written for a paradox database? I have written four SQL scripts to extract weekly data from a few paradox tables. As of now, I am running these queries manually and exporting the result set into text files using the export facility of Paradox. Is it possible to automate the whole process to save time and reduce the chances of any error(s)?
You can always automate things! You just need to create a Windows Service application, that will run the scheduled task. When it runs, you can just connect to the paradox database using ADO.NET and extract the data directly. Check my previous answers: https://searchwindevelopment.techtarget.com/answer/Making-a-connection-to-a-Paradox-database and https://searchwindevelopment.techtarget.com/answer/How-can-I-make-a-connection-to-a-Paradox-password-protected-database.

Dig Deeper on Win Development Resources

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.