Need to 'version' updates to a specific row in a MSSQL server
We very recently just completed a move to a brand new system for our company (ConnectWise) and it includes a KB style documentation feature but does not have any version control. I'd like to take advantage of using the piece built in to the software but need a way to keep older versions of the articles.
The articles are stored as rows in a specific SQL table, and I can't rewrite the internal code. I'm trying to avoid a SQL trigger, but it might be the only way to accomplish what I want, which would be before an insert or update to duplicate the row to another table with a version # and date.
Is there another way to handle this that you [Experts] can think of? If not, how could I do the trigger to duplicate the row before it's updated without interrupting the software's process?
Appreciate the advice/brain storming in advance.
The articles are stored as rows in a specific SQL table, and I can't rewrite the internal code. I'm trying to avoid a SQL trigger, but it might be the only way to accomplish what I want, which would be before an insert or update to duplicate the row to another table with a version # and date.
Is there another way to handle this that you [Experts] can think of? If not, how could I do the trigger to duplicate the row before it's updated without interrupting the software's process?
Appreciate the advice/brain storming in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER