Back up data in original version

• In the original Sage Fixed Assets Premier Depreciation program, back up the database. Do this once for each database.
  • Go to File Company Utilities, Backup Company.
  • Select a database from the pull-down menu. Click Select All.
  • Select location to save the backup file: Specify a name for the backup file in the file name field. Sage suggests using the name of the database.
  • Click Backup.

Install the Sage Fixed Assets Premier server components to the new app server

1. Redirect Premier Server or Premier Depreciation first. Then set up the new databases on the SQL server.
2. Go to REGEDIT, Hkey_local_machine\Software\WOW6432node\Best Software\MSBESTSYS, change Enginename value to new SQL server.
3. 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:
     • Logical Database Name: the User-Friendly Name you assign.
     • Data Source Name: N/A - Leave this as default - WINFAS32. 
     • Engine Name: N/A -  Populates with the MS SQL Server name.
     • Physical Database Name: The name of the database as you want it to exist on the MS SQL Server Machine. Click Next.
     • If required: Enter the path where you want to save the database. Click Next.
     • Verify all the information. Click Finish.

Install Clients on the Workstations

• The client install isn’t directly in the downloaded installation files. The server that you installed the server program on stores the client installation files. Browse to the server's BESTSERV, FASSERV or SFASERV\Premier Setup folder, run the Setup.exe file.
•  Or go to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Best Software\MSBestsys and change Enginename to the new SQL server.

Restore Data

1. Go to: File, Company Utilities, Restore Company, click Yes.
2. Browse to the location of the backup file (.bbk files created in Step 1). Highlight the backup file, click Next.
3. Highlight the companies 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 (a new database will appear on this list) to restore the companies to, click Next.
5. Restore - Purge History option:
   • Select Purge All Depreciation Events, the Restore process will run faster and won't go Not Responding.
   • If you select Do not Purge or Purge Depreciation Events Prior to: it takes an hour or more. Time depends on asset count and historical data amount for each asset. During the process, Sage Fixed Assets will say Not Responding. To keep the Historical information on the asset, wait for the process to complete.
      CAUTION: Do NOT interfere with this process. Ending the task presents a high risk of corrupting the database. 
6. Click Restore.

 NOTE: The internal backup and restore don’t back up or restore the information contained in bestsys. You’ll need to set up Password Security, Global Task Manager batches, Registration and Attachment path again on the new server. 

[BCB:165:Chat Fixed Assets US:ECB]