Unknown type - dbo.dbo
twistedstream
Posts: 3
I just fired up Data Compare 5 for the first time and got an error comparing 2 databases that compare fine in v4. Here's a screenshot:
Any ideas?
~pete
Any ideas?
~pete
Comments
Thanks,
~pete
This sounds like a mapping that has been performed incorrectly.
Data Compare uses the SQL Compare database registration so if it works in one it should in the other.
The screenshot shows that the mapping failed so as I suggested can you check this.
Regards
Dan
Red Gate Software Ltd
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
Project Manager
Red Gate Software Ltd
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.
Project Manager
Red Gate Software Ltd
my user-defined types are owned by 'dbo' and I'm getting the same error. I'm using SQLServer 2000.
Any progress on this fix?
Daire Cunningham
If it isn't I'll cry - one of those bugs that refuses to die.
Hope this helps.
Project Manager
Red Gate Software Ltd
Daire
Which version of SQL Server are you using?
Project Manager
Red Gate Software Ltd
The message is "Unknown type - sys.udtCode". udtCode is my user-defined data type {varchar(20)} and is in both DBs being compared.
The comaprison is between two different servers both with SQL Server 2000. Perhaps interestingly one server is version 8.00.194 and the other 8.00.2093 (SP4). Do you think applying SP4 to be dev server might fix it?
Daire
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
Project Manager
Red Gate Software Ltd
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.
Project Manager
Red Gate Software Ltd
I just attempted to use the 5.1.0.106 build of Data Compare and got Unknown Type - sys.Address. The user defined type of Address is owned by dbo in our SQL Server 2000. I received this problem in mutliple databases (all having our user defined types). One of them was just generated by a home grown app that creates the db based on creation scripts.
Any info on how to get around this would be great as I am suddenly stuck!
Thanks,
Joe Huber
A few assumptions we're making on this problem.
1) Only SQL 2000 is affected
2) udts in tables cause the error
3) The problem isn't connected with upgrading a database from SQL 7 to 2000
If anybody out there is experiencing the problem and doesn't match the assumptions I'm interested in hearing from you.
If anybody can give me any more information on exactly how they created the UDT or what script was run to create the problem that would be great and also the exact version of SQL 2000 you're running. Like I said we're unable to re-create the error in house so far.
Thanks everybody for any help in getting to the bottom of this.
Project Manager
Red Gate Software Ltd
If in the meantime a workaround is to edit the comparison project and de-select 'Include indexed views' in the Options tab.
Thanks guys for all of your help.
Project Manager
Red Gate Software Ltd