I am a programmer changing the way a process works, and will be using a different table to do this. The process is just sending emails from a web application. Currently the database scripts run during a batch each night and create entries in a table that contain the subject, and the entire body of the email. I am moving to a process where only the variable elements will be held in the table.
I am just wondering what the accepted, or most common strategy is for doing this. I've spoken to a few of our database people and they suggested to create an entirely new table and use this going forward.
I am fine with doing it this way, and was wondering if it's a good idea to alter the current table's name, to something like
EmailTableOld and create my new table with the original name
EmailTable so I don't have to create additional permission scripts and set up new synonyms while removing the old ones.
Is this a good idea? I have identified everything that refers to the table and there are only a few things mostly security granting scripts, and the scripts that actually create email content. The table does not reference or is referenced by any other tables currently. The entire contents of the old table must be kept.
Any suggestions etc are welcome