append 3 months data (part 14) 911 firstwatch

Question

Step 1

backup previous data from SQL server to local file geodatabase

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 2

append 3 month new data from local file geodatabase to remote SQL server historical data.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 3

Make sure new 3 months data added to historical data, you can see the total record increased by 8k.

 

 

 

 

 

 

 

Step 4

Verify the dashboard app working properly.

select unit code MS312, which is went live on Feb 1, 2024.