How can we help you today? How can we help you today?
Sergio Rocha
Activity overview Badges (0) Articles (25) Posts (0) Comments (2)

Articles

Sort by recent activity
Could not install SqlChangeAutomation from any registered PSRepository
  1. Product help
  2. SQL Change Automation
This can be caused by connection issues to the PowerShell Gallery or because the connection does not meet the encryption standard required to connect to the PowerShell Gallery, please see this arti...
Edited 2 followers 0 comments -2 votes
System.Exception: No match was found for the specified search criteria and module name 'SQLChangeAutomation'. Try Get-PSRepository to see all available registered module repositories
  1. Product help
  2. SQL Change Automation
The SQL Change Automation add-on will attempt to download the latest version of the SQL Change Automation (SCA) Module from the PowerShell Gallery before carrying out the task at hand. This allows ...
Edited 1 follower 0 comments 1 vote
No match was found for the specified search criteria and module name 'SqlChangeAutomation'.
  1. Product help
  2. SQL Change Automation
This issue can occur when using when you are using a SQL Change Automation Azure DevOps add-on, using an older task version, and the self-hosted agent you are using cannot download the SQL Change A...
Edited 1 follower 0 comments 0 votes
Online index operations can only be performed in Enterprise edition of SQL Server
  1. Product help
  2. SQL Change Automation
This error occurs because SQL Change Automation uses SQL Server Express LocalDB as the default Temporary Database Server for the schema validation operation. If you are using a PowerShell Script: U...
Edited 1 follower 0 comments -1 votes
Meanings of the colored dots in the SSMS Object Explorer for SQL Source Control
  1. Product help
  2. SQL Source Control
In the object explorer of SQL Server Management Studio (SSMS) SQL Source Control uses colored dots to indicate several different status types for the status of SQL Source Control or the type of cha...
Edited 1 follower 0 comments 1 vote
Unable to resolve package source
  1. Product help
  2. SQL Change Automation
You get the following error message when running a SQL Change Automation Powershell: Unable to resolve package source 'https://www.powershellgallery.com/api/v2'.No match was found for the specified...
Edited 1 follower 0 comments 0 votes
error 5(Access is denied.) while attempting to open or create the physical file
  1. Product help
  2. SQL Change Automation
This error can occur when using SQL Change Automation Powershell, with the default option of validating the schema folder in LocalDB, and you have LocalDB 2017 installed.  This is caused by a bug i...
Edited 1 follower 0 comments -2 votes
How to link to an existing SVN repository
  1. Product help
  2. SQL Source Control
Linking to SVN After you link Linking to SVN To do this, you will need to be able to link to the folder where the RedGate.ssc file is located. In the Object Explorer, select the database you wan...
Edited 1 follower 0 comments -1 votes
SQL Change Automation Installation freezes at 99%
  1. Product help
  2. SQL Change Automation
If you find that your SQL Change Automation installation freezes at 99% try installing the extension using the Visual Studio Marketplace (SQL Change Automation Core) before running the installer: h...
Edited 2 followers 0 comments -1 votes
SQL Change Automation Powershell permissions
  1. Product help
  2. SQL Change Automation
When working with SQL Source Control Projects, SQL Change Automation PowerShell requires the same permissions as SQL Compare: Permissions required to use SQL CompareBuild step specific: Besides the...
Edited 1 follower 0 comments 3 votes
Total activity
49
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
22