**SQL Project - Phase 1** (2,3 to come later)
- Create 4 database tables (hvdn, hvector, hagent, hsplit) in MS SQL (We are using MS SQL 2000 and it is already established)
-? Setup? daily database retrival of the data from the previous day? from CMS Informix database (ODBC link already created)
- Create automatic retention policy of 26 for months (delete * = date + 26 months)
- Currently, I have an MS Access database that I use to perform this task manually.? This database (under 1gig) would need to be imported into the new MS SQL implementation
- Provide basic reporting to query database table
Database item tables
Found in [[login to view URL]][1]
hsplit - Page 75
hvector - Page 170
hagent - Page 115
hvdn - Page 182