Finishing Steps

Now that your system tables and data have been migrated to the SQL network database, you are ready to configure the remaining clients.

Refer to the Configuring TOXICALL® Client to Use SQL Server section for instructions. (Note that the correct SPI List should appear at Login this time.) After a client is updated, they are ready to access TOXICALL® normally again. They will see changes only in the System Tables and Configuration window, but not within the program itself.

After getting the SPI’s working, you can migrate any archives that will be using SQL.  Follow the same steps as above, except change your Location to the Access archive database from which you will migrate cases. In the Move/Copy window, instead of choosing the Network database, choose the new SQL archive that you created. If the site is going to combine all archives into one on the SQL Server, simply move the cases from each Access archive into the new single SQL archive.