Comments
Sort by recent activity
Hi @DanC Yes that's what is written in the documentation. However, when I'm trying to use Database Build Artifact as an example I receive the error which I mentioned in my starting post. Could you please check it out? Just to be sure, I run a test - I've created an empty SCA project, created a build artifact out of it and then tries to use it as a target parameter for release artifact. I still get the error: [image] [image] [image] Could you give me a simple reproducible example on how do I use such a parameter? I might be missing something / comments
Hi @DanC Yes that's what is written in the documentation. However, when I'm trying to use Database Build Artifact as an example I receive the error which I mentioned in my starting post. Could you ...
Version 15.5.2 of VS3.0.18275.1681 of SQL Change Automation The solution only contain one project which is database project It´s happening on both new and converted projects
/ comments
Version 15.5.2 of VS3.0.18275.1681 of SQL Change Automation The solution only contain one project which is database projectIt´s happening on both new and converted projects
Greg_Smulko said:
We were able to identify the root cause of this issue and we're working on a permanent fix. For now, a workaround is to add the following line into a PropertyGroup in the .sqlproj: <SyncOptionIgnoreConstraintNotForReplicationAttribute>False</SyncOptionIgnoreConstraintNotForReplicationAttribute>Sorry for the inconvenience caused. For the future reference, regarding creating support tickets, please start from the https://productsupport.red-gate.com/hc/en-us page , where you can submit a request.
Hi Greg, Thanks, that was it! Seems to work fine now. I was going to create this request but I haven't seen anything meaningful in the logs of the new version so I was going to conduct proper test before I send it to you. / comments
Greg_Smulko said:
We were able to identify the root cause of this issue and we're working on a permanent fix.For now, a workaround is to add the following line into a PropertyGroup in the .sq...
Greg_Smulko said:
Hi Roman, could you paste these 2 lines from the log file between which a gap occurs?
Greg, any new insights of the problem? Please let me know if we can expect some changes/advises or if we have to start looking into some workarounds. / comments
Greg_Smulko said:
Hi Roman, could you paste these 2 lines from the log file between which a gap occurs?
Greg, any new insights of the problem? Please let me know if we can expect some chang...
It looks like this: <div>080892|2018-10-08 13:08:12.370|DEBUG|RedGate.Versioning.Core.VersioningProject.DatabaseProject|83|Changed file: C:\Projects\Roman.Pekar\TestProject\Schema-Model\data\Tables\TEST.sql
<span style="background-color: transparent; color: inherit; font-size: inherit; font-family: roboto, "helvetica neue", Arial, sans-serif;">080892|2018-10-08 13:17:14.864|DEBUG|RedGate.Versioning.Client.VsShell.VisualStudio.ShellIntegration.VisualStudioProjectFileUpdater|70|The following files have been added:
</span><span style="background-color: transparent; color: inherit; font-size: inherit; font-family: roboto, "helvetica neue", Arial, sans-serif;">080892|2018-10-08 13:17:14.953|DEBUG|RedGate.Versioning.Client.VsShell.VisualStudio.ShellIntegration.VisualStudioProjectFileUpdater|70|Number of assets to add to project: 0</span></div> / comments
It looks like this:<div>080892|2018-10-08 13:08:12.370|DEBUG|RedGate.Versioning.Core.VersioningProject.DatabaseProject|83|Changed file: C:\Projects\Roman.Pekar\TestProject\Schema-Model\data\Tables\...
samssb82 said:
I have seen this behavior, but in our scenario it is when there is a change to a large stored procedure or view. I believe it is attempting to identify the differences.
Hm I think it can be interesting to check if 'refresh' works better if there's no changes at all, thanks! / comments
samssb82 said:
I have seen this behavior, but in our scenario it is when there is a change to a large stored procedure or view. I believe it is attempting to identify the differences.
Hm I ...
Hi Greg, Thanks for your tip. The version of RR we were using before update is 1.14. I've set level to DEBUG, and there's more information in the log now. But it still not clear what's the reason for the issue is, I just see a big gap (~10 minutes) between 2 lines in the log file. Do you think there're something else we can do? I've tried to check what happens with Process Monitor but cannot see anything specific (there're quite some activity from SQL LightHouse service and a lot of access to Temp\user\Red Gate\*.tmp files though) / comments
Hi Greg,Thanks for your tip. The version of RR we were using before update is 1.14.I've set level to DEBUG, and there's more information in the log now. But it still not clear what's the reason for...
It is still the case for me, yes / comments
It is still the case for me, yes
Any news on this issue? / comments
Any news on this issue?
I remember that at some point there was a link to download FlySQL on this page - http://www.red-gate.com/flysql. However, now the only option available is to 'sign up for early access mailing list'. Is it still possible to try it? I'd be interested to try it for PostgreSQL. / comments
I remember that at some point there was a link to download FlySQL on this page - http://www.red-gate.com/flysql. However, now the only option available is to 'sign up for early access mailing list'...