SQL to HPCC

[Helen]

My data is quickly out growing its current SQL based implementation (SQL Server / MySQL / Oracle etc). Is there any facilitation available to migrate to HPCC?

[robert.foreman@lexisnexis.com]

Hi Helen,

In the HPCC, you have the option to input data in one of three ways:

Fixed Length
Variable length (known as CSV)
XML

So the first step would be to export your SQL data into one of the supported formats. I think that most platforms support the CSV format, so that would be my first choice. After that, you simply copy the exported data to the Landing Zone and then spray from there. The Data Tutorial PDF has more information regarding this process.

Hope this helps!

Regards,

Bob Foreman
LexisNexis

[SkipSnow]

Bob:

I think the question has more to do with migrating the data definitions, and querries etc that support the data than how do you simply move the data.

If so, It is interesting to note that the earliest versions of HPCC did support at least a subset of SQL, and wonder if any of that old code could be 'awoken' and given to the community?