As a first step, we would advise that you review the pertinent documentation located on our How To page located at the URL below:
We have help documents that can be accessed on this page ranging from GIFTS 6.4 to our latest version and GIFTS Alta 1.6.1 to our latest version.
After completing your SQL migration, you must then ensure that the ODBC is set up properly on all GIFTS/GIFTS Alta workstations to point to the new database server.
In the System DSN tab, highlight GIFTS (or whichever DSN denotes your GIFTS SQL database) > Click 'Configure' button
If the Server name or IP has changed, update the Server: entry and continue with the ODBC connection
The final step would be to ensure that the users' GIFTS.INI file is pointing correctly to the GIFTS SQL database using the ODBC connect string within the file.
Example: In creating my new ODBC connection, I've created a new entry in System DSN tab called 'giftsnew' and I have created a new container for my GIFTS SQL database on the new server I am migrating to called 'SQLGIFTS'. Because I have done this, I must update the ODBC Connect string in my GIFTS INI to read as follows:
Once all of these pieces have been considered and any suggested changes made, you may then have your users launch GIFTS/GIFTS Alta to confirm that they are hitting the GIFTS SQL database on the new server.