Comments
Sort by recent activity
Thanks for your post.
We happen to already have a case open for this, but it is quite a tricky issue.
The problem is that the syntax for a windows user and a windows group is exactly the same, so the script reader cannot know if something is a user or a group without contacting the NT domain - bad idea.
We are hoping to find a solution for the next major version of SQL Compare, but it looks like any solution will require assumptions to be made, which could result in inconsistent results.
The case open for this is SC-4057.
Another customer has made some helpful suggestions on another thread, that you may find useful: http://www.red-gate.com/MessageBoard/vi ... php?t=7783 / comments
Thanks for your post.
We happen to already have a case open for this, but it is quite a tricky issue.
The problem is that the syntax for a windows user and a windows group is exactly the same, so t...
Thanks for your post.
This a known issue (SDC-1024), which is currently scheduled to be fixed in the next minor release - SQL Data Compare 8.1.
I think this only affects the top table after the sync.
Thanks for taking the time to report this. / comments
Thanks for your post.
This a known issue (SDC-1024), which is currently scheduled to be fixed in the next minor release - SQL Data Compare 8.1.
I think this only affects the top table after the syn...
The datetime value in the results should be exactly what they are in the database.
Can you run a query in SSMS or Query Analyser to check the datetime columns in that table.
e.g. Select datetime_col from table / comments
The datetime value in the results should be exactly what they are in the database.
Can you run a query in SSMS or Query Analyser to check the datetime columns in that table.
e.g. Select datetime_co...
I haven't seen this before.
Can you turn logging on in SQL Compare 8.0? You can do this by right-clicking on the title bar with SQL Compare and select: Minimum Log Levels: Verbose
You can then find the logs using the same context menu after the comparison fails. - Presumably you will need to open SQL Compare again. / comments
I haven't seen this before.
Can you turn logging on in SQL Compare 8.0? You can do this by right-clicking on the title bar with SQL Compare and select: Minimum Log Levels: Verbose
You can then find...
Thanks for reporting this.
I can reproduce it consistently, so it certainly looks like a bug with SQL Compare.
I have logged it under the bug tracking code SC-4525, which will now be reviewed by the development team.
I don't think there is a workaround short of manually editing the script to remove the unnecessary comma. / comments
Thanks for reporting this.
I can reproduce it consistently, so it certainly looks like a bug with SQL Compare.
I have logged it under the bug tracking code SC-4525, which will now be reviewed by th...
Thanks for your post.
At what point during the comparison do you get the error, and what is the message?
When you compare a script folder to a live database, the comparison results will tell you which objects are missing, additional or different. If it finds an object that isn't in one of the schemas, it should report it as a schema difference, rather than throwing an error.
Did the script reader give you any parsing errors? / comments
Thanks for your post.
At what point during the comparison do you get the error, and what is the message?
When you compare a script folder to a live database, the comparison results will tell you wh...
Thanks for your post.
The process of registering a backup file shouldn't take any longer than previous versions, but it is not out of the question that it does. We have made some improvements to the reliability of the backup reader, and this could have been at the expense of performance.
Our support for backup files offers more for convenience, than it does to speed improvements over restoring the backup file and comparing the live db. Registering a backup file involves reading the file from disk, uncompressing the data, then writing most of it back to disk as it's not going to fit in memory. Because of this, it's probably not going to be any quicker than restoring the actual backup file to a temp db, but it is a lot more convenient. / comments
Thanks for your post.
The process of registering a backup file shouldn't take any longer than previous versions, but it is not out of the question that it does. We have made some improvements to th...
Thanks for your post.
I haven't seen this happen before.
Would you be able to send the snapshot file you used to support@red-gate.com
If you could add the reference F0025139 in the subject line, it will update the ticket we have opened for you.
I look forward to hearing from you. / comments
Thanks for your post.
I haven't seen this happen before.
Would you be able to send the snapshot file you used to support@red-gate.com
If you could add the reference F0025139 in the subject line, it...
Thanks for your post.
I have to agree with you, it's a shame there isn't much (or any) user feedback when registering a backup file.
This has been suggested before, and we already have an open feature request (SC-4523) for it.
I have added you comments to the suggestion.
Hopefully this will be improved in a future release. / comments
Thanks for your post.
I have to agree with you, it's a shame there isn't much (or any) user feedback when registering a backup file.
This has been suggested before, and we already have an open feat...
Hi,
That does sound like it would be the cause. The registry key contains the path to the service, and SQL Backup will only use this location if the key is there. It really should have been removed when you uninstalled.
Thanks for finding a workaround to the problem.
I'll make sure the dev team are aware of this. / comments
Hi,
That does sound like it would be the cause. The registry key contains the path to the service, and SQL Backup will only use this location if the key is there. It really should have been removed...