PowerShell script

The following list on this page is about to show you the choices available for you to store SMS reports in a database. This solution is quite useful in case you enabled SQL Text Logging in SMS Gateway. By executing a Power shell script or setting up the Task Scheduler you don't have to insert the SMS reports one by one, these solutions insert the reports altogether and save a lot of time for you.

mssql script
MSSQL Script
If you follow the link to this document, you can learn about how to execute an MSSQL script on your computer to be able to insert the SMS reports into a database. This solution is great if you enabled SQL text logging for high performance configurations, so you can use this script to execute the SQL queries and insert the reports into your database.
Learn about how you can use an MSSQL script to store SMS reports
mysql script
MySQL Script
The reports of the incoming and outgoing SMS messages can be stored in a single database. This operation can be executed with a MySQL script that you can find if you follow this link to the document. You can learn about how to save the script to your computer, what file extension you need to use, and how to execute the script using the Power Shell.
Check how you can execute MySQL script to store your SMS reports
task scheduler
Task Scheduler
Check the following page and see, how you can set up the Windows Task Scheduler to be able to execute a Power Shell script in a specified time period. This solution helps you to insert the newly generated SMS reports into your database which contains the reports of the incoming and outgoing SMS messages and keep this database up to date.
See how to set up Task Scheduler to run a Power Shell script.

More information