Comments
Sort by recent activity
Hi,
Sorry you have been kept in the dark for so long.
The development team have confirmed this as a bug with SQL Compare. It is currently scheduled to be fixed for version 6 of the software. / comments
Hi,
Sorry you have been kept in the dark for so long.
The development team have confirmed this as a bug with SQL Compare. It is currently scheduled to be fixed for version 6 of the software.
Thanks for your post.
Is the script that's being generated in a different order still functionally correct, or does are the scripts invalid every so often? / comments
Thanks for your post.
Is the script that's being generated in a different order still functionally correct, or does are the scripts invalid every so often?
Thanks for your post.
I haven't personally looking into this in any detail, so I'll have a word with the dev team to find out why it's been designed like this.
My assumption at this stage is that is that we don't analyse what has changed in the package, only that the package has changed, and therefore script the COMPILE because that's the safest thing to do in most situations.
I'm interested to know how the recomplile is invalidating other objects in your database. Is that just during the recompile, or is it breaking them completely in some way? / comments
Thanks for your post.
I haven't personally looking into this in any detail, so I'll have a word with the dev team to find out why it's been designed like this.
My assumption at this stage is that i...
Hi Rob,
Thanks for your post.
This is a good idea and it seems to be the first time anyone has suggested it to us. I've logged the feature request internally as SB-5557 to be reviewed by our development team.
I wouldn't expect a feature like this to be added any time soon, but it can at least be up for consideration now.
Your idea of writing a powershell wrapper sounds like a good workaround for the time being.
If you have any success, it would be great if you could post your script so other users with the same issues can make use of it. Seeing your script would also help us understand your requirements better, if the feature is ever implemented.
Regards, / comments
Hi Rob,
Thanks for your post.
This is a good idea and it seems to be the first time anyone has suggested it to us. I've logged the feature request internally as SB-5557 to be reviewed by our develo...
Thanks for your post.
I'm not really sure why this would be happening. There aren't any case sensitivity options that I'm aware of that would affect this.
Would you be able to send me an example script for an object that causes this?
What happens if you unlink your project and then relink? Does your client then report the case difference similar to your colleague? / comments
Thanks for your post.
I'm not really sure why this would be happening. There aren't any case sensitivity options that I'm aware of that would affect this.
Would you be able to send me an example sc...
Thanks for your post.
We've had a few requests for this feature over the years, but unfortunately it has never been scheduled into any future versions of the product.
There isn't any short-term plans for this to change, but I'll make sure it's considered for the next time we work on the product.
I really don't know when this might be, but it's unlikely it will be within the next six months.
Sorry, I don't have any better news. / comments
Thanks for your post.
We've had a few requests for this feature over the years, but unfortunately it has never been scheduled into any future versions of the product.
There isn't any short-term pl...
Thanks for your post.
Yes, you can automate your deployments using the SQL Compare command line. The easiest way is to use a Windows Scheduled Task.
The best way to get started is to read our documentation on using the command line interface. There are several examples that should help you set it up.
I hope this helps. / comments
Thanks for your post.
Yes, you can automate your deployments using the SQL Compare command line. The easiest way is to use a Windows Scheduled Task.
The best way to get started is to read our docum...
Thanks for your post.
I agree that the error message isn't very helpful in this situation.
I suspect that while the index is being rebuild SQL Server creates a temporary copy which gets flagged as a duplicate when SQL Compare stumbles across it.
I'm not sure how to test for that, as I don't really know what SQL Server does internally while rebuilding, or if there is any way to determine if this kind of operation is being performed and warn the user. / comments
Thanks for your post.
I agree that the error message isn't very helpful in this situation.
I suspect that while the index is being rebuild SQL Server creates a temporary copy which gets flagged as ...
Thanks for your post.
I'm afraid this isn't possible, but you might like to suggest it on our uservoice site.
We have the feature in our SQL Server version, just not in the Oracle tool. / comments
Thanks for your post.
I'm afraid this isn't possible, but you might like to suggest it on our uservoice site.
We have the feature in our SQL Server version, just not in the Oracle tool.
Thanks for your post.
Do you have the DDL for the (source and target) objects that cause this behavior? / comments
Thanks for your post.
Do you have the DDL for the (source and target) objects that cause this behavior?