Comments
Sort by recent activity
Hmmm, is there any chance you can send me a snapshot of the schema of the databases on each server?
Not sure if it's a SP4 issue but that may be worth giving a try. We can't yet reproduce your error in-house but we're trying.
I'll pm you my email.
Thanks / comments
Hmmm, is there any chance you can send me a snapshot of the schema of the databases on each server?
Not sure if it's a SP4 issue but that may be worth giving a try. We can't yet reproduce your erro...
OK, thanks for the snapshots. We've had a look and what we're thinking is that maybe if the database was created on SQL Server 7 and then upgraded to SQL 2000 sometimes SQL Server doesn't set the user of the UDT correctly.
I've just been on the phone to another user who also has this problem, but even more interesting version 5.0 seemed to work.
We'll keep you posted on progress. If there is any way to get a database to me that exhibits the behaviour that would be fantastic.
Also if there is anybody else out there having this problem please let me know. / comments
OK, thanks for the snapshots. We've had a look and what we're thinking is that maybe if the database was created on SQL Server 7 and then upgraded to SQL 2000 sometimes SQL Server doesn't set the u...
What's the exact error message that you are receiving? At least I thought the error message was more sensible nowadays.
Which version of SQL Server are you using? / comments
What's the exact error message that you are receiving? At least I thought the error message was more sensible nowadays.
Which version of SQL Server are you using?
If you download the latest point release for SQL Bundle 5 - funnily enough called 5.1 this issue should be fixed.
If it isn't I'll cry - one of those bugs that refuses to die.
Hope this helps. / comments
If you download the latest point release for SQL Bundle 5 - funnily enough called 5.1 this issue should be fixed.
If it isn't I'll cry - one of those bugs that refuses to die.
Hope this helps.
Can I ask if you have any user defined types in your database and what they may be defined as. We came across this problem in testing and we thought we had it fixed.
Any information on types used would be most helpful - perhaps you could send me a SQL Compare snapshot of the structures of the two databases?
Thanks / comments
Can I ask if you have any user defined types in your database and what they may be defined as. We came across this problem in testing and we thought we had it fixed.
Any information on types used w...
After having a look at the snapshots that I've been sent we've found out that SQL Data Compare has a problem with user defined types in SQL 2000 that are owned by any user other than 'dbo'.
We're looking into this now and will hopefully get a fix out as soon as we can.
SQL 2005 and SQL Server 7 are unaffected you'll all be happy to hear. / comments
After having a look at the snapshots that I've been sent we've found out that SQL Data Compare has a problem with user defined types in SQL 2000 that are owned by any user other than 'dbo'.
We're l...
Thanks for confirming that so promptly.
Champagne has already been consumed. Buy it on monday [image] . / comments
Thanks for confirming that so promptly.
Champagne has already been consumed. Buy it on monday .
Well according to my trusty tester who has checked. We fixed a bug that could be that which you've found to do with the custom comparison key being on a field that contains a null value. We have fixed this in the next RC internally but it's unlikely that we'll released it as a 'beta'.
Can you just check if your varchar(255) field contains nulls in the source or destination as if there are any then it's certainly that problem.
Thanks. / comments
Well according to my trusty tester who has checked. We fixed a bug that could be that which you've found to do with the custom comparison key being on a field that contains a null value. We have fi...
We now have a beta with TFS 2013 support, this will go out in the next release.
If you want to try it just email support@red-gate.com and they can let you know the url to try it out. / comments
We now have a beta with TFS 2013 support, this will go out in the next release.
If you want to try it just email support@red-gate.com and they can let you know the url to try it out.
Thanks,
I've fixed it so the next version will create that directory on startup if it doesn't exist. / comments
Thanks,
I've fixed it so the next version will create that directory on startup if it doesn't exist.