Access to files for uncommitted changes

• 
  On XP, you'll find theme here:
  
  C:\Documents and Settings\<loginName>\Local Settings\Application Data\Red Gate\SQL Source Control 3\WorkingBases
  
  The WC folder names bear no relation to the project names but you can map them from here:
  
  C:\Documents and Settings\<loginName>\Local Settings\Application Data\Red Gate\SQL Source Control 3\LinkedDatabases.xml
  
  There may be a better approach than this.
  
  I have considered re-pointing the paths in LinkedDatabases.xml to a regular working copy and although that does work, I do not know what the impact would be if changes were made in that WC as well as the dev database itself.

  datacentricity June 07, 2013 03:40

  - 0 +
• 
  Thanks datacentricity.
  
  Something else I toyed with today is modifying CommandLineHooks.xml to convert the default changelist to a pending changelist for the commit command (instead of actually committing). I tried this with powershell for a quick test. This works but for some reason the powershell.exe process is not ending and I have to cancel the commit. But, before cancelling I can see in my Perforce client that the new changelist has been created with the correct files.
  
  I think this approach could work.
  
  <CommandLine>powershell -Command "p4 change -o | ForEach-Object { $_ -replace \"^<enter description here^>\", \"($Message)\" } | p4 change -i; exit"</CommandLine>

  joejf June 07, 2013 12:39

  - 0 +
• 
  Strange that the powershell isn't ending. Have you tried not using powershell and just plain old batch file commands?

  David Atkinson June 07, 2013 12:44

  - 0 +
• 
  I have not tried plain old batch commands. The best way to accomplish this is using the print output of the default change as the input of the new change and replace the description placeholder. Powershell was the quickest way to test this inline replace. But, I think this exercise did prove that it can be done with the CommandLineHooks.xml file. I may look into this more in the next few weeks.

  joejf June 07, 2013 12:55

  - 0 +
• 
  Hello.
  
  You can modify the CommandLineHooks.xml to do nothing in the commit. This will just save the files to your working folder. You'll need to add them to the changelist and commit using your own tool.
  
  You can also use the new link to "Working Folder" option. This option just scripts out the files and saves them to this folder from the commit tab. In SQL Source Control, the button on the commit tab is actually changed to say "Save." You would then use your own version control system's tool to add the files to the pending changelist and commit them.
  
  Strange that the powershell is not exiting.
  
  Cheers!
  Stephanie Herr
  SQL Source Control Product Manager

  StephanieHerr June 10, 2013 05:10

  - 0 +

Add comment

Please sign in to leave a comment.