So we found out after a major data corruption and a 30 day old backup (I know, I know...), that the standard CommitCRM Advantage Database can be easily worked on through the Advantage Data Architect program. I have used this software for other projects in the past and decided to give it a whirl to attempt to recover our data.
Long story short, the tickets database was corrupt, but no others. We were able to write a program to re-create, map, link and update almost every ticket from the lost 30 days based on the information in the other tables. All is well and we're back in business. With that said, the ability to quickly modify data and have SQL access to our data has spurred all kinds of creativity around here. Like this quick command we're using to re-map all document paths as we're moving to a new server:
SELECT REPLACE(DOCUMENT_NAME,'\\oldserver','\\newserver') from DOCS
My point here is that having access to the SQL data behind the scenes and the ability to MODIFY that data has been a huge help to our company, probably saved us thousands in lost revenue from the corruption. We're considering moving forward to the "SQL" version of Commit, but are wondering if we'll have the same access to our data.
Obviously this is for advanced users only, I would never recommend someone without extensive database/SQL admin experience even poke around their CommitCRM data. But with that said, for those of us with the experience, know-how and desire, do we have the option to access the SQL data in WRITE mode with the new SQL upgrade?
Long story short, the tickets database was corrupt, but no others. We were able to write a program to re-create, map, link and update almost every ticket from the lost 30 days based on the information in the other tables. All is well and we're back in business. With that said, the ability to quickly modify data and have SQL access to our data has spurred all kinds of creativity around here. Like this quick command we're using to re-map all document paths as we're moving to a new server:
SELECT REPLACE(DOCUMENT_NAME,'\\oldserver','\\newserver') from DOCS
My point here is that having access to the SQL data behind the scenes and the ability to MODIFY that data has been a huge help to our company, probably saved us thousands in lost revenue from the corruption. We're considering moving forward to the "SQL" version of Commit, but are wondering if we'll have the same access to our data.
Obviously this is for advanced users only, I would never recommend someone without extensive database/SQL admin experience even poke around their CommitCRM data. But with that said, for those of us with the experience, know-how and desire, do we have the option to access the SQL data in WRITE mode with the new SQL upgrade?
Comment