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.
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>
User Defined Table Type compare failing
Posted - 10/19/2009 : 17:18:31
Posted - 10/20/2009 : 16:18:34
