How can we help you today? How can we help you today?
Annie
Activity overview Badges (0) Posts (1) Comments (4)

Comments

Sort by recent activity
Hi Eric,  I have upgraded to VS 2022 v 17.9.0 and I am getting below error. It looks to the one you are referring to with 17.8.0 version - https://forum.red-gate.com/discussion/90219/problem-after-update-to-visual-studio-17-8 Anyone else encountered this issue, please?  Thanks,  Error message:  Message = Method not found: 'Boolean Microsoft.Data.SqlClient.SqlConnectionStringBuilder.get_Encrypt()'. Data = System.Collections.ListDictionaryInternal InnerException =  TargetSite = RedGate.Versioning.Engine.Shared.DatabaseUtils.Connection.ConnectionStringProperties ParseConnectionString(System.String) StackTrace =    at RedGate.Versioning.Engine.Shared.DatabaseUtils.SqlServer.Connection.ConnectionStringParser.ParseConnectionString(String connectionString)    at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetRawConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames)    at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames, IProgressLogger progress)    at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.LoadSettings(String filePath, IProgressLogger progress)    at RedGate.Versioning.Engines.Migrations.Projects.SqlProj.DatabaseConnections.ProjectDatabasesRetriever.LoadSettings(String filePath, IProgressLogger progress)    at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadProject(Project project)    at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadDefaultProject() HelpLink =  Source = RedGate.Versioning.Engine.Shared.DatabaseUtils.SqlServer HResult = -2146233069 / comments
  1. Community
  2. SQL Change Automation
  3. Upgrading to Visual Studio 2022 17.9.0
Hi Eric, I have upgraded to VS 2022 v 17.9.0 and I am getting below error. It looks to the one you are referring to with 17.8.0 version - https://forum.red-gate.com/discussion/90219/problem-after-u...
0 votes
Tianjiao_Li said: @Annie Thanks for your patience with us! I'm pleased to let you know this issue has been fixed in version 4.3.20267 which we have just released. Please upgrade and let us know if there are any issues. Thanks. Thank you! That's great. / comments
  1. Community
  2. SQL Change Automation
  3. No scripts displayed in the Error window
Tianjiao_Li said: @Annie Thanks for your patience with us!I'm pleased to let you know this issue has been fixed in version 4.3.20267 which we have just released. Please upgrade and let us kno...
0 votes
Tianjiao_Li said: Hi @Annie Thanks for your clarification. I'm able to reproduce the issue as well. We've logged a bug for it and will keep you posted with any further updates! Apologies for the inconvenience this is causing you. Thank you @Tian@Tianjiao_Li. I will await an update on this.  Just a thought - We feel that ideally there should be a dedicated deployment script list tab somewhere in the application rather than just writing to the Error List. But the Error List would do in the meantime!      / comments
  1. Community
  2. SQL Change Automation
  3. No scripts displayed in the Error window
Tianjiao_Li said: Hi @Annie Thanks for your clarification. I'm able to reproduce the issue as well. We've logged a bug for it and will keep you posted with any further updates!Apologies for t...
0 votes
Tianjiao_Li said: Hi @Annie These scripts show as Pending scripts because you updated them in the project rather than on the development database. You can deploy them to the database, mark them as deployed, or delete them from the Project. Hi @Tianjiao_Li, Thank you for your answer. I think you misunderstood my question. It is completely correct that there are Pending scripts. I am expecting pending scripts and I would like to deploy them. The problem is that the error window doesn't display a list of the scripts which are pending anymore.  Process used to create scripts: SQL changes were made in a development database.  SCA is pointed to the development databases. Changes are then visible in SCA and new scripts are created.  SCA is pointed to a production database. SCA is aware of a new scripts but it doesn't display names of the scripts in the Error window as it used do it before.  One of my colleagues has not updated to the latest version yet. He is still able to see the list of scripts ready for deployment.   Please, let me know if you need any further details. Thanks,  Annie / comments
  1. Community
  2. SQL Change Automation
  3. No scripts displayed in the Error window
Tianjiao_Li said: Hi @Annie These scripts show as Pending scripts because you updated them in the project rather than on the development database.You can deploy them to the database, mark the...
0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2