View Single Post
  #4 (permalink)  
Old May 28th, 2007, 03:40 PM
motemape motemape is offline
Authorized User
 
Join Date: May 2007
Location: Oslo, , Norway.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I would like to try this method, as it appears to be the only alternative when using the wizard. It is best to have all SQL Script that populate tables

What is the consequences of droping the sysdiagrams table and other records on the system? Will it be possible to build it afterward? Does it matter?

Thanks again for valuable advices :)


<<

If you’re willing to give up the diagramming support from the source DB, you can drop the sysdiagrams table, and the related objects from your source DB before you run the wizard:

  sysdiagrams (table)
  fn_diagramobjects (Functions, Scalar Valued)
  sp_alterdiagram (Stored Procedure)
  sp_creatediagram (Stored Procedure)
  sp_dropdiagram (Stored Procedure)
  sp_helpdiagramdefinition (Stored Procedure)
  sp_helpdiagrams (Stored Procedure)
  sp_renamediagrams (Stored Procedure)
  sp_upgraddiagrams (Stored Procedure)

>>




Reply With Quote