Comments
Sort by recent activity
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 ...
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.
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...
Brian
In our TEST/UAT environments there are additional roles/users that have permissions on the procedures being deployed. As such we don't want these permissions reverting to what is set in the DEV environment.
The script that is generated contains the following,
PRINT N'Altering permissions on [dbo].[SendEmailGeneric]'
GO
REVOKE EXECUTE ON [dbo].[SendEmailGeneric] TO [ApplicationSupport]
GO
I've tried various switches/options, but it seems explicitly including items overrides the ignore options.
I would expect the included items to be compared as per the specified switches and options.
Cheers
Phil / comments
Brian
In our TEST/UAT environments there are additional roles/users that have permissions on the procedures being deployed. As such we don't want these permissions reverting to what is set in the D...
Thanks Brian
The problem can be replicated easily enough.
Just set things up to have a "drop table" listed in Get Latest. Perform some sort of transaction on the table to be dropped, but don't commit the transaction.
Perform a get latest in SSC. SSC will be blocked by the uncommitted transaction. While waiting, click the cancel button.
Cheers
Phil / comments
Thanks Brian
The problem can be replicated easily enough.
Just set things up to have a "drop table" listed in Get Latest. Perform some sort of transaction on the table to be dropped, but don't comm...
I've solved my "Expressions are only allowed as the first element of a pipeline." error by escaping the pipe character with a backtick.
But that still leaves me with a deployment script messing around with permissions. / comments
I've solved my "Expressions are only allowed as the first element of a pipeline." error by escaping the pipe character with a backtick.
But that still leaves me with a deployment script messing aro...
Ok, this is now breaking the product. Definitely needs some work done on it. http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2598920-tfs-migration-script-unusable-with-custom-port / comments
Ok, this is now breaking the product. Definitely needs some work done on it.http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2598920-tfs-migration-script-unusable-with-custo...
Cheers. / comments
Cheers.