Marty Metras wrote:
> Josh,
>
> What I am doing now is exporting a block of data I
> might need as a flat text file from MySQL and
> importing it in to Oracle and then processing it
> to getthe few records I need.
> I am doing this with SQL Shell scripts using ssh
> and ftp. It works but the block of data I need
> keeps getting larger.
>
> Maybe with come creative scripting I can shorting
> the block of data.
>
If the original data does not delete records, then you could have a timestamp column, call it "updation" perhaps, and then you can just export/import the records that have changed recently. Sometimes an alternative to deleting rows is to mark them as inactive or deleted with a column. I don't know how dynamic your table is as this model does not fit in many cases.
Also, consider on the MySQL side of things that when you import the data, you might import it into a temporary staging table first, and then rename the table to the location you want while moving the current table away, and this would be less disruptive to your applications.
Regards,
Josh
> Thanks for your input Josh.
> Marty
Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL!
http://www.mysql.com/consulting