How do I send a MySQL database to AYS?
You must first export (or dump) the MySQL database from the database server before it can be sent to AYS. Here are two options for creating that file to send to us.
sql
Error -2147217900 [SQL Server]CREATE TABLE permission denied
When updating At Your Service – Repair Centre to the latest version, you may come across the above error. This article will help you resolve the issue and upgrade your SQL Server database to the latest version.
How to Configure MySQL for AYS
Specific MySQL server permissions are necessary for AYS users to access the data and run reports. Some additional permissions may be necessary for those that administer the AYS database on the server. This article will assist you in configuring the security on MySQL for both of these cases.
Which MySQL versions are supported?
At Your Service – Repair Center works with the following MySQL versions:
Which Microsoft SQL Server versions are supported?
At Your Service – Repair Center works with the following Microsoft SQL Server and SQL Server Express versions:
What happened to the Retail SQL edition?
The Retail SQL edition was renamed as the Retail Enterprise edition in June 2014 in preparation for the release of AYS version 4.0.
What happened to the Repair SQL edition?
The Repair SQL edition was renamed as the Repair Enterprise edition in June 2014 in preparation for the release of AYS version 4.0.
What is the maximum number of records that can be entered?
While the physical databases are capable of storing millions of records, the practical maximum number of records that can be entered in the various database tables depends much on the type of database, the number of simultaneous users, and the physical server hardware.
Experience has shown that Microsoft Access databases with 5 to 10 users experience a gradual slowdown as more records are added with the practical limit being in the range of 50,000 to 100,000 records per table. Microsoft Access databases also have a physical file size limit of 2 Gigabytes.
SQL databases are much more robust and still perform responsively with millions of records.
MySQL System Requirements
Here are the requirements for setting up an At Your Service installation to connect to MySQL Server.