Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?




 All Forums
 Support
 DB Ghost Support Forum
 User Defined Table Type compare failing
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mmiller_ot


10 Posts

Posted - 10/19/2009 :  17:18:31  Show Profile Send mmiller_ot a Private Message  Reply with Quote
I don't believe DBGhost can support the new User Defined Table Type in SQL 2008.

I can build a database from the object script, but when it tries to compare it, there is an error that says "cannot create data type" "an object or column name is missing". The object script is valid and I can run it directly on the server, however I believe DBGhost is treating the User Defined TABLE Type as a User Defined DATA Type, so it is failing its own syntax check.

Edited by - mmiller_ot on 10/19/2009 17:20:34

Google AdSense

USA
Mountain View


mmiller_ot



10 Posts

Posted - 10/20/2009 :  16:18:34  Show Profile Send mmiller_ot a Private Message  Reply with Quote
Create two SQL 2008 Databases. Run this on the first database and then compare them. It will fail.

-- Create the data type
CREATE TYPE dbo.TVP AS TABLE
(
c1 int NOT NULL,
c2 char(10) NULL,
c3 datetime NULL,
PRIMARY KEY (c1)
)
GO

10/20/2009 12:55:26 PM...Checking for differences with User Defined Data Types
10/20/2009 12:55:26 PM...Retrying failed change propagations
10/20/2009 12:55:26 PM...Retrying failed change propagations
10/20/2009 12:55:26 PM...Cannot create User Defined Data Type [dbo].[TVP]
10/20/2009 12:55:26 PM...<ERROR>
10/20/2009 12:55:26 PM...Cannot create User Defined Data Type [dbo].[TVP]
10/20/2009 12:55:26 PM...Cannot create User Defined Data Type [dbo].[TVP]
10/20/2009 12:55:26 PM...An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
10/20/2009 12:55:26 PM...</ERROR>
Go to Top of Page

jon.woolgar



105 Posts

Posted - 10/21/2009 :  03:15:05  Show Profile  Visit jon.woolgar's Homepage Send jon.woolgar a Private Message  Reply with Quote
Thanks for the detail Mike. This is definitely missing functionality. We will get it fixed a.s.a.p. I will keep you posted.


Regards Jon W
(Innovartis)
Go to Top of Page

jon.woolgar



105 Posts

Posted - 10/21/2009 :  03:24:04  Show Profile  Visit jon.woolgar's Homepage Send jon.woolgar a Private Message  Reply with Quote
Test Track item 497 created.

Regards Jon W
(Innovartis)
Go to Top of Page

mmiller_ot



10 Posts

Posted - 10/29/2009 :  15:00:13  Show Profile Send mmiller_ot a Private Message  Reply with Quote
Is there an ETA on User Defined Table Type support?
Go to Top of Page

mmiller_ot



10 Posts

Posted - 12/08/2009 :  12:03:40  Show Profile Send mmiller_ot a Private Message  Reply with Quote
Checking back in... This is really becoming a pain for our build process. Can you please provide an ETA? If it is too far out, we will need to look for another solution.
Go to Top of Page

jon.woolgar



105 Posts

Posted - 12/09/2009 :  07:18:00  Show Profile  Visit jon.woolgar's Homepage Send jon.woolgar a Private Message  Reply with Quote
I have been promised a fix next week. My expectation is, 70% confidence of a fix next week. Or 100 % confidence of a fix early Jan because someone will loose their Christmas holiday.

Regards Jon W
(Innovartis)
Go to Top of Page

jon.woolgar



105 Posts

Posted - 01/05/2010 :  07:07:14  Show Profile  Visit jon.woolgar's Homepage Send jon.woolgar a Private Message  Reply with Quote
OK now fixed it version 5.0.1144

Regards Jon W
(Innovartis)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free