I am in this situation: I have to split a JEDI VCS server. I have 4 Delphi projects on it, and I have to give 2 projects to a company and 2 to the other company.
The idea is: I restore 2 JEDI VCS backups (2 database backups) and I remove the projects of the other customer. Now it is not possible to really remove a project from JEDI because of referencial integrity as described in this article in JEDI VCS FAQ.
So since deleting is not possible I had the idea of writing NULL in the blob fields where the source files are kept. In this way if customer 1 tries to restore customer 2 projects he will simply get the file list and then probably an error on reading the files. If I can set NULL to the tables the dpr dfm pas files will not be really there in the db anymore.
Is this possible?
Did someone wrote a query that does this?
Server version is V 2.4.1.790