fiscal calendar change - customer wants to move posted transactions to a different period in the tables

Is there a good way to change all posted transactions from one period to another?  A customer is wanting to change their fiscal calendar and move the last 6 months worth of data to a different period.  I told them they would have to do journal entries but they want us to change it in the sql tables.  I told them it wasn't possible, but I thought I would double check.  I am not changing the data in sql, but is there a slick way to do it through sage 300?