Converting the Amicus Small Firm Edition Database

Converting the Amicus Small Firm Edition Database

Creating a Hyper-V Virtual Machine

  1. Open Hyper-V Manager

    1. First, open Hyper-V Manager by clicking the "start" button and typing "hyper", then select Hyper-V Manager from the list. 

  2. Under the name of your PC on the right side, select: New > Virtual Machine


Virtual Machine Wizard

  1. Specify Name and Location: Give your virtual machine a name. Leave other fields as default. Click Next. 
  2. Specify Generation: Select "Generation 2". Click Next.
  3. Assign Memory: Enter "4096" into the startup memory test field. Click Next.
  4. Configure Network: In the Connection drop down, select "External Network". Click Next.
  5. Connect Virtual Hard Disk: Leave all fields as default. Click Next.
  6. Installation Options: Select "Install an operating system later". Click Next. 
  7. Summary: Confirm what you have set. Click Finish. Virtual Machine is created. 

Required Downloads

  1. This setup process will require a few different files. Download the required files to your local computer from here. These downloads include:
    • Amicus Installer.zip
    • Amicus - Rebuild Index.zip
    • SQL Server 2005 Compatibility Features.zip
    • SQL Server 2014.iso
    • Windows Server 2022.iso

Customize Virtual Machine Further

  1. Right click on your virtual machine and select "Settings"
  2. SCSI Controller: In SCSI Controller settings, select "DVD Drive". Click Add. 
  3. Integration Services: In Integration Services settings, check "Guest Services". Click Apply. 
  4. Security: In Security settings, check "Enable Trusted Platform Module". Leave all other fields as default. Click OK.
  5. Re-open Virtual Machine Settings
  6. Firmware: In Firmware settings, set Boot order to the following: DVD Drive, Hard Drive, Network Adapter. Click Apply.
  7. DVD Drive: In DVD Drive settings, select "Image file", click Browse. Select the Windows Server 2022.iso file from your local computer. Click OK.
  8. Start Virtual Machine: Double click on your Virtual Machine. Click Start.
    1. Upon clicking "Start" you will need to quickly press the "Enter" key when the next screen flashes in order for the Virtual Machine to start properly.


Microsoft Server Operating System Setup

  1. Microsoft Server Operating System Setup: Select your desired language, time and currency format, and keyboard. Click Next.


  2. Click Install Now.


  3. In the operating system options, select "Windows Server 2022 Standard (Desktop Experience)". Click Next.


  4. Accept License Terms. Click Next. 


  5. Select "Custom: Install Microsoft Server Operating System Only (advanced).


  6. Select your drive. Click Next.


  7. Finish Installation.


  8. Customize Settings: Give your Virtual Machine a user password. Click Finish.


  9. Enter your password.

Server Manager

  1. Upon logging in, Server Manager will load. On the Server Manager screen, click No on the Networks message.


  2. On the Server Manager Dashboard, click "Add roles and features".


  3. In the Add Roles and Features Wizard, check "Skip this page by default" and click Next.


  4. Installation Type: Select "Role-based or feature-based installation". Click Next.


  5. Server Selection: Select "Select a server from the server pool". Confirm that it is your server in the Server Pool. Click Next.

  6. Server Roles: Check "Web Server (IIS)".


    1. Click Add Features


    2. Check .NET Framework 3.5 Features. Check .NET Framework 4.8 Features and everything under .NET Framework 4.8 Features. Click Next.


  7.  Confirmation: Confirm the roles, role services or features you are installing. Click Install.


  8. Results: Installation Successful. Click Close.


Install SQL Server 2014

  1. To perform this and future
     
  2. In your Virtual Machine, navigate to: Media > DVD Drive > Insert Disk...


  3. Select your SQL Server 2014.iso file. Click Open.


  4. Navigate to your Virtual Machine's DVD Drive and run the "setup" Application.


  5. In the SQL Server Installation Center, navigate to Installation and select "New SQL Server stand-alone installation or add features to an existing installation".

SQL Server 2014 Setup

  1. Product Key: Confirm Product Key. Click Next.


  2. License Terms: Accept license terms. Click Next until you get to Install Rules. 


  3. Install Rules. Confirm the operation has completed. Click Next.


  4. Setup Role: Select "SQL Server Feature Installation". Click Next.


  5. Feature Selection: Select all features EXCEPT:
    • Analysis Services
    • Reporting Services - Native
    • Reporting Services - SharePoint
    • Reporting Services Add-in for SharePoint Products
    • Documentation Components
    • Distributed Replay Controller
    • Distributed Replay Client



  6. Instance Configuration: Select Default instance. Click Next.


  7. Server Configuration: Click Next.


  8. Database Engine Configuration: In Server Configuration tab, select Mixed Mode. Enter a password for your SQL Server system administrator account. Click "Add Current User" and wait for your user to show up in the administrators box. Once your user appears in the administrators box, Click "Add...".


    1. In the "Select Users or Groups" screen, type "administrators" in the names box. Click OK.


  9. Database Engine Configuration: Confirm your screen looks like the below image. Click Next.


  10. Ready to install: Confirm your choices. Click Install.


  11. Install Complete: After a few minutes, your SQL Server 2014 Install is complete. Click Close.


  12. In your virtual machine settings, navigate to "Services"


  13. In your list of Services, find "SQL Server (MSSQLSERVER)". Right Click > Properties.


    1. In the "Log On" tab, select "Local System account". Click Apply. 


    2. Restart the service. Select "SQL Server (MSSQLSERVER)" and click Restart.

