SQL Compare 6 - sysname as column datatype

• 
  You are comparing SQL 2000 and 2005 databases - however sadly in SQL Server 2000 you cannot use a fieldname called 'sysname', so you will have to rename it when comparing between the two versions.

  chris.buckingham April 09, 2008 12:01

  - 0 +
• 
  He is not talking about a field name he is talking about a datatype. This appears to be a RedGate error. Do you have a fix?

  kibbage July 24, 2008 00:43

  - 0 +
• 
  I'm not sure how you're getting a table with [dbo].[sysname] as a column type - do you have a user defined type of this name? When I try creating a table with:
  
  CREATE TABLE tab (id sysname, sid [sys].[sysname])
  
  it comes out as:
  
  CREATE TABLE [dbo].[tab]
  (
  [id] [sys].[sysname] NOT NULL,
  [sid] [sys].[sysname] NOT NULL
  ) ON [PRIMARY]
  
  GO
  
  So I'm not sure where your tables are getting the [dbo] from. If you could send me (michelle.taylor@red-gate.com) the script you used to create the problem table or a backup of the database with the problem table, I might be able to find out what's actually being reported by SQL Server about this table / what syntax it is that we don't understand properly.

  Michelle T July 28, 2008 06:37

  - 0 +
• 
  Michelle, I have emailed you the script. Let me know if you need any more information.

  kibbage July 28, 2008 13:37

  - 0 +
• 
  Just to update the thread in case anyone else has this problem, it looks like SQL Compare currently has a problem synchronizing sysname datatypes from SQL 2000 servers to SQL 2005 servers - we incorrectly add 'dbo' as the schema instead of 'sys'. This can be worked around by search and replace on the generated script (replacing [dbo].[sysname] with [sys].[sysname]).

  Michelle T July 29, 2008 07:07

  - 0 +
• 
  This still seems to be a problem in SQL Compare 7. Is there a patch out for this?

  JanetMcCallion February 03, 2009 16:16

  - 0 +
• 
  We've just fixed this internally, so it should be working in the final release of v8.

  Michelle T February 04, 2009 07:28

  - 0 +

Add comment

Please sign in to leave a comment.