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.
- Code: Select all
P4 -c Services -s submit -d "Database project file added by Red Gate SQL Source Control" "C:\\Perforce\\Services\\MyProject\\Database\\..."
error: No files to submit from the default changelist.