Page Comparison

The prechecker checks and reports on the following conditions:

1. Server version
2. User local administration rights
3. User SQL admin rights
4. Sufficient backup space (if required)
   1. Check for agent based backup utilities
5. Test for tables with high number of records
6. Non synergetic databases on server
7. Server not part of an availability group
8. Server not using log shipping
9. Checks for agent based backups
10. Synergetic version number
11. Ability to rename databases
12. Check the user views will recompile
13. Test for custom API
14. Test for Middleware core URL configuration
15. Test SQL server service pack and cumulative updates

Server version

The minimum server version supported by Synergetic is Windows Server 2012 R2

User local administration rights

Changes are made to the file system.  Consequently, the currently logged on user must have local administration rights.

User SQL admin rights

Changes are made to the database. You can either log onto the database using windows authentication or SQL authentication. The user supplied requires SysAdmin rights on the server and all tables . 

Sufficient backup space

The migration process consumes significant hard space. The approximate space required is estimated and reported upon. 

Agent based backups may be disrupted during the migration process. If backup agents are used, a warning is issued.

Test for tables with high number of records

Non synergetic databases on server

Server not part of an availability group

Server not using log shipping

Checks for agent based backups

Synergetic version number

Ability to rename databases

Check the user views will recompile

Test for custom API

Test for Middleware core URL configuration

Test SQL server service pack and cumulative updates