Comments
Sort by recent activity
I found a working solution. The problem was with the setup of my Perforce work space. I don't know exactly what was the issue. But, here is my solution:
I started with a Perforce workspace named, "MyWorkSpace" with these directories:
C:\Perforce\MyWorkSpace\MyProject\Code\ApplicationCode
C:\Perforce\MyWorkSpace\MyProject\Code\Database 1. Removed the Database path from the MyWorkSpace workspace and created a new workspace, MyWorkSpace_Database. It is extermely important that you don't have 2 workspaces pointing to the Database path. Otherwise your files can get clobbered & out of sync when you Get Latest. 2. Mapped the new workspace (MyWorkSpace_Database) so that it only points to the database path, [C:\Perforce\MyWorkSpace\MyProject\Code\Database]. 3. Opened the folder [%USERPROFILE%\AppData\Local\Red Gate\SQL Source Control 2\CommandLineHooks] in windows explorer. 4. Created a copy of the Perforce.xml file. Opened it for edit. 5. Changed the value of the <Name>Perforce</Name> element to <Name>Perforce [MyProject]</Name> 6. For each of the <CommandLine> elements added the -c MyWorkSpace_Database. For example, the commit command line now looks like this: <CommandLine>P4 -c MyWorkSpace_Database -s sync "($ScriptsFolder)..."</CommandLine> 7. Saved the XML file. 8. Launched SQL Server and Linked to Source Control. When prompted by Sql Source Control to select the config file for source control commands I chose the one with the Name value from step 5 above.
That worked for me. / comments
I found a working solution. The problem was with the setup of my Perforce work space. I don't know exactly what was the issue. But, here is my solution:
I started with a Perforce workspace named, "...
I'm having this exact same problem. My workspace is not Depot, it is called "Services". I added the -c parameter to specify the workspace. It fails with the "No files" error message, see below. I am following the workflow described above. SqlSourceControl creates the entire directory structure under [C:\Perforce\Services\MyProject\Database\]. I can see all the folders it added for tables, sprocs, views, etc. They are all empty. SqlSourceControl also creates a RedGate.ssc file. It is an empty file with size of 0 kb.
The funny thing is that this DOES work when I specify a workspace and folder under depot such as [C:\Perforce\<MyUsername>_perforce_1666\depot\MyProject\Database]. Unfortunately, that location is not acceptable. Command:
P4 -c Services -s submit -d "Database project file added by Red Gate SQL Source Control" "C:\Perforce\Services\MyProject\Database\..."
Output:
error: No files to submit from the default changelist.
exit: 1
Exit code:
1
/ comments
I'm having this exact same problem. My workspace is not Depot, it is called "Services". I added the -c parameter to specify the workspace. It fails with the "No files" error message, see below. I a...
I tried using the /Include:Indentical switch. I got an error message stating the switch is not allowed when specifying a project file.
I created a new project file from scratch. It still had the same problem
Unfortunately, I cannot send the schema because it is a sensitive problem domain related to safety & security. I realize that limits your ability to help me. Perhaps I can try to reproduce the problem with a new mock database. I'll see what I can do. / comments
I tried using the /Include:Indentical switch. I got an error message stating the switch is not allowed when specifying a project file.
I created a new project file from scratch. It still had the sa...
In the GUI, at the top grid, I have:
+ 102 objects that exist in both but are different
+ 2 objects that exist only in <ServerName>.<DatabaseName>
+ 808 identical objects
All of the 102 differences are found in stored procedures. When I click the stored procedure name it brings up the SQL pane and highlights the difference in green. They are definitely different.
This is what the compare looks like when executed from the command line: C:\Program Files (x86)\Red Gate\SQL Compare 9>sqlcompare /Project:"C:\Whatever.scp"
SQL Compare Command Line V9.0.0.79
==============================================================================
Copyright c Red Gate Software Ltd 1999-2011
Serial Number: <My Serial Number>
Registering data sources
Creating mappings
Comparing
Applying project settings
Error: The selected objects are identical or no objects have been selected in
the comparison.
/ comments
In the GUI, at the top grid, I have:
+ 102 objects that exist in both but are different
+ 2 objects that exist only in <ServerName>.<DatabaseName>
+ 808 identical objects
All of the 102 differences...
It did work with the command line. But, it also defeats the purpose of having all my settings wrapped up in the project file. / comments
It did work with the command line. But, it also defeats the purpose of having all my settings wrapped up in the project file.
I'm not using that switch. Yet, I get the error message that there are no objects to compare. This is all I'm doing...
sqlcompare /Project:"C:\Whatever.scp"
/ comments
I'm not using that switch. Yet, I get the error message that there are no objects to compare. This is all I'm doing...
sqlcompare /Project:"C:\Whatever.scp"
Thanks Chris. So, is there a way to execute JUST the compare from the command line using a SCP? I'm trying to integrate with CruiseControl.Net. I don't want to sync, just compare. / comments
Thanks Chris. So, is there a way to execute JUST the compare from the command line using a SCP? I'm trying to integrate with CruiseControl.Net. I don't want to sync, just compare.
Ahh...figured it out. The "no objects have been selected" refers to the things you want to synchronize after the compare is complete. It is not the things you want to compare.
:roll: / comments
Ahh...figured it out. The "no objects have been selected" refers to the things you want to synchronize after the compare is complete. It is not the things you want to compare.
:roll: