Data/File/Table Conversion by the job
Posted in 1997
Topics: Server Administration
________________Data/File/Table Conversion done by the job_______________________ Do you have thousands of same format records that need to be modified? Have you moved to a new database schema? What I do: I convert and massage your electronically stored, formatted data to fit your new specifications. I build SQL import files out of data from an old table that will insert the data into a new table structure. Who am I: I'm a professional programmer/data converter with expertise in modifying large amounts of data on UNIX and IBM machines. I work with MSSQL, INFORMIX, ORACLE, DBASE, and SYBASE databases. Sample: OLD_TABLE >>> NEW_TABLE Name(char): "Joe Bloe" First_name(char): "Joe" Age(char): "37" Last_name(char): "Bloe" SSN(char):"123-45-6789" Age(int): 37 SSN(char): "123456789" How much: $50 for modifying single format file. $80 for building importable file with new database table schema. Prices good through 2/15/97. Most single conversions done in a week or less -depends on current demand. Info needed: -Old schema (table structure or line format of file) -New schema (table structure or line format of file) -Field transfer map (OLD_COLUMN -> NEW_COLUMN) -Notes on special manipulations to fields (remove all '-', break up string, add two columns, etc) -Database type (MSSQL, INFORMIX, ORACLE, DBASE, or SYBASE) -Data in electronic form (3.5 disk, CD, Zip), IBM format. Please, DO NOT E-MAIL ME YOUR DATA. Free E-mail me about the job: how many tables or files, consultation: size of schema, special manipulations, database type, and anything else of relevance. Disclaimer: I guarantee jobs I have accepted. Data must be structured and follow pattern. Customer is responsible for giving non-corrupt files with clean data (all rows following same pattern).