Install SQL Server 2005 Compatibility Features

  1. Copy the SQL Server 2005 Compatibility Features.zip file from your local computer, to your virtual machine. 

  2. Navigate to your compatibility features installer package and run the "SQLServer2005_BC_x64" installer. Make sure you select the 64bit version.


  3. Install Wizard: Click Next.


  4. License Agreement: Accept the terms in the license agreement. Click Next.


  5. Ready to Install: Click Install.


  6. Installation Complete: Click Finish.


Install SQL Server Management Studio (SSMS)

  1. Click here to download and Install SSMS from Microsoft to your Virtual Machine.


  2. Run the SSMS .exe File. Click Install.


  3. Restart Virtual Machine. The SSMS Install will require your virtual machine to restart in order to complete setup. Click Restart.


  4. SSMS Install Complete.

Install Amicus

  1. Copy the Amicus Installer.zip file from your local computer, to your virtual machine.

  2. Extract Amicus Installer: In your virtual machine, extract Amicus Installer to your Virtual Machine's C:\. Click Extract. 

    1. Note that in the below image Amicus Installer is extracted directly to the virtual machine's C:\


  3. In your extracted Amicus Installer folder, run the "Setup" Application.


  4. Start Amicus and Click Next. Click Next until you get to the screen requesting a SQL server name.


  5. SQL Server Name and Password: Enter your SQL Server Name: (local) and the same password you set in "Install SQL Server 2014" step 8. Click Next.


  6. Enter the firm information and administrator information. Click Next.


  7. Confirm Installation. Click Next. 


  8. Installation complete. Click Finish.

Modify ODBC Settings

  1. Search "ODBC" in your Virtual Machine Settings. Select "ODBC Data Sources (32-bit)".


  2. Navigate to the "System DSN" tab. Click "Configure..."


  3. Type "(local)" into the server text field. Click Next.


  4. Select "With Windows NT Authentication using the network login ID. Uncheck "Connect to SQL Server to obtain default settings for the additional configuration options". Click Next. 


  5. Finish DSN Configuration: Click Finish. 


  6. ODBC Microsoft SQL Server Setup: Click "Test Data Source..."


  7. Test Successful: Verify that your test is successfull. Click OK.


  8. Modify ODBC Settings Complete. Close out of ODBC Settings. You are now ready to convert a firm's data.

Convert a Firm's Data

  1. To convert a firm's data, you will need a copy of the firm's Amicus Small Firm Edition Install Folder. Not just the database. The entire install folder from Amicus. This folder must be copied into the virtual machine. The folder should look similar to the image below:


  2. Copy the Amicus - Rebuild Index.zip from your local computer to your virtual machine.

  3. Extract the Amicus - Rebuild Index.zip to the "database" folder in your Amicus Small Firm Database.


  4. If prompted, replace all files in destination. Click "Yes to All". 


  5. In the "database" folder, Run "RBLDINDX".


  6. Running the RBLDINDX window will look like the below image. Let the RBLDINDX window complete.


  7. Rebuild Complete. Press any key to continue.


  8. In your virtual machine, find and run Amicus Small Firm Converter.


  9. Database Converter - Settings: Click Browse. Select the location on your VM where you copied the firm's Amicus Small Firm Installer Folder. Click Next.


  10. Throughout this process the application will appear to freeze and you will get a (Not Responding) message, this is expected. This process will be slow. You will get a "Successfully restored" message. Click OK.


  11. Database Converter - Users Mapping: Nothing needs to be done on this screen. Click Next.


  12. Database Converter - Confirmation: Click Finish.


  13. Your Conversion will start. This process will be slow and the screen will occasionally say (Not Responding), that is expected. 


  14. Conversion Complete: This process will complete and you will arrive at a "conversion complete" message. Click OK.


  15. Open SSMS in your virtual machine.


  16. You will now have an Amicus Database that you can use with Universal Migrator. 

    • Related Articles

    • Amicus Accounting: Database Conversions

      Because Amicus Accounting uses the FoxPro database engine, it must be converted before you can use it. When you receive an Amicus Accounting backup, it will be a ZIP file with content like this: You should extract the ZIP file and then locate the ...

    • Amicus Cloud Extractions: Read Me First

      When backing up data from Amicus Cloud there are a few things you should be aware of. Data is Deduplicated and Merged In the Amicus Cloud database, the contacts are stored multiple times. An algorithm is used to detect duplicate items and merge them ...

    • Amicus Migrations: Preparing Matters for Export

      To prepare your Amicus matters for backup, you should ensure that each matter has an associated "primary client". The following query will indicate what matters in your firm do not have associated clients: SELECT * FROM [File] WHERE 1=1 AND ID != 0 ...

    • Amicus Migrations: Preparing Users for Export

      To prepare your Amicus users for backup, you should ensure that each user has a correctly associated email address. The following query will indicate the email address for each user in your firm. SELECT Name, Initials, DefaultEmail FROM People WHERE ...

    • Prevail Backups: Database Conversions

      Converting the Database Prevail uses an object-oriented database named Postgres. Recover your username and password to Postgres Refer to the Training: POSTGRES - Recovering username/pw article for instructions on preparing your database for ...