jonathan.crawford - Thursday, September 20, 2018 10:56 AM

I did this recently when I needed to fix a naming convention, maybe something like this would work for v+1(very simplistic):

1. copy records in oldTable into newTable (with correct naming convention), both objects still existing (v+1).
2. create view with same name as oldTable
3. Drop oldTable (except we'd skip this step in the software version v+1)
4. refactor code to point to newTable, where it references oldTable (which is really now a view)
5. Once done, drop oldTable view. (this would happen in v+2)