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)

>>