Linking database to perforce fails

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

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

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 August 24, 2012 09:15

Comments

4 comments

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

S.engel August 28, 2012 10:13

0
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

jorundur September 03, 2014 11:21

0
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).

Gareth_B September 08, 2014 08:20

0
That did the trick, thank you very much!

jorundur September 11, 2014 10:51

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Linking database to perforce fails

Comments

Add comment