IPTD-461
SimpliGov - SQL DB Creation for Data Transfer from MS Access
Description
A workflow developed in SimpliGov to help gather information for and track SQL DB creation for use with an Access front end. Which will eventually be moved to DMU control.
Problem Statement
Users currently ask for SQL databases to be created through the helpdesk and forget some information.
Project Justification
To collect all information needed about the creation of an SQL database to have data transferred to it from an Access database more efficiently and accurately. Also this will serve as a road map for future users to create configure the SQL DB that is needed.
Estimated Transactions
dozens to hundreds
Target Rollout Date
6 September 2024
Target Rollout Date Reason
System is small and ready for use and can be rolled out quickly.
Activity
Show:
Product can be found here: https://intranet.dep.state.nj.us/depnet/doit/data-migration/
Direct Link: https://njdep.prod.simpligov.com/prod/portal/ShowWorkFlow/ShowWorkflowDetail/26fe0b22-ea53-4e1e-8743-31041cc7db2d