How to Migrate Premier - SQL Server to SQL Server

Note: The following assumes you are moving the Sage Fixed Asset Premier Server program to a new server and either remaining on the same version or moving to a higher version. Company Backup files (.BBK) from 2013.0 can be restored into the latest version of the program.

Step 1: Back up data in original version

1. In the original Sage Fixed Assets Premier Depreciation program, backup the database (Do this once for each database).
   1. Go to: File, Company Utilities, Backup Company.
   2. Select a database from the pull down menu, click Select All.
   3. Select location to save the backup file: Specify a name for the backup file in the file name field (Suggest to use the name of the database).
   4. Click Backup.

Step 2: Install the Sage Fixed Assets Premier server components to the new app server, or redirect existing components:

1. Prior to setting up the new database(s), to redirect an existing Premier Server or Premier Depreciation to a new SQL server:
   • Go to REGEDIT, Hkey_local_machine\Software\WOW6432node(for 64-bit systems)\Best Software\MSBESTSYS, change Enginename value to new SQL server.
2. Setup empty System and Asset databases, go to: Start, Programs, Sage Fixed Assets, Tools, Database Utility Premier Depreciation & Tracking, log in to the SQL server using SA or SQL Administrator equivalent user.
   • Click Add and enter:
     1. Logical Database Name: the User Friendly Name you assign
     2. Data Source Name: N/A - Leave this as default – WINFAS32
     3. Engine Name: N/A - Should be populated with the MS SQL Server name
     4. Physical Database Name: The name of the database as you want it to exist on the MS SQL Server Machine. Click Next
     5. If required: Enter the path where you want to save the database. Click Next.
     6. Verify all the information. Click Finish.

Step 3: Install Clients on the Workstations

• The client install is not directly in the downloaded installation files. The client installation files are stored on the server when the server portion is installed. Browse to the server's BESTSERV, FASSERV or SFASERV\Premier Setup folder, run the Setup.exe file.
• Or redirect existing clients by going to registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node(for 64-bit systems)\Best Software\MSBestsys, Change the Enginename to the name of the new SQL server.

Step 4: Restore Data

1. Go to: File, Company Utilities, Restore Company, click Yes.
2. Browse to the location of the backup file (the .bbk files created in Step 1), highlight the backup file, click Next.
3. Highlight the company(s) to restore (Click the Select All button or hold the key down while selecting multiple but not all companies), click Next.
4. Highlight the database (new database should appear on this list) to restore the company(s) to, click Next.
5. Restore - Purge History option:
   • If Purge All Depreciation Events is selected, the Restore process will run much more quickly and should not go Not Responding.
   • If Do not Purge or Purge Depreciation Events Prior to: is selected, it can take up to an hour or more depending on the number of assets and amount of historical information per asset. During the process, Sage Fixed Assets may say Not Responding. To keep the Historical information on the asset, please wait for the process to complete.
     
     WARNING: Do NOT interfere with process. Ending the task present a high risk of corrupting the database.
6. Click Restore.