Opening projects from SQL Compare 11 in SQL Compare 13

JohnWHocking · June 14, 2019 4:31PM

We are getting an error when trying to open sql compare projects from version 11 in version 13.

Error Loading project: Specified method is not supported.

I have not been able to find any troubleshooting related to this issue?

John

Russell D · June 17, 2019 2:59PM

I've had no problems opening a Compare 11 Project in Compare 13. Do the log files shed any light: https://documentation.red-gate.com/sc13/getting-more-from-sql-compare/logging-and-log-files?

Failling that can you send in the scp file?

JohnWHocking · July 31, 2019 3:44PM

10:35:18.943|Warn |UpdateClient |14 |Failure whilst attempting check for updates

System.Net.WebException: The operation has timed out

at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)

at System.Net.HttpWebRequest.GetRequestStream()

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at RedGate.Update.Client.SoapUpdateServer.Check.CheckForUpdates(String xmlArgument, String& xmlResponse, String& errorMessage)

at RedGate.Update.Client.UpdateServer.UpdateServer.CheckForUpdates(String serialNumber, Boolean automatic)

10:35:18.943|Warn |UpdateClient |14 |Facade failure

System.Net.WebException: The operation has timed out

Server stack trace:

at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)

at System.Net.HttpWebRequest.GetRequestStream()

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at RedGate.Update.Client.SoapUpdateServer.Check.CheckForUpdates(String xmlArgument, String& xmlResponse, String& errorMessage)

at RedGate.Update.Client.UpdateServer.UpdateServer.CheckForUpdates(String serialNumber, Boolean automatic)

at RedGate.Update.Client.UpdateService.CheckForUpdatesStatic(IUpdateServer updateServer, IDownloadManager downloadManager, String serialNumber, Boolean automatic, DownloadProgress progress)

at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)

at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)

at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)

at RedGate.Update.Client.UpdateService.Callback.EndInvoke(IAsyncResult result)

at RedGate.Update.Client.UpdateService.EndCheckForUpdates(IAsyncResult asyncResult)

at RedGate.Update.Client.UpdateFacade.CheckFinished(IAsyncResult ar)

10:35:18.943|Info |UpdateClient |14 |State: Error

10:35:18.943|Info |UpdateClient |14 |Exiting check for updates

10:35:23.849|Info |SQL Compare |11 |Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents

Number of submitted usage events = 2

HTTP status code =

Response body = null

10:35:23.865|Info |SQL Compare |9 |Usage reporting request made to https://productusage.red-gate.com/v1/usageevents

Number of submitted usage events = 1

HTTP status code =

Response body = null

10:35:37.428|Info |SQL Compare |11 |Sending 1 event:

[

{

"eventType": "project.open-file.opened",

"headers": {

"productId": "sql-compare",

"productVersion": "13.7.13.10771",

"eventUuid": "e9545027-5668-44b8-af9d-9f1e084af994",

"usageUserId": "1cc804c0-eb13-4946-8ffe-ae1e90f40d55",

"sessionUuid": "385906ce-4867-4345-96f2-9b99d1209df0",

"createdTimeUtc": "2019-07-31T15:35:37Z"

},

"payload": {}

}

]

10:35:37.474|Debug |Event Aggregator |1 |Registered RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Connection.Controls.DataSourceHeader as listener for RedGate.Compare.CommonUI.Events.SynchronizationDirectionChanged

10:35:37.537|Debug |Event Aggregator |1 |Registered RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Connection.Controls.DataSourceHeader as listener for RedGate.Compare.CommonUI.Events.SynchronizationDirectionChanged

10:35:37.646|Debug |Event Aggregator |1 |Registered RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Connection.Controls.DataSourceHeader as listener for RedGate.Compare.CommonUI.Events.SynchronizationDirectionChanged

10:35:37.771|Debug |Event Aggregator |1 |Registered RedGate.SqlServer.Comparison.Shared.UI.Dialogs.Connection.Controls.DataSourceHeader as listener for RedGate.Compare.CommonUI.Events.SynchronizationDirectionChanged

10:35:42.208|Debug |Event Aggregator |1 |Sending message RedGate.Compare.CommonUI.Events.MruProjectListChanged

10:35:58.474|Info |SQL Compare |11 |Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents

Number of submitted usage events = 1

HTTP status code =

Response body = null

10:39:52.870|Info |SQL Compare |11 |Sending 1 event:

[

{

"eventType": "project.open-file.opened",

"headers": {

"productId": "sql-compare",

"productVersion": "13.7.13.10771",

"eventUuid": "05062498-27ff-4c5c-91b7-148ddfd2dcd2",

"usageUserId": "1cc804c0-eb13-4946-8ffe-ae1e90f40d55",

"sessionUuid": "385906ce-4867-4345-96f2-9b99d1209df0",

"createdTimeUtc": "2019-07-31T15:39:52Z"

},

"payload": {}

}

]

10:39:52.964|Error |EditProjectWindowSer|1 |Error loading project: Specified method is not supported.

System.NotSupportedException: Specified method is not supported.

at RedGate.SqlSourceControl.Client.MigrationsV1.NotSupportedMigrationsV1Client.GetMigrationsV1FolderLocation(String xml)

at RedGate.SqlServer.Comparison.Shared.UI.Services.SOC.SOCLinkService.GetMigrationsV1FolderLocation(String xml)

at RedGate.SQLCompare.Engine.SourceControlDataSource.FixupAfterDeserialization(ISOCCompareLocationProvider socCompareLocationProvider)

at RedGate.SqlServer.Comparison.Shared.UI.Services.SOC.SOCLinkService.FixupDataSource(SourceControlDataSource sourceControlDataSource)

at RedGate.SqlServer.Comparison.Shared.UI.Services.SqlServerProjectLoaderService.FixupDeserializedSourceControlDataSources(Project project)

at RedGate.SqlServer.Comparison.Shared.UI.Services.SqlServerProjectLoaderService.LoadFromDisk(String fileName)

at RedGate.SqlServer.Comparison.Shared.UI.Services.EditProjectWindowService.LoadProject(String fileName)

at RedGate.SqlServer.Comparison.Shared.UI.Services.EditProjectWindowService.<ShowWindowForOpeningDifferentProject>d__24.MoveNext()

10:39:52.964|Error |Error Reported |1 |Error loading project: Specified method is not supported.