Moving AYS From One Server to Another

When you change or upgrade hardware you may wish to relocate the AYS application or data to another server. Depending on your edition and setup, you can follow one of the following procedures.

In all cases, you can identify the path and name of the database in the AYS title bar inside [square brackets] when the database is open.

For Access databases, the prefix is “AYS -“ as shown

AYS file type

For MS-SQL databases, the prefix is “SQL -“

MS SQL Server database type

And for MySQL databases, the prefix is “MYS -“

MySQL database type

You may wish to record this information for reference during the migration process.

Your existing server is may be sharing a database from a Windows file share. This is explained in this article.

You can simply copy or move the files with an .ays extension to a new shared folder on a new server.

See “Workstation changes” below for some other steps you may need to take.

You can create a backup file in SQL Server using your server maintenance tools and restore it on the new server.

Ensure that your user security is configured correctly for MS-SQL or MySQL database servers.

On one of your workstations, connect to the database on the new server and ensure that the information in the title bar as explained above is correct.

See “Workstation changes” below for some other steps you may need to take.

This section is coming soon

This section is coming soon

If your client workstations are configured to automatically open the database, you may need to disable this option until the new databases are configured.

To disable this option, click “Cancel” when prompted to log in to AYS and uncheck File – AutoOpen Database.

You can now log in to AYS and manually configure the new database location. If you wish, re-enable the option to AutoOpen the database, and the new database will open when the user logs in.

You should archive or delete your old database once you are sure it has been migrated successfully to avoid conflicts with users working out of separate databases.

AYS Versions: All
AYS Editions: All
Databases: All