demarc

Maintenance and Support - PostGre SQL


PostGre SQL is an open source client/server database used commonly on Unix/Linux platforms.  One of our recent taskings is to migrate an application written originally in QuickBasic (more precisely, Microsoft Professional Development System 7.1) to PostGreSQL and Java.  One role in this process is to 'reverse engineer' the original data files and import them to PostGre.  In the process of doing this, we have integrated PostGre SQL with the .NET platform using NPGSQL.  While the initial data import is through generated SQL statements, PGSQL 'functions' (what would be known as Stored Procedures in SQL Server or MySQL) have been written to migrate imported data into the target schema.  This involves, for example, normalizing repeating data structures, splitting 'LastName,FirstName' into their respective fields, combining multiple line description blocks into single memo fields, and so forth.  The target schema has about 60 tables, with the larger record counts in the 10,000 to 100,000 record range, depending on table.