I am a software developer and I am working on a large project.

For our unit tests we have an SQL-file with lots of insert statements for our test database (In-Memory HSQL Database). Often I am facing the challenge that a few tables change, columns are removed or added and I have to apply those changes to our statements. I can't just copy the content of our real database, because the data have to stay the same. Also it's always a hassle because the syntax for the query is slightly different.

Right now I am working mostly with RegEx in Notepad++ and Excel to be able to insert new columns with data into the statements, but it's always a time consuming task. Depending on the table that I have to edit, sometimes there are several hundred statements for one table, and some table have several dozen columns.

Is there some kind of tool that would simplify this task?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.