Overview
Skills
Job Details
Background
The Agency desires to modernize its database infrastructure by moving to FileMaker Cloud. To do this, the Agency needs project staff to access its instance of FileMaker Server v13 and backup the database running on it, create a new instance of its database on the FileMaker Cloud platform, and then transfer a copy of its existing on-premise FileMaker database to FileMaker Cloud.
The Agency's existing on-premise database has approximately 7,300 records. Each record has the same forty-five (45) fields:
The database does not appear to have any container fields. The Agency already has a subscription to FileMaker Cloud.
Scope of Work
Recover Admin-Level Access to FileMaker Server
Project staff will gain administrative-level user access to the Agency's on-premise instance FileMaker Server v13 and create a new set of administrative-level access credentials for the Agency. Project staff will then create two local backups of the Agency's FileMaker database.
Recover administrative-level user access to FileMaker Server v13.
Create one (1) set of administrative-level user access credentials to FileMaker Server.
Create two (2) backups of the database running on FileMaker Server.
Phase 2: Create New Database in FileMaker Cloud Identical in Structure to Existing On-Premise Database
Project staff will create a new (unpopulated) database on the FileMaker Cloud platform that duplicates the structure (schema) of the Agency's existing on-premise FileMaker database.
Create new database on FileMaker Cloud duplicating the existing on-premise database structure and function.
Phase 3: Transfer a Copy of the On-Premise FileMaker Database to FileMaker Cloud
Project staff will upload a copy of the Agency's on-premise FileMaker database to the new FileMaker Cloud database created in Phase 2. Using the existing on-premise database as a reference, project staff will then verify that the new cloud database is accurately populated and fully functional.
Verify readiness of on-premise FileMaker database copy for upload to FileMaker Cloud
Remediate any pre-upload issues (if necessary)
Upload database copy to FileMaker Cloud
Verify cloud database functionality and accuracy by...
Ensuring all records have successfully uploaded
Ensuring all record data fields function properly
Selecting at least 350 nonsequential records and comparing them to the same record in the on-premise database to ensure all data fields have properly populated
Required Experience
Experience recovering FileMaker Server access, experience working with FileMaker Server and FileMaker Cloud, and experience transferring on-prem FileMaker databases to FileMaker Cloud.