***Version 10 is EMV credit card processing only***
Part 1 (in MicroSale)
- Close the day
- Close the CC batch
- Close the week
Part 2 (Windows)
- Make a copy of the MicroSale directory
- Make sure SQL Server Instance is installed. If SQL is not installed, use the batch file to install SQL.
- Delete the following files:
- UpdateFilesAccess
- UpdatesFilesSQL
- UpdateFilesEnterprise
- All DLL files
- All OCX files
- Run setup file as an administrator for the Version 10 upgrade
- Setup MicroSale to use SQL connection, all terminals will use the file server/SQL Server for path settings
- When you save the connection, you will be asked to Create Databases for SQL, you will select Yes.
If there is an issue with CC printing, make sure you check the register option under Menu/Credit Cards for ‘CC slips print on demand’. You will want to uncheck. - If there is an issue with menu items appearing, make sure you reset your function/order screen buttons to default and then assign the buttons again in(Each Category).
- Product History is in SQL, so you will need to import the data from Access to SQL (We can assist you on this)
- If they are using Table Layout, you will want to move that to SQL as well. There is a utility in the table layout setup to move the database to SQL (Utilities > Import to SQL)
- If they are using Call In Orders, you will want to import the data from Access to SQL. (We can assist you on this)
(Part 3) How to import Data into SQL database:
- Open up SQL Server Management Studio
- Browse to the database you need to import data
- Right Click on the database and go to Tasks -> Import Data
- Follow steps of selecting data source and then data destination and then complete the task