Print Audit 5 - How to Move from Access to SQL

Print Audit 5 -How to Move from an AccessDatabase to a SQL DatabaseOverviewThis document includes the steps to reinstall Print Audit 5 to use a SQL databaseinstead of an existing Access database.Basic Steps1. Install SQL or create a new instance on an existing SQL installation.2. Export the necessary data from the Access database.3. Install Print Audit 5 with SQL selected for the database type and create a newdatabase.4. Configure Print Audit 5 and import the data exported from the Access database.5. Reconfigure the Client workstations to point to the SQL server (if SQL is on adifferent server than the original Access server).Step #1 - Install SQL or create a new instance on an existing SQLinstallationFollow the instructions in the link below to install SQL Server 2005 Express for PrintAudit 5 or create new instance on an existing SQL installation. The instructions includethe steps to install Print Audit 5, do not complete the installation until Step #3 below.Print Audit 5 SQL Server 2005 Express Installation GuideStep #2 - Export the necessary data from the Access database1. Open the Print Audit Administrator and go the Client Custom Fields tab. If thereare custom fields present, click on the Name field for one of them and then clickthe Export button in the icon bar and select the location to save the exportedinformation. You will have to do this for each custom field and save them each intheir own file.2. Go to the Users tab of the Print Audit ...