Comments
Sort by recent activity
Hi Javier,
Thanks for pointing this out. We will try and get it fixed as soon as possible.
Regards,
Jonathan / comments
Hi Javier,
Thanks for pointing this out. We will try and get it fixed as soon as possible.
Regards,
Jonathan
Hi there,
Is there any way that we can get the complete schema for your database, that way we can narrow down the problem as unfortunately the script that you have provided doesn't cause any problems.
Can I ask what permissions the user that you are using to connect SQL Compare to the database has? Are they dbo, sa or are they more limited?
Regards,
Jonathan / comments
Hi there,
Is there any way that we can get the complete schema for your database, that way we can narrow down the problem as unfortunately the script that you have provided doesn't cause any proble...
Hi there,
I have PM'ed about this issue.
Regards,
Jonathan / comments
Hi there,
I have PM'ed about this issue.
Regards,
Jonathan
Hi there.
I am sorry about the trouble you have gone through. I will look into getting this fixed.
Regards,
Jonathan / comments
Hi there.
I am sorry about the trouble you have gone through. I will look into getting this fixed.
Regards,
Jonathan
Hi Troy,
Yep it looks like you have found an issue here; if the view is identical but there is a difference in a permission or an extended property then the view will not be refreshed correctly.
There is a workaround for your problem: if you run with the ignore permissions and ignore extended properties options enabled the views will refresh correctly. Then if you run another synchronisation with these options now disabled you can then sync up the permissions and extended properties.
I understand that this is not perfect, I have raised this with the development team but I don't have an outlook as to when this issue will resolved at the moment.
Regards,
Jonathan / comments
Hi Troy,
Yep it looks like you have found an issue here; if the view is identical but there is a difference in a permission or an extended property then the view will not be refreshed correctly.
Th...
Glad to here the latest build fixed your issue. Keep the feedback coming.
Regards,
Jonathan / comments
Glad to here the latest build fixed your issue. Keep the feedback coming.
Regards,
Jonathan
Hi there,
Thanks for the report. We will look at getting this fixed shortly.
Regards,
Jonathan Watts / comments
Hi there,
Thanks for the report. We will look at getting this fixed shortly.
Regards,
Jonathan Watts
Alex,
We have reproduced the issue. We will try to get a fix in for this, but I am not sure what timescales will be at this time.
Regards,
Jonathan / comments
Alex,
We have reproduced the issue. We will try to get a fix in for this, but I am not sure what timescales will be at this time.
Regards,
Jonathan
During testing we have discovered if SQL Compare needs to rebuild a memory optimized table when the "Ignore Filegroups" option is disabled the script SQL Compare generates will contain an empty ON clause on a CREATE TABLE statement, used to create a temporary table to house the memory optimised table's data whilst it is rebuilt.
This issue (SC-7359) will be fixed in the next beta of SQL Compare 11, however until then you should not disable the "Ignore Filegroups" option or you will need to either edit your scripts to remove any occurrences of ON [] / comments
During testing we have discovered if SQL Compare needs to rebuild a memory optimized table when the "Ignore Filegroups" option is disabled the script SQL Compare generates will contain an empty ON ...
The default options cannot be changed. We may change this in future versions, but at the current time Tom's workaround is the only way to do this.
Regards,
Jonathan / comments
The default options cannot be changed. We may change this in future versions, but at the current time Tom's workaround is the only way to do this.
Regards,
Jonathan