Linking database to perforce fails

S.engel

I am able to link database to the evulation SVN. However it is not possible to link databases to perforce.
I have created my own config file SFP.xml

<HooksConfig version="1" type="HooksConfig">
  <!-- The name of the config file that will be displayed in the SQL Source Control user interface -->
  <Name>SFP</Name>
  <Commands type="Commands" version="2">
    <element>
      <key type="string">GetLatest</key>
      <!-- Updates the local working folder with latest version in source control. -->
      <!-- Valid macros: ($ScriptsFolder) ($Message) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s sync "($ScriptsFolder)..."</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
    <element>
      <key type="string">Add</key>
      <!-- Adds new files to the local working copy. Changes can then be committed to source control using the Commit command. -->
      <!-- Valid macros: ($ScriptsFolder) ($Message) ($Files) ($Folders) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s add -t binary ($Files)</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
    <element>
      <key type="string">Edit</key>
      <!-- Makes the local working copy of the file(s) available for editing. Changes can then be committed to source control using the Commit command. -->
      <!-- Valid macros: ($ScriptsFolder) ($Message) ($Files) ($Folders) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s edit ($Files)</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
    <element>
      <key type="string">Delete</key>
      <!-- Deletes the file(s) from the local working copy. Changes can then be committed to source control using the Commit command. -->
      <!-- Valid macros: ($ScriptsFolder) ($Message) ($Files) ($Folders) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s delete ($Files) ($Folders)</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
    <element>
      <key type="string">Commit</key>
      <!-- Commits all changes in the local working folder to source control. -->
      <!-- Valid macros: ($ScriptsFolder) ($Message) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s submit -d "($Message)" "($ScriptsFolder)..."</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
    <element>
      <key type="string">Revert</key>
      <!-- Undoes changes if an error occurs during a commit -->
      <!-- Valid macros: ($ScriptsFolder) -->
      <value version="1" type="GenericHookCommand">
        <CommandLine>P4 -s revert "($ScriptsFolder)..."</CommandLine>
        <Verify>exitCode == 0</Verify>
      </value>
    </element>
  </Commands>
</HooksConfig>

I can see new created folder for all the objects in the workfile-folder but they are all empty.

This is the error message I get when the linking fails: (First Window)

Command:
P4 -c WS_SFP -s submit -d "Database project file added by Red Gate SQL Source Control" "J:\PerforceDB\database\SFPI\..."

Output:
error: No files to submit from the default changelist.

exit: 1

Exit code:
1

and then in another popup-window:


Command line hook failed


Best regards
Synnøve

S.engel

OK, I finally found it. Perforce always needs a comment, so the first link will fail.
This workaround helps:
http://www.red-gate.com/SupportCenter/Content/SQL_Source_Control/knowledgebase/linking-fails

jorundur

I downloaded SQL Source Control and I am trying to link a database to source control using Perforce. I think I am getting the same problems as described here, but the link to the workaround does not work. Can anyone tell me anything about this workaround or point me to the correct link

Gareth_B

I believe this is a working link to the workaround:

http://documentation.red-gate.com/displ ... mmit+hooks

Although that page relates to SVN, the same approach can be taken with your Perforce client.

If you problems persist, please let us know (either by posting here or by contacting support@red-gate.com).

jorundur

That did the trick, thank you very much!