Sorry for the late response, the diagram is generated by meta data. So if the databases are the same, you just have to create a new diagram. Its real simple, in the enterprise manager, just right click on diagrams and select create new diagram, then just follow the wizard. Any releationships will automatically be drawn, and when you update any table the diagram is automatically updated.

Eric


>When you mean 'recreate it', you mean maybe somehow I can create (or better SQL Server) a script to create them and then running it in the other database? The databases are the same, I'm just trying to avoid putting all the tables and links manually again on the diagram for the other database.
>
>Thanks.