I depends on the SMS/e-mail traffic. An MS SQL database performs much better than MS Access, especially when the database is large (i.e. 50.000 messages or more). With low/medium databases (up to 50.000 messages) an MS Access database will suffice.
SMS Messaging Server > Message Database
Q8380012: Can I migrate the report database to MS SQL Server Express Edition? If so, how can it be done?
Yes, MS SQL Express Edition is supported.
Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field.
For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'.
There's no performance difference between MS SQL Server and MS SQL Ser...
SMS Messaging Server > Message Database
Q8380015: The performance of the Message Database is too slow, especially the triggers, and I want to migrate the Message Database, preferably MS SQL Server Express Edition. Is there any performance difference between MS SQL Server and MS SQL Server Express Edition?
No, there's no performance difference between MS SQL Server and MS SQL Server Express Edition. It is strongly recommended to migrate your Message Database to either MS SQL Server or MS SQL Server Express Edition to boost the performance of the Message Database.
SMS Messaging Server > Message Database
Q8380020: Is it possible to define a failover message database, in case the (primary) message database stops working?
It is not a built-in feature of SMS Messaging Server. You should use ActiveXperts Network Monitor to monitor the SMS Messaging Server message database, and to failover to a secondary message database in case the primary message database fails.
Click here for more information about this topic.
SMS Messaging Server > Message Database
Q8380030: Is it possible to use a SQL 'INSERT' statement to create a new SMS message? What values shoud I use?
Yes you can. Please read the following article for more information: Create a new SMS or e-mail Message directly without using the API.
SMS Messaging Server > Message Database
Q8380040: Can I use an MS SQL 'Stored Procedure' to send an SMS message?
Yes you can. Please read the following article for more information: Create a new SMS or e-mail Message directly without using the API.
SMS Messaging Server > Message Database
Q8380050: Can I migrate the Message Database to MS SQL Server Express Edition? If so, how can it be done?
Yes, MS SQL Express Edition is supported.
Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field.
For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'.
There's no performance difference between MS SQL Server and MS SQL Ser...
SMS Messaging Server > Message Database
Q8380100: I just migrated the Message Database to MySQL and now some characters are displayed as '???'. What to do ?
The SMS Messaging Server stores all message data to the database as Unicode. Please check the following:
The default charset of the tables have to be set to 'ucs2';
You have to use the MyODBC driver version 5.1 on the client PC. Older versions do not support Unicode.
SMS Messaging Server > Message Database
Q8380110: How can I convert the values of the fields "ScheduledTimeSecs", "SentTimeSecs" and "ReceivedTimeSecs" in the Message Database to a displayable format ?
Time values are stored in the database as seconds since 1-1-1970, also called Epoch time. To convert this value to a readable format, you can use the following VB code:
Public Function UnixTimeToDate(ByVal Timestamp As Long) As Date
Dim intDays As Integer, intHours As Integer, intMins As Integer, intSecs As Integer
intDays = Timestamp / 86400
intHours = (Timestamp Mod 86400) / 3600
intMins = (Timestamp Mod 3600) / 60
intSecs = Timestamp Mod 60
UnixTimeToDate ...
SMS Messaging Server > Message Database
| Error codes |
|---|
| Click here to view the full list of error codes |