Activity overview
Latest activity by philcart
include parameter doesn't handle spaces
Using SQL Compare command line 10.2.0.1337
I'm using a Powershell script to build up a SQL Compare command line that generates a deployment script for database changes.
One of our developers create...
Default TFS port of 8080
Seehttp://www.red-gate.com/messageboard/viewtopic.php?t=13970&highlight=8080
andhttp://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2598920-tfs-migration-script-unusable-with-c...
Thanks for the response David. Unfortunately that didn't help at all and I wasted another few hours on this today before working out what the problem was.
The problem has nothing to do with any of the switches mentioned in the error message, or the square brackets,
/scripts1:"C:\Temp\7000\SQL\"
The path shouldn't have a trailing "\". Once I removed the trailing "\" the command worked without any problems.
I suppose it would be too much to ask that we get a useful error message rather than the red herring :lol:
Cheers
Phil / comments
Thanks for the response David. Unfortunately that didn't help at all and I wasted another few hours on this today before working out what the problem was.
The problem has nothing to do with any of ...
Error with arguments on command line
Executing the following on the command line.
"C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /scripts1:"C:\Temp\7000\SQL\" /server2:MyServer\instance /database2:mydatabase /...
Can't uncheck dependent objects
Running
- SSC 3.0.13.4178
- SSMS 2008 R2
When creating a migration script for an uncommitted change, I'm not able to uncheck the "Commit all dependencies" check box.
I understand what SSC is trying...
Just as an FYI, the support request number for this is F0059825. / comments
Just as an FYI, the support request number for this is F0059825.
Do not have permissions to modify the file
Windows 7 64bit
SSC v 3.0.10.3420
SSMS v 10.50.2500.0
Source Control TFS 2010
Performing "Get Latest" and receive the following error,
"Do not have permissions to modify the file C:\Users\pcarter\A...
Thanks Brian, eagerly awaiting that update [image] / comments
Thanks Brian, eagerly awaiting that update
Brian
I've replaced the "default" option so my command line now looks like,
&"C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /Scripts1:"C:\Temp\2583\SQL" /server2:UATMRISQL01 /database2:KFProd /scriptfile:"C:\Temp\2583\2583.sql" /options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IncludeDependencies,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName,IgnorePermissions,IgnoreUsersPermissionsAndRoleMemberships /include:Different /include:StoredProcedure:[eft_ListBrokenEfts]^|[app_CheckRptServer]^|[SendEmailGeneric]
But I still get the "REVOKE" statements included in the script that is generated.
Thanks
Phil
[/code] / comments
Brian
I've replaced the "default" option so my command line now looks like,
&"C:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /Scripts1:"C:\Temp\2583\SQL" /server2:UATMRISQL0...
Brian
The table we had was dropped by another user on a dedicated development setup.
Your other option would be to delete the table from source control directly, not using SQL Source Control.
Cheers
Phil / comments
Brian
The table we had was dropped by another user on a dedicated development setup.
Your other option would be to delete the table from source control directly, not using SQL Source Control.
Chee...