Compare Relations Diagram

• 
  Hi there,
  
  Not at this time I am afraid not. The main reason is that there are not any SQL commands that we can execute on a server to migrate a diagram.
  
  Sorry, regards
  
  Jonathan

  JonathanWatts May 17, 2007 06:31

  - 0 +
• 
  I'm already doing it using a script, but this require me 2 steps it would be nice if incorporated into SQL Compare
  
  the diagram is included in the system table dtproperties
  
  here is the script i'm using for copying the Diagrams in [baseipdev] to [baseipprod]
  
  DELETE FROM baseipprod..dtproperties
  
  TRUNCATE TABLE baseipprod..dtproperties
  
  SET IDENTITY_INSERT baseipprod..dtproperties ON
  
  INSERT INTO baseipprod..dtproperties (id, objectid, property, value, uvalue, lvalue, version)
  SELECT id, objectid, property, value, uvalue, lvalue, version
  FROM baseipdev..dtproperties
  
  SET IDENTITY_INSERT baseipprod..dtproperties OFF

  Powlin May 22, 2007 14:21

  - 0 +
• 
  I tried using SQL Data Compare but I'm unable to copy a system table

  Powlin May 22, 2007 14:32

  - 0 +

Add comment

Please sign in to leave a comment.