Replacing the edfi Schema in Source Code

Some implementations of the Ed-Fi technology may have changed the default database schema from edfi  to a custom value. In keeping with the majority of implementations, the Analytics Middle Tier assumes that all Ed-Fi ODS database tables are in the edfi  schema, with no built-in mechanism for changing to a different schema. However, anyone interested in installing the Analytics Middle Tier over their customized database can do so by following these steps:

1. Fork the source code repository in GitHub (https://github.com/Ed-Fi-Alliance/Ed-Fi-Analytics-Middle-Tier).
2. Clone the fork onto a developer computer.

3. Place the following script in the root repository directory:

   

4. Execute the script against the desired release tag (for example, "2.0.0" for the AMT 2.0.0 release), commit all changes in a new branch, and push back to GitHub*.

   Execute in PowerShell

   git checkout 2.0.0
   git checkout -b master-mystate
   .\amt-change-source-schema.ps1 "mystateschemaname"
   git commit -am "Replace edfi schema"
   git push master-mystate

   * Strictly speaking you do not need to commit changes and push to GitHub. This instructions adheres to the standard advice of always backing up your work.

5. Now you can compile the application and run it pointing to your custom database.

   cd src/
   
   # Compile an executable for use on a Windows 10 or Windows Server 2016+ machine:
   dotnet publish -c Release -r win10-x64
   
   # Output is in src\EdFi.AnalyticsMiddleTier.Tests\bin\Release\netcoreapp3.1\win10-x64\publish\