Legacy FoxPro, AdvantageDB, and Clipper Database Conversions to SQL Server

Custom software and database solutions start here

Thorough software design: A necessity for project success

Code Authority Custom Software on Microsoft platforms since 2001

May 18, 2012 Login

Legacy Fox Pro, AdvantageDB, and Clipper Database Conversions to SQL Server

Customer: Securus Technologies
Web Site: t-netix.com
Customer Size: 500+ employees
Location: Addison, TX
Industry: Law Enforcement

Customer Profile:

Securus provides law enforcement systems and technologies, focusing
on incarceration and police solutions, and jail telephony.

Software and Services:

ASP.NET
WSH
SQL Server
ActiveX
TSQL Automation

The Challenge

Local correctional facility systems provider and integrator Securus Technologies contracted with us to develop repeatable and automated migrations of their legacy jail management systems to their new product Facility Manager™.

The client needed reliable conversions from datasources such as Clipper and FoxPro to be used during a go-live installation launch.

The Solution

Have you ever tried to extract images from clipper database files and convert them to JPGs? We hope you have not because we had to write some serious low level C++ extraction tools.

That and a lot of testing and a collection of WSH automated TSQL Scripts.

The Benefits

We used our tools and migration process management skills to help the client convert and launch over 25 customers on its new platform.