Can someone tell me how to rename all DEV tables and it's indexes to LIVE nomenclature? Ex: ProductsDev to ProductsLive and all indexes renamed to Live extension as well.

Here...

Could you please post an example of your Bulk Insert statement? Also did you have any clustered indexes?

Thanks.