locked
How to backup and restore Database Diagrams? RRS feed

  • 問題

  •  

    I need to backup some Database Diagrams from one SQL Server and restore the Database Diagrams to another SQL Server. How do I backup the Database Diagrams and how to restore them?

    Many thanks for replying.

    2007年10月4日 上午 05:33

解答

  • hi

     

    You can just backup your database (full backup) and restore it to another SQL Server.

     

     

     

    2007年10月4日 上午 07:29
  • If you use the SQL Server 7.0 or 2000, you could read the KB, How To Move a Database Diagram .

     

    Since the SQL Server 2005 had changed the previous setting, such as:

  • The diagram data is now stored in "sysdiagrams" and not "dtproperties"
  • "sysdiagrams" has only one row per diagram, whereas "dtproperties" has seven rows


    Therefore, if you use the SQL Server 2005, I will suggest you use Mr. Ying's way to do that.

2007年10月6日 上午 08:44
版主

所有回覆

  • hi

     

    You can just backup your database (full backup) and restore it to another SQL Server.

     

     

     

    2007年10月4日 上午 07:29
  • If you use the SQL Server 7.0 or 2000, you could read the KB, How To Move a Database Diagram .

     

    Since the SQL Server 2005 had changed the previous setting, such as:

  • The diagram data is now stored in "sysdiagrams" and not "dtproperties"
  • "sysdiagrams" has only one row per diagram, whereas "dtproperties" has seven rows


    Therefore, if you use the SQL Server 2005, I will suggest you use Mr. Ying's way to do that.

2007年10月6日 上午 08:44
版主