demarc

Maintenance and Support - Sybase SQLAnywhere


Sybase SQLAnywhere is often used when a single organization is hosting databases on a wide collection of different platforms at various scales.  We use the SQLAnywhere 12.1 Developer Edition to code a data migration from an Electronic Health Recordkeeping system (EHR) to a Clinical Data Reporting service.  This particular implementation uses the .NET Data Provider for SQL Anywhere in conjunction with a C#/Winforms application.  This system queries rowsets from SQLAnywhere, transforms SQLAnywhere data types into their corresponding SQL Server data types where necessary, and writes the records to corresponding SQL Server tables.  Variations on this system query data in weekly intervals, determining which records have either been changed or added, and transmits the new or updated records to a centralized collection point.